Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Carlos Benjamin — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.