ESQL/C and dynamic UPDATE...
Posted in 1995
Hi! Is there any way in ESQL/C after $PREPAREing SQL 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? If I write a straight code for ESQL by myself, of course, I do know which fields I'm going to update and thus I can make the required sqlda... But I want my programmers to bypass ESQL and work on C using some library, which have been compiled with ESQL earlier. And when that programmer wants to work with dynamic UPDATE constructions, what should I do in my library? Thanks in advance. Bespaly Alex