About SQL/PL

From: Terrence Mak <stmak_at_cuhk.edu.hk>
Date: Mon, 1 Oct 2001 19:41:32 +0800
Message-ID: <9p9kjq$mph2_at_imsp212.netvigator.com>

Hi, I got a question on write the embedded SQL

I have wrote a C program with embedded SQL, and have a few strings

char Currency[]="Hong Kong Dollars";

char Bit[]="7.799";
char Ask[]="7.800";
char Time[]="1500";

char Date[]="15092000";
 *All save as char string

In the SQL I have a table which name is mycurrency( Currency char[20],
Bid number[8],
Ask number[8],
Time number[4],
Date date[8]
)

How can I write the C program to insert the data into the table mycurrency in SQL?
Should I change the 'string' into 'int' before insert??

Thanks
Terrence Mak Received on Mon Oct 01 2001 - 13:41:32 CEST