How to find the response of a simple atomic Query?

[marc_3]

Hello,

I'm trying to to use UniQuery and I just need to select the last current Index from a database.

This is what I would like to do :

Code: Select all

if sql_UniQuery.Connection.Connected
      then begin
           sql_UniQuery.SQL.Text := 'SELECT MAX(TW_LEG_ID)FROM TW_LEG;';
           sql_UniQuery.Execute;


           id := sql_UniQuery.FieldByName('TW_LEG_ID').AsInteger; // I don't find a way to have the result                    

I know already that the connection work because I have been able to do the following update :
sql_UniQuery.SQL.Text := 'UPDATE TW_LEG SET AIRLINE_CD = ''AA'' WHERE TW_LEG_ID = 2;';

I don't find a way to have the result from the query back. I just want to have the ID that is an Integer
Does exists a simple way to have it directly through the UniQuery and how to do it?


Thanks for helping

BG

Marc_3

[azyk]

In the provided sample you are trying to retrieve a field named TW_LEG_ID. But there is no field with such name in the SELECT query. To retrieve the query execution result, you can call the field by index:

Code: Select all

  sql_UniQuery.SQL.Text := 'SELECT MAX(TW_LEG_ID) FROM TW_LEG;';
  sql_UniQuery.Execute;
  id := sql_UniQuery.Fields[0].AsInteger;

Or set an alias for the MAX() function in the SELECT query, in order to call the field by alias name:

Code: Select all

  sql_UniQuery.SQL.Text := 'SELECT MAX(TW_LEG_ID) AS TW_LEG_ID FROM TW_LEG;';
  sql_UniQuery.Execute;
  id := sql_UniQuery.FieldByName('TW_LEG_ID').AsInteger;

[marc_3]

Thanks for the answer, it helps much

BG