SQLQuery field not found on ubuntu

[Gebo]

I want an id value of an item from sqlquery by this code

Code: Pascal  [Select][+][-]

1. SQLQuery1.Fields[0].AsInteger;
2.  

but it show me a message that tell me " SQLQuery field not found ".
that is on ubuntu but It is working on windows.

[dseligo]

Did you check if you have records in your query?

Try this:

Code: Pascal  [Select][+][-]

1. If not SQLQuery1.EOF then
2. begin
3.   // do something with SQLQuery1.Fields[0].AsInteger
4. end
5. else
6.   ShowMessage('No records.');

[Zvoni]

This is not making any sense.
the "content" of a Database (Table, Column) doesn't care if it's "stored" on windows, linux, FreeBSD or my sock-drawer.
Without seeing any Code (specifically the SQL-Statement) it's like gazing into a crystal ball

[Gebo]

I already have 3 records but I want to delete a record that user selected on dbgrid by id .
I want to get the id field of the record selected to delete it by sql query statement.

[rvk]

Try to put some debug logging in your program.

For example... put the following above that line that produces the error:

Code: Pascal  [Select][+][-]

1.   Showmessage('FieldCount = ' + SQLQuery1.Fields.Count.ToString);
2.   Showmessage('Fields[0].FieldName = ' + SQLQuery1.Fields[0].FieldName);

If the first gives you FieldCount > 0 then the second should work.
If the first gives you 0 then you don't have any fields defined.

The field definition should be done automatically during opening (if they are not predefined by you).

I normally use SQLQuery1.FieldByName('id').AsInteger to get to a particular field.
(Much easier than assuming the first field is the one you want)

If it still doesn't work then you need to show more code.

[Gebo]

when I use showmessage It shows me the field name "id" but when use

Code: Pascal  [Select][+][-]

1. SQLQuery1.FieldByName('id').AsInteger
2.  

I get the message sqlquery field not found.

[nummer8]

What is the SqlQuery1.SQL.Text ?

[dseligo]

when I use showmessage It shows me the field name "id" but when use

I am not sure I understand this. Are you saying that 'SQLQuery1.Fields[0].AsInteger;' works and that 'SQLQuery1.FieldByName('id').AsInteger' doesn't work?

Code: Pascal  [Select][+][-]

1. SQLQuery1.FieldByName('id').AsInteger
2.  

I get the message sqlquery field not found.

Did you test SQLQuery1.Eof as in reply #1?

[Thaddy]

Can it just be a matter of CASE, like ID?

[Zvoni]

Why don't we just play a bit of Lottery, or throw some dice around?

UNTIL TS SHOWS HIS DAMNED SQL-Statement!

[Thaddy]

Good point.

[dseligo]

Why don't we just play a bit of Lottery, or throw some dice around?

UNTIL TS SHOWS HIS DAMNED SQL-Statement!

And what RDBMS he use.

[rvk]

when I use showmessage It shows me the field name "id" but when use

Code: Pascal  [Select][+][-]

1. SQLQuery1.FieldByName('id').AsInteger
2.  

I get the message sqlquery field not found.

And also show EXACT error message and the relevant pascal code.
It could just be a typo in your code.

[Gebo]

Thanks all.
the problem is I was close sqlquery and change sql statement then I write the line code.
I fixed it by using a variable.