Re: esql 5.0 to 7.12

Posted in 1997

Bill Ennis — 7 Apr 1997 15:03:57 -0400 — source: Informix-list mailing list archive (1991-1998)

Hi, 1) What is cnt declared as? 2) What platform are you working on? 3) How are you determining that cnt is 0? -Bill > > we just ported our application from online 5.0 to 7.12,but it does not > really work properly. the surprising thing is that the most simpe sql > statements fail. > for example: > "EXEC SQL select count(*) into :cnt from any_table where id < 123" > returns cnt 0 and sqlcode 0. > dbaccess returns the proper value 2. > > anything known about the problem? > -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net