Re: PROC: Dynamic SQL

> Hi All,
> I have a Probelm with dynamic sql in PRO*C.
> the sql statement is like " select * from mytable where name = :f1".
> it works fine if the bind variable has all the N chars , where N
> is the length of the coulmn name. but it returns nothing if the bind
> variable has a value whose length is less than the column
> length. Any ideas?
>
> thanks a lot, ash.
>

Is your bind variable char or varchar. I recommend to use varchar and to set varchar.len accordingly.

Reinhard Schmidt Reinhard_at_schmidt.do.eunet.de Received on Mon Jul 22 1996 - 00:00:00 CEST