Re: Pro*C query problem
From: Ganesh Puranik <surya_at_usa.net>
Date: 1995/05/27
Message-ID: <3q8d3e$6ts_at_earth.usa.net>#1/1
Date: 1995/05/27
Message-ID: <3q8d3e$6ts_at_earth.usa.net>#1/1
> ee_d304_at_dcs.king.ac.uk (Nick Bailey) writes:
> I am having problems trying to get a query in my Pro*C program to acheive what I want it to. The query is as follows -
>
> EXEC SQL SELECT CNAME, CCLENGTH
> INTO cname, clength
> FROM COURSES WHERE CNAME=:name;
> Nick.
>>>>
The can think of the following common mistakes:
- cname is char (blank padded) but :name is not blank padded.
- :name is defined as varchar in Pro*C but name.len is not set properly.
Ganesh Puranik
Consultant, Surya Systems, Inc.
Received on Sat May 27 1995 - 00:00:00 CEST