Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Access fields and table non contiguous (with blank)
HI,
I created a connection to an Access database. While I can create a remote view without any problem (even the table name has a blank) , I do have some problem with the syntax. I need to query the view like this
SELECT MyRemoteVIew."My Field" from MyRemoteView where anotherfield = "some value"
I get the message : "Syntax error". And when I try :
SELECT "My Field" from MyRemoteViewo where anotherfield = "some value", I get several records that has "My Field" as a value (tge same occurs when I use [My Filed].
I know that with ADO I can resolve the problem with [My Table].[My Field].
Anybody has done something similar ?
Thank you,
Christian Cote
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement