Mikem
|
| Posted: 08/10/2005, 1:23 PM |
|
When trying to sort my grid, I am getting an error message.
Error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Doc ID'.
Anyone have any ideas.
Thanks
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 08/10/2005, 2:01 PM |
|
Do you maybe have a field named "Doc ID" in the database?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
Mikem
|
| Posted: 08/10/2005, 6:43 PM |
|
Yes I do. Why does that Make a difference?
|
|
|
|
DonB
|
| Posted: 08/10/2005, 8:35 PM |
|
With a space in it? That's a no-no, use [Doc Id]
--
DonB
http://www.gotodon.com/ccbth
"Mikem" <Mikem@forum.codecharge> wrote in message
news:642faad557e715@news.codecharge.com...
> Yes I do. Why does that Make a difference?
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
peterr
Posts: 5971
|
| Posted: 08/10/2005, 10:33 PM |
|
Even if this was a bug in CCS (small chance) it makes a difference because it explains the problem. If you answered "No" then we would need to look for the problem elsewhere.
Don is right that if you manually entered an SQL query into grid's data source then the required syntax is to use square brackets.
If CCS itself is creating such syntax then you may want to contact support.
Generally using spaces in database field names is allowed only in a few databases, but often not recommended as it requires workarounds in SQL.
In your case I also recommend that you check the data source of your grid, and the control source of your field that uses "Doc ID". If you see "Doc ID" anywhere try putting it into square brackets.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
mikem
|
| Posted: 08/11/2005, 12:54 PM |
|
Thanks guys. I should know better. Everything works perfectly now!
|
|
|
|
