Re: Used a reserved word in a field name.....
- From: "Viatcheslav Valerievitch Vassiliev" <support@xxxxxxxxxxxxxxx>
- Date: Tue, 26 Feb 2008 14:40:01 +0300
Use brackets [Number] or quotes `Number` (it is not single quotes).
//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"Ian Groves" <ian@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> сообщил/сообщила в новостях следующее: news:47c30f81$1@xxxxxxxxxxxxxxxxxxxxxxxxx
I have a MS Access Database and use TADODataset.commandtext and use a JET connection to run....
SELECT * FROM Containers WHERE Number > 10
Of course this fails as I have used the field name NUMBER, aside from restructing the table and my app how can i get around this?
I have tried
SELECT * FROM Containers WHERE [Number] > 10
SELECT * FROM Containers WHERE "Number" > 10
SELECT * FROM Containers WHERE 'Number' > 10
with no luck.
Thanks in Advance for any support given.
Ian Groves
.
- References:
- Used a reserved word in a field name.....
- From: Ian Groves
- Used a reserved word in a field name.....
- Prev by Date: Re: XML import/export for ADO
- Next by Date: Brain Dead on SQL statement
- Previous by thread: Re: Used a reserved word in a field name.....
- Next by thread: Re: Used a reserved word in a field name.....
- Index(es):
Relevant Pages
|
