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
>
>
>
|
|
|
|