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

Thanks everyone for your help.

All sorted.


"Ian Groves" <ian@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message 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




.

Relevant Pages

  • Re: Used a reserved word in a field name.....
    ... connection to run.... ... 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 just created a table Named Containers with a single field named Number in an existing Access 2002 database table. ... Wildlife Technical Programs Lead ...
    (borland.public.delphi.database.ado)
  • Re: The network path was not found
    ... I fail to open a second pc on my small network. ... Right click Local Area Connection. ... If it fails either way there's an IP or Name resolution problem. ... Pull the power from the router. ...
    (microsoft.public.windowsxp.help_and_support)
  • RE: Losing demand dial internet connection
    ... about 4 weeks after you run CEICW and then fails. ... 825763 How to configure Internet access in Windows Small Business Server ... In the list of devices, select the modem that the dial-up DoD connection ... Is ISA server installed on the SBS 2003 Server? ...
    (microsoft.public.windows.server.sbs)
  • Re: Bizarre remote access problem
    ... Is it always the same machine which fails, ... This problem can be caused by the DSL router at the branch. ... Both branch computers are running W2000 SP4. ... computers' connection attempts are getting to the server. ...
    (microsoft.public.windows.server.networking)
  • Re: Dynamic Properties and DTS Source Text File
    ... I already have success and fail precedences in place and close connection ... Dynamic properties>> pass goes to SQL tsk to truncate destination SQL table ... Any fails send a corresponding e-mail alert. ...
    (microsoft.public.sqlserver.dts)