Re: Re: RE: Re: [freetds] SQLPutData error

brazilchina at mail.goo.ne.jp brazilchina at mail.goo.ne.jp
Tue Mar 16 01:08:01 EST 2004


I'm sorry.
Sample code is wrong.

> if( rc == SQL_SUCCESS || rc == SQL_SUCCESS_WITH_INFO ){
is
if( !(rc == SQL_SUCCESS || rc == SQL_SUCCESS_WITH_INFO) ){

> ---------------------------------------------------------------------
> int testPutData( SQLHSTMT hstmt ){
> 	int rc;
> 	int i;
> 	
> 	SQLINTEGER ind;
> 	SQLPOINTER ptr;
> 	char test_text[] = "abcdefg";
> 	int len = strlen( test_text );
> 	
> 	//SQLBindParameter
> 	rc = SQLBindParameter( hstmt,
> 						1,
> 						SQL_PARAM_INPUT,
> 						SQL_C_CHAR,
> 						SQL_VARCHAR,
> 						0,
> 						0,
> 						(SQLPOINTER)123,
> 						0,
> 						&ind);
> 	if( rc == SQL_SUCCESS || rc == SQL_SUCCESS_WITH_INFO ){
> 		exit(1);
> 	}
> 	ind = SQL_LEN_DATA_AT_EXEC(len);
> 	
> 	//SQLPrepare
> 	//CREATE TABLE TEST_TABLE (c VARCHAR(255) NULL, b VARBINARY(255) NULL)
> 	rc = SQLPrepare( hstmt, (SQLCHAR *) "INSERT INTO TEST_TABLE(c) VALUES(?)", SQL_NTS);
> 	if( rc == SQL_SUCCESS || rc == SQL_SUCCESS_WITH_INFO ){
> 		exit(1);
> 	}
> 
> 	//SQLExecute
> 	rc = SQLExecute( hstmt );
> 	while( rc == SQL_NEED_DATA ){
> 		rc = SQLParamData( hstmt, &ptr );
> 		if( rc == SQL_NEED_DATA ){
> 			if( ptr == (SQLPOINTER)123 ){
> 				SQLPutData( hstmt, test_text, len);
> 			}
> 		}
> 	}
> 	return 0;
> }
> ---------------------------------------------------------------------
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 


More information about the FreeTDS mailing list