Space in table name problem with .NET scripting

The table names in my database schema have spaces. When the .tab files are
created in Visual Studio, the constraint names do not have brackets around
them causing a syntax error.

Is there a setting to turn brackets on at all times? This is the only
situation where it is a problem, all other table name references in all other
scripts contain brackets.

re: Space in table name problem with .NET scripting

You should go back and rename the table names to not have spaces in them
(that's database design 101). Also, .NET doesn't use scripts. It is
compiled code.

"Oggdorf" <Oggdorf@discussions.microsoft.com> wrote in message
news:D6446EA8-046A-413D-BBFC-F1311DC9B9EC@microsoft.com...[color=blue]
> The table names in my database schema have spaces. When the .tab files
> are
> created in Visual Studio, the constraint names do not have brackets around
> them causing a syntax error.
>
> Is there a setting to turn brackets on at all times? This is the only
> situation where it is a problem, all other table name references in all
> other
> scripts contain brackets.[/color]

re: Space in table name problem with .NET scripting

You should go back and rename the table names to not have spaces in them
(that's database design 101). Also, .NET doesn't use scripts. It is
compiled code.

"Oggdorf" <Oggdorf@discussions.microsoft.com> wrote in message
news:D6446EA8-046A-413D-BBFC-F1311DC9B9EC@microsoft.com...[color=blue]
> The table names in my database schema have spaces. When the .tab files
> are
> created in Visual Studio, the constraint names do not have brackets around
> them causing a syntax error.
>
> Is there a setting to turn brackets on at all times? This is the only
> situation where it is a problem, all other table name references in all
> other
> scripts contain brackets.[/color]

re: Space in table name problem with .NET scripting

Thanks for the reply, however I know what i'm doing and why. Neither the
criticism "(that's database design 101)", nor the ignorance ".NET doesn't use
scripts" assist me in resolving what appears to be a bug.

"Scott M." wrote:
[color=blue]
> You should go back and rename the table names to not have spaces in them
> (that's database design 101). Also, .NET doesn't use scripts. It is
> compiled code.
>
> "Oggdorf" <Oggdorf@discussions.microsoft.com> wrote in message
> news:D6446EA8-046A-413D-BBFC-F1311DC9B9EC@microsoft.com...[color=green]
> > The table names in my database schema have spaces. When the .tab files
> > are
> > created in Visual Studio, the constraint names do not have brackets around
> > them causing a syntax error.
> >
> > Is there a setting to turn brackets on at all times? This is the only
> > situation where it is a problem, all other table name references in all
> > other
> > scripts contain brackets.[/color]
>
>
>[/color]

re: Space in table name problem with .NET scripting

Thanks for the reply, however I know what i'm doing and why. Neither the
criticism "(that's database design 101)", nor the ignorance ".NET doesn't use
scripts" assist me in resolving what appears to be a bug.

"Scott M." wrote:
[color=blue]
> You should go back and rename the table names to not have spaces in them
> (that's database design 101). Also, .NET doesn't use scripts. It is
> compiled code.
>
> "Oggdorf" <Oggdorf@discussions.microsoft.com> wrote in message
> news:D6446EA8-046A-413D-BBFC-F1311DC9B9EC@microsoft.com...[color=green]
> > The table names in my database schema have spaces. When the .tab files
> > are
> > created in Visual Studio, the constraint names do not have brackets around
> > them causing a syntax error.
> >
> > Is there a setting to turn brackets on at all times? This is the only
> > situation where it is a problem, all other table name references in all
> > other
> > scripts contain brackets.[/color]
>
>
>[/color]

re: Space in table name problem with .NET scripting

It's not criticism. It's good database design to not use spaces in the
table names. And, it was not criticism to tell you that you that .NET
isn't scripting.

Now, perhaps if you took a breath and gave us more information, we could
help you. You could start by telling us why your tables need to have spaces
in their names. Maybe we could suggest a work around. But the first piece
of advice you are going to get if you just tell us that the spaces in your
table names are causing problems it to solve the problem at the source.


"Oggdorf" <Oggdorf@discussions.microsoft.com> wrote in message
news:A8D12C8B-2145-4C3E-8B6E-D07EA39CE6D8@microsoft.com...[color=blue]
> Thanks for the reply, however I know what i'm doing and why. Neither the
> criticism "(that's database design 101)", nor the ignorance ".NET doesn't
> use
> scripts" assist me in resolving what appears to be a bug.
>
> "Scott M." wrote:
>[color=green]
>> You should go back and rename the table names to not have spaces in them
>> (that's database design 101). Also, .NET doesn't use scripts. It is
>> compiled code.
>>
>> "Oggdorf" <Oggdorf@discussions.microsoft.com> wrote in message
>> news:D6446EA8-046A-413D-BBFC-F1311DC9B9EC@microsoft.com...[color=darkred]
>> > The table names in my database schema have spaces. When the .tab files
>> > are
>> > created in Visual Studio, the constraint names do not have brackets
>> > around
>> > them causing a syntax error.
>> >
>> > Is there a setting to turn brackets on at all times? This is the only
>> > situation where it is a problem, all other table name references in all
>> > other
>> > scripts contain brackets.[/color]
>>
>>
>>[/color][/color]

re: Space in table name problem with .NET scripting

It's not criticism. It's good database design to not use spaces in the
table names. And, it was not criticism to tell you that you that .NET
isn't scripting.

Now, perhaps if you took a breath and gave us more information, we could
help you. You could start by telling us why your tables need to have spaces
in their names. Maybe we could suggest a work around. But the first piece
of advice you are going to get if you just tell us that the spaces in your
table names are causing problems it to solve the problem at the source.


"Oggdorf" <Oggdorf@discussions.microsoft.com> wrote in message
news:A8D12C8B-2145-4C3E-8B6E-D07EA39CE6D8@microsoft.com...[color=blue]
> Thanks for the reply, however I know what i'm doing and why. Neither the
> criticism "(that's database design 101)", nor the ignorance ".NET doesn't
> use
> scripts" assist me in resolving what appears to be a bug.
>
> "Scott M." wrote:
>[color=green]
>> You should go back and rename the table names to not have spaces in them
>> (that's database design 101). Also, .NET doesn't use scripts. It is
>> compiled code.
>>
>> "Oggdorf" <Oggdorf@discussions.microsoft.com> wrote in message
>> news:D6446EA8-046A-413D-BBFC-F1311DC9B9EC@microsoft.com...[color=darkred]
>> > The table names in my database schema have spaces. When the .tab files
>> > are
>> > created in Visual Studio, the constraint names do not have brackets
>> > around
>> > them causing a syntax error.
>> >
>> > Is there a setting to turn brackets on at all times? This is the only
>> > situation where it is a problem, all other table name references in all
>> > other
>> > scripts contain brackets.[/color]
>>
>>
>>[/color][/color]