Pro *C question with prepare statement

From: Sivakumar Ramamoorthy <rama_at_ms.uky.edu>
Date: Fri, 7 May 1993 00:02:05 GMT
Message-ID: <C6MqrI.C0q_at_ms.uky.edu>


I have a bug with pro *c
When I say

strcpy(sql_statement,"SELECT * FROM ");
printf("table name:");
fflush(stdout);

gets(tn);

strcat(sql_statement,tn);

it works fine.

However if I say
gets(temp)
and I type in the statement
like SELECT * FROM X (Without a semicolon)

the prepare fails.

Any suggestions how it can happen.

Siva
rama_at_s.ms.uky.edu Received on Fri May 07 1993 - 02:02:05 CEST

Original text of this message