*********** Pro*C Question *********

Dear Friends:

        I am facing a baffling Pro*C behavior. I do the following in Pro*C.

	Program 1:
		char my_string[16];
		VARCHAR sqlcmd[256];

		sprintf (sqlcmd.arr, "insert into my_table values 
				     ('%s')", my_string);
		sqlcmd.len=strlen(sqlcmd.arr);

	Program 2:
		char my_string[16];

		EXEC SQL DECLARE C1 CURSOR FOR
		SELECT * FROM my_table
		WHERE only_attribute = my_string;


	Sure enough the query in program 2 returns nothing! When

        Where is the problem?

Thanks in advance,

-Badri Received on Sun Jun 19 1994 - 05:53:05 CEST