Re: PROBLEMS WITH PREPARE/DESCRIBE in ESQLC

Posted in 1998

Art S. Kagel — Mon, 06 Jul 1998 14:16:27 -0400 — source: Informix-list mailing list archive (1991-1998)

Nick Page wrote: > > PROBLEMS WITH PREPARE/DESCRIBE in ESQLC [SNIP] > EXEC SQL connect to 'sa_phones'; > sprintf(demoquery, "%s ", "select * from overall;"); > EXEC SQL prepare demo3id from :demoquery; > EXEC SQL declare demo3cursor cursor for demo3id; > EXEC SQL describe demo3id into demo3_ptr; > desc_count = demo3_ptr->sqld; [SNIP] Add error checking after each EXEC SQL to verify that you are indeed connected to the server with an open database and that the statement prepared correctly. Art S. Kagel