> -----Original Message----- > From: Tim Nelson [mailto:[EMAIL PROTECTED]]
> Below gives me an error "-843 Invalid parameter name" > > EXEC SQL select count(*) into :counter > from cust_tax > where custax_areanbr = :taxnbr and > custax_period = :per_list[:cnt]->period; > > But if I hardcode an index value the precompiler is happy? > > EXEC SQL select count(*) into :counter > from cust_tax > where custax_areanbr = :taxnbr and > custax_period = :per_list[1]->period; > > If so, this doesn't seem very flexible to me ... Thanks. Hello Tim, sorry about this behavior but in this version it is impossible to use parameters within parameters. But you can assign the pointer from per_list[cnt]->period to a local variable before executing your SQL. Regards Burkhard
