Re: Used a reserved word in a field name.....

From: Charles Tyson <cmtNOSPAMzeebox@xxxxxxxxxxxxx>
Date: Mon, 25 Feb 2008 14:29:01 -0800

Jon Purvis beat me to it--I don't get any error with your commandtext when using D2007 against either an Access 2002 or Access 2007 database. But if you need something else to try, this syntax is acceptable to JET:

SELECT * FROM containers WHERE [containers]![number] > 10

Ian Groves wrote:

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?

References:
- Used a reserved word in a field name.....
  - From: Ian Groves

Prev by Date: Re: Used a reserved word in a field name.....
Next by Date: Re: Used a reserved word in a field name.....
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):
- Date
- Thread

Relevant Pages

Re: Importing data from Access to Excel, but I need to vary the table from Access
... I don't want the variable to be the database but the table itself. ... .CommandText = Array(_ ... .PreserveFormatting = True ... .RefreshStyle = xlInsertDeleteCells ...
(microsoft.public.excel.programming)
Re: Firebird / InterBase Structure Updater
... Jon Purvis wrote: ... We use Firebird as the database. ... for every single database change I have made since the first ... > statements that bring it up to date, and the final statement changes the ...
(borland.public.delphi.thirdpartytools.general)
Re: using dataadapter.update changes the insertcommand.commandtext
... changing the commandtext and from the code here, ... >I have a dataadapter where i have changed the insertcommand.commandtext to ... the dataset's identity column is not updated with ... > is in the database, and when I inspect the insertcommand.commandtext right ...
(microsoft.public.dotnet.framework.adonet)
Best Way to Test Against a Database
... What is the best way to test my methods that hit a database? ... that I have my CommandText, ... Then I can test my update by passing a bogus primary key ...
(microsoft.public.dotnet.languages.csharp)
Re: strange behaviour: ADODataSet returns different number of records depending on presence of ORDER
... >Found the following strange behaviour with TADODataSet: ... >If there is an ORDER BY clause in the CommandText, ... Since you database is Access my guess is the difference is caused by a corrupt ...
(borland.public.delphi.database.ado)