Hi Lucas,

Tuesday, July 09, 2002, you wrote:

LF> If you have a SP that's returning "rows" the correct syntax is:

LF> FOR SELECT
LF> <FIELDLIST>
LF> FROM TABLE
LF> INTO <FIELD_RETURNING_LIST>
LF> DO BEGIN
LF> SUSPEND;
LF> EXIT; /* If you want to select just the first row */
LF> END

I always thought that FOR SELECT...DO statement should be used only if
I have to return more than one result...
Well, okay, I'll do in that way.

Thank you! ^_^

Kind regards,
--
Matteo

mailto:matteo.giacomazzi@...
ICQ# 24075529