Re: [firebird-support] Dynamic PSQL (Execute Statement) in Stored Procedure With "SELECT / INTO"

2018-04-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.04.2018 22:33, blackfalconsoftw...@outlook.com [firebird-support] wrote: > It seems that no matter how I try to implement the "INTO" clause against the > return > variable, when I run the procedure from my DB-Manager it yields an error... INTO belongs to EXECUTE STATEMENT clause, not to

Re: [firebird-support] Dynamic PSQL (Execute Statement) in Stored Procedure With "SELECT / INTO"

2018-04-25 Thread blackfalconsoftw...@outlook.com [firebird-support]
Thank you very much for your help, Karol... As soon as I corrected my procedure based on your information, it worked as expected. Thank you, again... Sincerely, Steve Naidamast

Re: [firebird-support] Dynamic PSQL (Execute Statement) in Stored Procedure With "SELECT / INTO"

2018-04-25 Thread 'livius' liviusliv...@poczta.onet.pl [firebird-support]
) INTO :MYPARAM look for samples in instalation directory regards, Karol Bieniaszewski From: blackfalconsoftw...@outlook.com [firebird-support] Sent: Wednesday, April 25, 2018 10:33 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] Dynamic PSQL (Execute Statement) in Stored Procedure

[firebird-support] Dynamic PSQL (Execute Statement) in Stored Procedure With "SELECT / INTO"

2018-04-25 Thread blackfalconsoftw...@outlook.com [firebird-support]
Hello... I have been doing fairly well at converting a project's database to Firebird Embedded, transposing all of the inline SQL to Firebird stored procedures. However, with the following procedure I am creating a slightly complex SELECT statement based upon two incoming parameters. It seems