donoghue_brendan wrote:

>Thanks Martijn
>
>I made the changes you sugested but now get a 'Unexpected end of
>command' error.
>
>Do I need to add in multiple suspends at the end of the command to
>trminate all of the loops that I have started? If so what is the
>syntax for that?
>
>Thanks
>
>Brendan Donoghue
>
>

Brendan,

To terminate a loop started with a "begin" you use an "end"

The "Suspend" is used to return a row to the client.

So I think that in your case, you just need a suspend on the inner loop.

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.6.1 - Release Date: 04/03/2005