Rumburak
Posts: 7
Joined: Wed Mar 21, 2007 12:46 pm

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
gigi
Posts: 2103
Joined: Tue Apr 11, 2006 9:55 am
Contact: Website

Hi Stephan,

In order to investigate the problem please send a small test project (AIP + SQL script file) reproducing this issue to support at advancedinstaller dot com.

Regards,
Gigi
______________
Gheorghe Rada
Advanced Installer Team
http://www.advancedinstaller.com
Rumburak
Posts: 7
Joined: Wed Mar 21, 2007 12:46 pm

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'
gigi
Posts: 2103
Joined: Tue Apr 11, 2006 9:55 am
Contact: Website

Hi,

We acknowledge the problem. Thank you for bringing it to our attention. We already fixed it and the fix will be available in the next version of Advanced Installer scheduled for release at the beginning of the next month.

If you need a fix urgently please let us know.

Regards,
Gigi
______________
Gheorghe Rada
Advanced Installer Team
http://www.advancedinstaller.com

Return to “Common Problems”