SQL syntax error

Question

I want to run a simple SQL from Delphi 2007.

I use AdoQuery. My table has a column id and data type is int (autoincrement).

My question is if I execute

select * from comlist

there is no problem, it runs. But if I define a field on SQL like

select compname from comlist

Delphi complains

ado:Field 'id' not found

The Compname column exist in table.

I have the following fields on my table:

id int
creationdate datetime
compid nvarcahr(50)
complocation nvarchar(50)
serial nvarchar(50) 
compname nvarchar(50)

I have error with this code:

ado.Close;
ado.SQL.Clear;
ado.SQL.Add('SELECT   compname  FROM comlist');
ado.Open;

I have no error with this code:

ado.Close;
ado.SQL.Clear;
ado.SQL.Add('SELECT * FROM comlist');
ado.Open;

What could be the problem?

Please double check from table definition, the spelling of column(compname) you specifying in select query. — Pawan
– Pawan, Commented Sep 12, 2013 at 9:51
Hi but I get this error whatever I write as column. for ex tried with other columns like compid or complocation. but result is same — Hakan Subaşı
– Hakan Subaşı, Commented Sep 12, 2013 at 9:55
Please, show us the structure of that comlist table! What columns, what datatypes? — marc_s
– marc_s, Commented Sep 12, 2013 at 9:56
can you output a sample of results of SELECT * FROM comlist? — Squirrel5853
– Squirrel5853, Commented Sep 12, 2013 at 9:57
Please do not put code samples or sample data into comments - since you cannot format it, it's extremely hard to read it.... Instead: update your question by editing it to provide that additional information! Thank you. — marc_s
– marc_s, Commented Sep 12, 2013 at 10:02

J.Pelttari · Accepted Answer · 2013-09-12 10:51:35Z

5

You might have fields defined in your query component. Select ADOQuery component and open Fields editor from context menu and remove fields.

answered Sep 12, 2013 at 10:51

J.Pelttari

5163 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

kobik Over a year ago

+1 My thoughts exactly. (persistent fields defined in design mode)

Hakan Subaşı Over a year ago

I dont understand why it happen (Becasue I use all field on field editor for every query ) but your suggestion solved my problem

Disillusioned Over a year ago

@HakanSubaşı The error is because the fields in the field editor are the ones your ADOQuery expects to get back from the database. But since you changed your query, those fields are no longer returned by the database.

Collectives™ on Stack Overflow

SQL syntax error

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related