Eduardo Lopez wrote:
Hello all:
I've done querys using the UIB components to connect a Firebird server,
but allways doing something like ..."select field1, field2.... etc"
But now i must do a query like that:
qry1.SQL.Clear;
qry1.SQL.Text := 'SELECT MAX(FIELD1) FROM TABLE1';
qry1.Open;
If I try to get the value using FieldByName it tells me that the field
don't exists.
What is the correct way to do that?
TIA. Eduardo.
What about : select Max(Field1) as Maximum from Table1
qry1.FieldByName('Maximum').AsInteger
Regards
Boguslaw
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
