Re: SQL returns diff results in ESQL and Power Builder

Vinod Bhansali <iiug@hotmail.com> wrote: >Hi guys, > >We have a SQL like below in an ESQL/C program >select count(*) in :var >from ...... where .... Well, sure. You have an uneven number of dots in your from and where clauses.... Actually, are you initializing var to zero? >When we execute it from ESQL/C it returns 1 in var >When we execute it from Power Builder or Dbaccess it returns 0 in var > >We are sure that the result from Power Builder and Dbaccess is right. > >Does any body know why sql from ESQL/C gives wrong results > >Thanks in advance >Vinod Bhansali >Informix DBA >DSL Transportation >________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > carlos Currently on hiatus from unemployment. ---------------------- Do you do Linux? :) Get your FREE @linuxstart.com email address at: http://www.linuxstart.com