SQL for Reality > SQL Stored Procedures > CONTINUE Statement

Documentation Comments

Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.

RealityV15.1Online Documentation (MoTW) Revision 7

CONTINUE Statement (SQL) (m691509+continue.htm)

To	Reality
Version
Topic
Submitted by
Company
Location
Email address
Comment

CONTINUE Statement

Causes an immediate jump back to the start of a WHILE loop.

Syntax

CONTINUE

Comments

Any statements between the CONTINUE statement and the end of the loop are skipped.

Example

SET @I = 0

SET @V1 = SECOND(CURTIME())+1

WHILE @I<10

BEGIN

    SET @I = @I+1

    SET @V2 = @V1*@I + @V1/@I

    IF @V2>500 CONTINUE

    INSERT INTO TESTDATA VALUES(@I,@V2)

END

If @V2 is greater than 500, starts the next loop iteration, without executing the INSERT statement.

CONTINUE Statement

Syntax

Comments

Example

See Also