Re: ESQL/C question

EXEC SQL get descriptor 'demo4desc_in' :desc_coutn_in = COUNT ; -----------------------------------------------------------------------------^^^ desc_coutn_in should be: desc_count_in Transcription error or coding error? Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Apr 16, 2010 at 12:34 PM, Link, David A <DALink@west.com> wrote: > We are trying to write some dynamic processes and they seem to work for > SELECT, INSERT but for UPDATE and DELETE we are not getting the descriptors. > > > > We are compiling with IBM Informix CSDK Version 2.81 on AIX 4.3.3 and > hitting a database on AIX 5.3 and IDS 11.50.FC6. > > > > Query is > > update dkc_flags set phone_number = ?, etor_status = ?, bcast_mesg_status => ?, bcast_mesg_expire = ? where location_code = ? > > > > We issue the following statements: > > > > EXEC SQL prepare demo4id from :demoquery; > > > > printf("step 1\\n"); > > EXEC SQL allocate descriptor 'demo4desc_in' with max 50; > > > > printf("step 2\\n"); > > EXEC SQL describe demo4id using sql descriptor 'demo4desc_in'; > > > > printf("step 3 get COUNT value\\n"); > > EXEC SQL get descriptor 'demo4desc_in' :desc_coutn_in = COUNT ; > > > > For the update statement above we get a count of 0 instead of what we would > expect of 5, one for each “?”. > > > > Am I missing something here? > > > > Thanks for any help… > > > > David Link > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >