Subject Re: [firebird-support] Fill Fields
Author Helen Borrie
At 06:27 AM 11/04/2007, you wrote:
>Hi all
>I have a table with a lot of fields.
>They are namend from I1 ro I144
>I must fill them with various data, here is the snippet code I use.
>while( cont < 145 ) do begin
>'I' || :cont = :n_starting;
>n_starting = :n_starting + :inc_n;
>cont = cont + 1;
> end
>Don't work.
>The problem is that I use 'I' || cont ..........

The problem is that you can't use metadata object names as variables
in PSQL. The reason, of course, is that PSQL modules are pre-compiled.

If you are using Firebird 1.5 or higher, you *can* build up a DSQL
string and use EXECUTE STATEMENT finally to execute it. In this way
you will be able to loop through your set of input data and construct
an INSERT statement for execution at each turn of the loop. For
syntax, refer to the v.1.5.4 release notes.