CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Space in table name of SQL serves raises problems

Print topic Send  topic

Author Message
Jos Groot Lipman
Posted: 02/20/2001, 7:48 AM

Using the MS SQL Server sample database NorthWind, tabel 'Order Details'

This table contains a space in the name (bad habit anyway) and CodeCharge
cannot handle this well. The generated SQL statement does something like
SELECT ..... FROM Order Details O ORDER BY ......
where it should read
SELECT ..... FROM [Order Details] O ORDER BY ......
for SQL Server.

Solved it for the time being by renaming the table to 'Order_Details'
--
J. Groot Lipman
Dijkoraad IT bv


Alexey Alexapolsky
Posted: 02/20/2001, 8:54 AM

Thanks , we'll fix this feature in the nearest future.

--
Regards,
Alexey
CodeCharge Support


Jos Groot Lipman <dontspam@home.nl> wrote in message ...
> Using the MS SQL Server sample database NorthWind, tabel 'Order Details'
>
> This table contains a space in the name (bad habit anyway) and CodeCharge
> cannot handle this well. The generated SQL statement does something like
> SELECT ..... FROM Order Details O ORDER BY ......
> where it should read
> SELECT ..... FROM [Order Details] O ORDER BY ......
> for SQL Server.
>
> Solved it for the time being by renaming the table to 'Order_Details'
> --
> J. Groot Lipman
> Dijkoraad IT bv
>
>
>

Alexey Alexapolsky
Posted: 02/22/2001, 4:32 AM

It's considered a good practise not to give tables names
with spaces. But if you still want to use it you can manually
edit code generated by CodeCharge, and use [correct syntax].


Regards,
Alexey
CodeCharge Support


Jos Groot Lipman <dontspam@home.nl> wrote in message
news:96u3kt$5ch$1@news.codecharge.com...
> Using the MS SQL Server sample database NorthWind, tabel 'Order Details'
>
> This table contains a space in the name (bad habit anyway) and CodeCharge
> cannot handle this well. The generated SQL statement does something like
> SELECT ..... FROM Order Details O ORDER BY ......
> where it should read
> SELECT ..... FROM [Order Details] O ORDER BY ......
> for SQL Server.
>
> Solved it for the time being by renaming the table to 'Order_Details'
> --
> J. Groot Lipman
> Dijkoraad IT bv
>
>
>

Alexey Alexapolsky
Posted: 02/22/2001, 9:31 AM

You can also create a view with normal name for this table , and use
this view in CodeCharge. Views are almost as fast as tables.

--
Regards,
Alexey
CodeCharge Support




--
Regards,
Alexey
CodeCharge Support

Jos Groot Lipman <dontspam@home.nl> wrote in message
news:96u3kt$5ch$1@news.codecharge.com...
> Using the MS SQL Server sample database NorthWind, tabel 'Order Details'
>
> This table contains a space in the name (bad habit anyway) and CodeCharge
> cannot handle this well. The generated SQL statement does something like
> SELECT ..... FROM Order Details O ORDER BY ......
> where it should read
> SELECT ..... FROM [Order Details] O ORDER BY ......
> for SQL Server.
>
> Solved it for the time being by renaming the table to 'Order_Details'
> --
> J. Groot Lipman
> Dijkoraad IT bv
>
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.