Re: Pro*C Help Needed

Ed Tolsch wrote:
>
> I'm trying to use a host variable within a select clause as follows:
>
> EXEC SQL BEGIN DECLARE SECTION
> char HostVar[10][15];
> EXEC SQL END DECLARE SECTION
>
> strcpy(HostVar[0], 'string1');

 HostVar[0].len=strlen(HostVar[0].arr);
> strcpy(HostVar[1], 'string2');

 HostVar[1].len=strlen(HostVar[1].arr);
>
> select somefield
> from table
> where value in (:Hostvar);
>
> This does not return any values unless I fill up the entire array. Any
> help would be appreciated! Thanks.
 

Hugo, Toulouse, France Received on Thu Aug 14 1997 - 00:00:00 CDT