Re: Preparing UPDATE statement in ESQL/C

Posted in 1995

Ian Goddard — Sun, 29 Oct 1995 21:18:21 — source: Informix-list mailing list archive (1991-1998)

In article <9510250922.AA16837@dpx.dpx.courier.kiev.ua> bal@dpx.dpx.courier.kiev.ua (Bespaly Alex) writes: >From: bal@dpx.dpx.courier.kiev.ua (Bespaly Alex) >Subject: Preparing UPDATE statement in ESQL/C >Date: 25 Oct 1995 12:46:55 +0200 > Hi, all! > Is there any way in ESQL/C after $PREPAREing an >UPDATE statement like: >"update table1 set (field1,...) = (?,...,?) where <condition>" > to find out the next info: > - how many columns are being updated; > - sqlvar entries for each of them; >that is fully determined sqlda structure? > When preparing INSERT/SELECT statements, sure, I have it, but >what can I do with UPDATE? > Thanks in advance. > Bespaly Alex Nothing. At this point you haven't looked at your data. All you have done is let the engine parse and optimise your statement. Ian