BDE and Access with spaces in column names

BDE and Access with spaces in column names

Post by G. Scott L » Tue, 07 Oct 2003 04:54:03


I know some will argue that Access should not be talked about in a "SQL
Servers" newsgroup, but I can't find anywhere else to ask this!

I am using BDE 5.11 and Delphi 5 to put some data into an MS Access database
from my Interbase database. I have everything "talking" ok, but the Access
tables have column names like "Certificate Number" (with the space) and such
and the BDE doesn't seem to like this.

Is there anyway to get around this without modifying the column names???

TIA

Scott
 
 
 

BDE and Access with spaces in column names

Post by Andy » Tue, 07 Oct 2003 07:21:08

put the field name in square brackets.
ie
[Certificate Number]

Andy


database
Access
such

 
 
 

BDE and Access with spaces in column names

Post by G. Scott L » Tue, 07 Oct 2003 07:34:48

I figured it was something easy, and I tried several things, but square
brackets wasn't one of my tries.

Thanks!!!!