SQLExecDirect in C++

[12ab09]

Hi

i am using the following code for my development work
[code=c]
/* Connect to data source */

retcode = SQLConnect(hdbc, (SQLCHAR*) "mvr", SQL_NTS,
(SQLCHAR*) "venk", SQL_NTS,
(SQLCHAR*) "ram", SQL_NTS);

if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO){
/* Allocate statement handle */
retcode = SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);

if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) {
/* Process data */
unsigned char query1[256];
sprintf((char*)query1,
"SELECT [col1], [col2], FROM MY_DATA WHERE

 = \'%s\' ",
                pszCode );
 
              retcode = SQLExecDirect( hstmt, (SQLCHAR *)query1, SQL_NTS);
 
//////////////////////////////
 

But above code is unable to retrive the data from DB.

Can you please give me any suggestions.

where as same query if i run in sql analyzer the values are coming correctly.

Thanks in advance

Venkat

[sicarie]

Hi

i am using the following code for my development work
[code=c]
/* Connect to data source */

retcode = SQLConnect(hdbc, (SQLCHAR*) "mvr", SQL_NTS,
(SQLCHAR*) "venk", SQL_NTS,
(SQLCHAR*) "ram", SQL_NTS);

if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO){
/* Allocate statement handle */
retcode = SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);

if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) {
/* Process data */
unsigned char query1[256];
sprintf((char*)query1,
"SELECT [col1], [col2], FROM MY_DATA WHERE

 = \'%s\' ",
                pszCode );
 
              retcode = SQLExecDirect( hstmt, (SQLCHAR *)query1, SQL_NTS);
 
//////////////////////////////
 

But above code is unable to retrive the data from DB.

Can you please give me any suggestions.

where as same query if i run in sql analyzer the values are coming correctly.

Thanks in advance

Venkat

My guess is the SELECT query is being interpreted in the C program. Did you try storing it, and then printing it out - make sure all the proper characters are there?