Re: Embedded sql

From: Lindsberger Franz <franz.lindsberger_at_siemens.at>
Date: 1997/02/03
Message-ID: <32F5A587.1E5B@siemens.at>#1/1

Bing Liu wrote:
>
> Is that possible to put VARCHAR variable in condition WHERE ?
>
> I declared host variables as:
>
> VARCHAR key[20];
> VARCHAR ItemName[20];
>
> and:
>
> strcpy(key.arr,"xyz");
> key.len=strlen(key.arr);
>
> Then I want select columns from a table:
>
> EXEC SQL SELECT name INTO :ItemName
> FROM CABLEBOX
> WHERE KEY = :key;
>
> When I run the program, I couldn't get the item name I want.But if I put
> the string 'xyz' behend = , it works. I wonder if I could put variable
> in WHERE clause. What to do if I really want to fetch somthing like this
> ?

mention the differences between several oracle-precompiler-modes - maybe this helps Received on Mon Feb 03 1997 - 00:00:00 CST