dbTalk Databases Forums  

Alternate to GOTO Statement in ASA

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss Alternate to GOTO Statement in ASA in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ollie
 
Posts: n/a

Default Alternate to GOTO Statement in ASA - 12-16-2003 , 09:28 AM






I found a situation were I need to branch out from a block
of code and continue at a specific block of code. GOTO
statement would be ideal for this, but it seems ASA does not
support GOTO statement. Can I get an advice from anyone how
to do something like this in ASA.


Ollie

Reply With Quote
  #2  
Old   
Chris Keating \(iAnywhere Solutions\)
 
Posts: n/a

Default Re: Alternate to GOTO Statement in ASA - 12-16-2003 , 10:39 AM






You should be able to rewrite the logic so as to avoid GOTO altogether If
you must use GOTO, the TSQL dialect does support the statement GOTO.
--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

************************************************** **************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

************************************************** **************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

************************************************** **************************
*

<Ollie> wrote

Quote:
I found a situation were I need to branch out from a block
of code and continue at a specific block of code. GOTO
statement would be ideal for this, but it seems ASA does not
support GOTO statement. Can I get an advice from anyone how
to do something like this in ASA.


Ollie



Reply With Quote
  #3  
Old   
Ollie
 
Posts: n/a

Default Re: Alternate to GOTO Statement in ASA - 12-16-2003 , 11:03 AM



This is about 50 lines of code that someone else wrote. I
would like as minimal impact as possible to the code. And
GOTO statement would have very minimal code change.

The documentation I have stated that ASA does not support
GOTO statement, but the doc is for SQL Anywhere 5.0. Does
the later release support the feature?

Quote:
You should be able to rewrite the logic so as to avoid
GOTO altogether If you must use GOTO, the TSQL dialect
does support the statement GOTO. --

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

************************************************** ********
****************** *
Sign up today for your copy of the SQL Anywhere Studio 9
Developer Edition and try out the market-leading database
for mobile, embedded and small to medium sized business
environments for free!

http://www.ianywhere.com/promos/deved/index.html

************************************************** ********
****************** *

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at
http://www.iAnywhere.com/developer ** EBFs can be found at
http://downloads.sybase.com/swx/sdmain.stm ** Use
CaseXpress to report bugs http://casexpress.sybase.com

************************************************** ********
****************** *

Ollie> wrote in message
news:3fdf2655.2e65.846930886 (AT) sybase (DOT) com... I found a
situation were I need to branch out from a block of code
and continue at a specific block of code. GOTO statement
would be ideal for this, but it seems ASA does not
support GOTO statement. Can I get an advice from anyone
how to do something like this in ASA.


Ollie



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.