Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

View Syntax

3 views
Skip to first unread message

Jamie

unread,
Oct 20, 2003, 11:52:27 AM10/20/03
to
I am using V.8 of P-Designer to maintain and model a SQL Server 2000
database.

When I create Views that have [] brackets they seem to disappear from
the script when it is created. For example:

SELECT dbo.DealingActivity.ProcessTime AS [Total Process Time],

becomes

SELECT dbo.DealingActivity.ProcessTime AS ,

Which isn't much use. I have had a look in the definition file and
checked that the user defined box is checked. I do notknow where else
to look. Has anyone else come accross this or have any suggestions
how to fix it.

Thanks in Advance Jamie

0 new messages