Re: Pro*C:How to do "where column =:char_host_var" ?
From: Jodi Showers <jshowers_at_cmi.on.ca>
Date: Wed, 5 Oct 1994 13:48:44 GMT
Message-ID: <jshowers-0510940946410001_at_mac25.cmi.on.ca>
Date: Wed, 5 Oct 1994 13:48:44 GMT
Message-ID: <jshowers-0510940946410001_at_mac25.cmi.on.ca>
In article <36ni60$824_at_raffles.technet.sg>, scornd11_at_solomon.technet.sg (Nicholas Wee) wrote:
> ProC examples in the book only show selection criteria using
> integer host variables but NO examples I know show char variables.
> When I managed to code it, it works sometimes and not other
> times eg. "where column like :char_host_var" which works on
> some machines and not on others... really weird !!!???
>
> Anyone with some code out there that really works all the
> time on all machines...?
>
> Thanks.
Always declare :char_host_var as VARCHAR(!char) - you'll get unpredictable results otherwise. Received on Wed Oct 05 1994 - 14:48:44 CET