Re: ESQL/C: select works but shouldn't?

In article <3k72bm$ams@ns.oar.net>, william@carsinfo.com (William Harris) writes: |> In the following ESQL/C statement, I'm not getting an error. |> |> $long vendor; |> |> $select id, prsp_no into $vendor from id_rec |> where id = 20240; |> |> (This is the distilled essence of a more complicated select statement |> that was mysteriously giving me an error.) When I originally isolated |> the problem, I was surprised that I wasn't getting error -254, |> "The number of host variables named in the INTO clause of this |> statement does not match the number of "?" place holders written |> into the statement." <snip> |> |> The same lack of error happens if the number of columns I select |> are fewer than the number of host variables I'm selecting them into. |> <snip> This is well documented behaviour. esql/c _or_ for that matter 4gl also will not return any error in this case. However it will notify the user by setting some warning field in the sqlca record. Don't remember which field is it. Most probably it is sqlwarn3. Hope this helps. -- ajay chitale +email: achit@puma.miel.mot.com +voice: 91-80-2278545