From: N Prabhakar <prabhs@po.pacific.net.sg>
Subject: Re: Embedded sql
Date: 1997/02/02
Message-ID: <5d0ms9$7r1$5@newton.pacific.net.sg>#1/1
references: <32F24A12.27B@shore.net>
to: bliu@shore.net
content-type: text/plain; charset=us-ascii
organization: Socgen Crosby Securities
mime-version: 1.0
newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc
x-mailer: Mozilla 1.22KIT (Windows; I; 16bit)



Bing Liu <bliu@shore.net> 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
>?

Hi there,

This should definitely work. May be after setting the .len of key, can you 
print the value of key and check??

After executing the sql statement, check for SQL_ERROR.

Null terminate ITEMNAME variable and print it.

Hope the above info helps you

Regards

N.Prabhakar