高分求助！proc查询的一个问题

[einest]

#define LENGTH 40

VARCHAR my_id[LENGTH];
char temp_char[100];
printf("\nPlease Enter id (default: EI): ");
gets(temp_char);
strncpy((char *) my_id.arr, temp_char, LENGTH);
if (strlen(temp_char)<1)
strncpy((char *) my_id.arr, "EI",LENGTH);
my_id.len=strlen((char *) my_id.arr);

EXEC SQL DECLARE bucket_cursor CURSOR FOR SELECT × FROM mytable WHERE ID=:my_id;

然而一条记录也查不到。如果改成WHERE ID='EI'就可以查到了

[onejune4450]

试试！
strncpy((char *) my_id.arr, temp_char, strlen(temp_char));
if (strlen(temp_char)<1)
strncpy((char *) my_id.arr, "EI",2);

[incats]

不改程序的测试:
输入40个字符后, 再敲回车.

[einest]

问题是ID的长度是不确定的啊

[onejune4450]

#define LENGTH 40

VARCHAR my_id[LENGTH];
char temp_char[100];
printf("\nPlease Enter id (default: EI): ");
gets(temp_char);
if (strlen(temp_char)<1)
strcpy(temp_char,"EI");

strncpy((char *) my_id.arr, temp_char, strlen(temp_char));
my_id.len=strlen((char *) my_id.arr);

如果ID 的类型是varchar2,
EXEC SQL DECLARE bucket_cursor CURSOR FOR SELECT * FROM mytable WHERE ID=:my_id;
如果id 的类型是CHAR 用 WHERE rtrim(ID) = :my_id;

[bihu]

RTRIM(LTRIM(ID))= :my_id;

[bihu]

RTRIM(LTRIM(ID))= :my_id;