Re: Dynamic SQL - proC - Method 4

Sylvain Benoist wrote:
> When we want to get some data from the database by using this application,
> everything works fine except with the "string" fields. Indeed, if the type
> of one field is varchar(10) and this field contains 4 characters, the
> Dynamic SQL method 4 will return a string containing 10 characters with the
> 4 corresponding characters + 6 spaces.

You need to set s->T[i] to 5 ("C"-string) of the varchar2 columns. You probably used 1 ("char") or 9 ("varchar").

        Erwin Received on Tue Jul 24 2001 - 09:52:18 CEST