>>Here you change the SQL for each iteration, hence I cannot see how it would >>be possible to prepare only once. What you could try, is to use a temporary >>table, change your statement to: Simple if after "iteration" query look like SELECT * FROM TABLE WHERE ID=? SELECT * FROM TABLE WHERE ID=? OR ID=? SELECT * FROM TABLE WHERE ID=? OR ID=? OR ID=? then i got limited number of possible queries e.g 3 or 5 ... >>SELECT SUM(Y.AAA) FROM TABLEY Y >>JOIN TMP_TABLE T ON Y.ID = T.ID >>and in your loop do >>INSERT INTO TMP_TABLE(ID) VALUES(:VAR_NR) >>HTH, >>Set Temp table is good hint but in my reall case it is difficult because of changing number of columns and its types I suppose that specify dynamic list of parameter values in current FB implementation is not supported or may be it is? regards, Karol Bieniaszewski
Re: RE: [firebird-support] Parametrized queries and execute statement - dynamic parameter list
liviuslivius [email protected] [firebird-support] Tue, 26 May 2015 01:18:08 -0700
