Re: ADO and DBGrid and DbEdit
From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 09/22/04
- Next message: Brian Bushay TeamB: "Re: ADO and DBGrid and DbEdit"
- Previous message: Brian Bushay TeamB: "Re: Reset autonumber field in MS Access"
- In reply to: Richard Caruana: "Re: ADO and DBGrid and DbEdit"
- Next in thread: Richard Caruana: "Re: ADO and DBGrid and DbEdit"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 21 Sep 2004 21:13:34 -0500
>After trying what you said the error message now says
>'EDatabaseError message ADOQuery1 : field 'index' not found'
>
>It is there because I checked ???
Index is an SQL key word so using it as a field name will get you nothing but
problems.
You can try modifying your select to put the field in [] brackets
Select [Index] from yourTable
That may work
-- Brian Bushay (TeamB) Bbushay@NMPLS.com
- Next message: Brian Bushay TeamB: "Re: ADO and DBGrid and DbEdit"
- Previous message: Brian Bushay TeamB: "Re: Reset autonumber field in MS Access"
- In reply to: Richard Caruana: "Re: ADO and DBGrid and DbEdit"
- Next in thread: Richard Caruana: "Re: ADO and DBGrid and DbEdit"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]