Thanks a lot

Andre

Martijn Tonies wrote:

> Hello Andre,
>
>
>>I've made my first steps with stored procedures. The documentation
>>provides some simple examples like:
>>
>>ALTER PROCEDURE "F_GET_ID"
>>RETURNS
>>(
>
>
> Even easier:
> ID INTEGER
>
>> "id" INTEGER
>>)
>>AS
>>BEGIN
>> "id" = 1234567890;
>
>
> id = 12931231;
>
> (without quotes)
>
>
>> END
>>
>>There is no syntax error, but I get no result set. So I read a little
>>bit more the manual and find "suspend", and now:
>>
>>ALTER PROCEDURE "F_GET_ID"
>>RETURNS
>>(
>> "id" INTEGER
>>)
>>AS
>>BEGIN
>> "id" = 1234567890;
>> suspend; <<--------
>> END
>>
>>it works.
>>
>>My Question: are all examples that I found wrong, or did I some mistakes?
>
>
> No. A "suspend" make a stored procedure select-able. The engine will
> suspend further procedure execution and will continue if the client or
> process fetching results from the procedue will ask for a new row. If
> it doesn't do that, the procedure will not finish (when in a loop).
>
> For procedures that don't have "suspend" in them, you can call them via
> EXECUTE PROCEDURE <procedure> ( in parameters ) returning_values
> :out1, :out2 etc...
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>