SteveS
Posts: 41
|
| Posted: 02/27/2004, 12:20 PM |
|
Ok, so I know that having spaces in table names is a big 'no no', however, having had syntax errors all day I started putting underscores in my field names and my syntax errors dissapear!
My question is why? Is this right? Do I need to change every space to an underscore in every single field in all of my tables?
I would apprechaite any insight into this!
Many thanks in advance.
Regards,
Steve.
|
 |
 |
DonB
|
| Posted: 02/27/2004, 2:08 PM |
|
Nope. Just enclose them in brackets: [some table]. That's a de-facto
standard construct for handling names that do not conform to naming
standards (or when they are reserved words). It's very common where the
database is Access, because Access sort of encourages us to create names
with spaces, etc.
--
DonB
http://www.gotodon.com/ccbth
"SteveS" <SteveS@forum.codecharge> wrote in message
news:6403fa689512bb@news.codecharge.com...
> Ok, so I know that having spaces in table names is a big 'no no', however,
having had syntax errors all day I started putting underscores in my field
names and my syntax errors dissapear!
>
> My question is why? Is this right? Do I need to change every space to an
underscore in every single field in all of my tables?
>
> I would apprechaite any insight into this!
>
> Many thanks in advance.
>
> Regards,
>
> Steve.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
peterr
Posts: 5971
|
| Posted: 02/27/2004, 8:43 PM |
|
You may also need to select "MS Access" as your database in both the Design and Server Connection settings.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Maduko
|
| Posted: 12/17/2004, 12:38 PM |
|
What if you have already but Code Charge isn't putting [ ]s around the field names.
|
|
|
|
JRB
Posts: 10
|
| Posted: 12/17/2004, 12:45 PM |
|
What is Access is selected yet reserved words are still not being handled correctly?
I am working with a table that has a field named Event. Code Charge is not putting [Event] in the ASP pages I generate.
Unfortunately there are dozens of other pages linked to this DB so I can't just rename the field.
_________________
\\
|
|
|
|
dotnetjunkie
Posts: 1
|
| Posted: 01/09/2005, 8:57 AM |
|
Using square brackets works for the SELECT statement. However, when using INSERT INTO [table name] it seems to bomb. Does anyone know of any workarounds?
|
|
|
|
|
