TTable and quoted fieldnames in SQL

Thread View: comp.lang.pascal.delphi.databases

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Frank Thu, 12 May 2005 12:24

#37

Author: Frank
Date: Thu, 12 May 2005 12:24

16 lines
1308 bytes

I am using a TTable to connect to a MSSQL-table.

Sometimes Delphi generates SQL with quotes around fieldnames and
sometimes not when openeing the table.

E.g.

select ID, NAME from TABLE1
select "ID", "NAME" from "TABLE1"

I am using BDE, and as some of MSSQL-fieldnames are reserved words,
and i therefor always needs to use quotes. The reason the reserved
words are used, is that the applicaiton was ported from Sybase.


/frank

Re: TTable and quoted fieldnames in SQL

#36

Author: ramu
Date: Thu, 19 May 2005 04:41

11 lines
1476 bytes

Frank,

Even i'm facing the similar kind of issue. The applicaiton could be
from dbf files also. Where these reserved key words are allowed in
field names.

And since you are using SQL Server its better to use the ADO queries
istead of direct table connections.

Regards,
Rams

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads