Re: ESQL/C vs. SQLDA
Posted in 1998
David Kosenko wrote: > In fact, before the current release, there was no way to describe an update > statement. To get an sqlda to use with an update, you'd prepare a select * for the > table to be updated, and then do a describe on that statement. That would give you > an sqlda struct with all the columns from the table. You could then do the update, > essentially updating all the columns (but only providing "new" data for the ones you > really wanted to update). So the same "described" sqlda was used for the select and > the update. > Uhm, I just built an sqlda struct based on the info stored in the sys tables. That way you can build dynamic query structures on the fly. Its pretty fast too. -Mikey -- #include <std_disclaimer.h> /* Mike Segel (MS385) */ #include <No_Spam.h> #ifdef OFFENDED_BY_CONTENT The author takes no responsibility for this post. Any resembalence to a coherent rational thought is purely coincidence. -The Management. #endif ***************************** * Attention * -*- Due to AGIS's Refusal to Act Responsibly -*- Due to ACSI's Refusal to Act Responsibly We are blocking all of their domains at the packet level. This block will exist until they modify their policies to conform to existing RFCs and net community standards. We encourage all ISPs and domain holders to do the same. *****************************