Re: PREPAREd statement

Ramiro Rela (rrela@dc.uba.ar) wrote: > I need to EXECUTE a PREPAREd statement from a string like > "UPDATE mytable > SET (first, second, third, fourth) = (myrec.first, myrec.second, > myrec.third, myrec.fourth) > Beeing 'myrec' a program record holding data to update into 'mytable' Try: UPDATE mytable SET (first, second, third, forth) = myrec.* or UPDATE mytable SET first=?, second=?, third=?, forth=?EXECUTE ... USING myrec.first, myrec.second, myrec.third, myrec.fourth -- Frode Tvedten Systems dept Tollpost-Globe AS N-6301 'ndalsnes/Norway E-mail: ftv@it.tollpost.no Phone: (+47) 7122 6678 Fax: (+47) 7122 6694