Search found 7 matches

Go to advanced search

by Rumburak
Tue May 15, 2007 9:41 am
Forum: Feature Requests
Topic: Unicode support for SQL-Scripts
Replies: 1
Views: 4725
 
Jump to post

Unicode support for SQL-Scripts

We need Unicode support for SQL-Scripts.
The use of german letters (like ä, ö, ü) is inevitable for us.

Regards,
Stephan
by Rumburak
Fri Apr 20, 2007 11:43 am
Forum: Common Problems
Topic: no "GOTO" in SQL-Script possible
Replies: 3
Views: 6673
 
Jump to post

I think its simple:
The statement seperator "GO" collidates with the "GOTO"-command
Make youself a script like:

Code: Select all

GOTO zzz
zzz:
and you will get the error:
SQLExecDirect {SQL Error}: [Microsoft][ODBC SQL Server Driver][SQL Server]incorrect syntax near the keyword 'TO'
by Rumburak
Thu Apr 19, 2007 10:24 am
Forum: Common Problems
Topic: no "GOTO" in SQL-Script possible
Replies: 3
Views: 6673
 
Jump to post

no "GOTO" in SQL-Script possible

Hello,

I found out that the "GOTO"-statement (T-SQL) in not possible in SQL-Scripts.
(MS-SQLServer)
Do I have to change all my scripts or is there a workaround?

Regards,
Stephan
by Rumburak
Tue Apr 17, 2007 2:37 pm
Forum: Common Problems
Topic: SQLExecDirect {SQL no data}
Replies: 1
Views: 3655
 
Jump to post

SQLExecDirect {SQL no data}

Hello,

when executing an SQL-Script like this:
update table1
set xxx='new_value'
from table1 where xxx='old_value
AI reports the Error "SQLExecDirect {SQL no data}" and stops executing.
This is only the case when there are no rows selected to update.

The same script is no problem in the SQL ...
by Rumburak
Mon Mar 26, 2007 9:46 am
Forum: Common Problems
Topic: SQL Script Execution
Replies: 9
Views: 14009
 
Jump to post

by Rumburak
Thu Mar 22, 2007 1:38 pm
Forum: Common Problems
Topic: SQL Script Execution
Replies: 9
Views: 14009
 
Jump to post

I found the reason:
You must not use "#" in SQL-Scripts!
IMHO its a bug in AI.
by Rumburak
Wed Mar 21, 2007 2:45 pm
Forum: Common Problems
Topic: SQL Script Execution
Replies: 9
Views: 14009
 
Jump to post

I have the same Problem with SQL Server 2005 and SQL Server 7, so I know the problem doesnt come with the Server-version.
When I use the statement separator "GO" I get this error message:
SQLExecDirect {SQL Error}: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'TABLE'.

This ...

Go to advanced search