Why is that?

[Tomasz Dubiel]

Hello.

SET TERM ^ ;
create or alter procedure TESTTD
returns (
    ZMIENNA integer)
as
begin
  zmienna=1;
  if (zmienna<>1) then
    suspend;
end^
SET TERM ; ^

If I run select * from testtd, I don't get results (expected, condition not met).

However, execute procedure testtd produces unexpected:
ZMIENNA =1

Why is it happening?

Best regards,

Tomek.

[Martijn Tonies (Upscene Productions)]

Hi,

 

When using SELECT, results are only returned on SUSPEND. No SUSPEND reached, no result.

 

With EXECUTE, results are always returned at the end of the procedure.

 

With regards,

Martijn Tonies
Upscene Productions
https://www.upscene.com

Database Workbench - developer tool for Oracle, SQL Server, PostgreSQL, MySQL, MariaDB, InterBase, SQLite, NexusDB and Firebird.

--
Support the ongoing development of Firebird! Consider donating to the Firebird Foundation and help ensure its future. Every contribution makes a difference. Learn more and donate here:
https://www.firebirdsql.org/donate
---
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion, visit https://groups.google.com/d/msgid/firebird-support/3d2cea38-5b25-4ef7-9e27-a261280b33acn%40googlegroups.com.

[Mário Reis]

Use Create Function 

Com os meus melhores cumprimentos
Mário Agostinho Reis

919262146

Esta mensagem contém informação de natureza confidencial e é
exclusivamente dirigida ao(s) destinatário(s) indicado(s). Se, por engano,
receber este email agradecemos que não o copie nem o reenvie e que nos
notifique do ocorrido através do email de resposta.

To view this discussion, visit https://groups.google.com/d/msgid/firebird-support/D90D41842AD34580A14781F239250A5B%40MARTIJNWS.

[Tomasz Dubiel]

Thanks.