Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
f90SQL
- Thread starter sagn
- Start date
- Thread starter
- #2
The answer is yes. I was failing at previous attempts
because I was not including the
SQLSetStmtAttr(hstmt, SQL_ATTR_PARAM_BIND_TYPE,
sizeof(Struct), 0);
,
where sizeof(Struct) is the size of the 'struct' data type,
correctly.
(the column-wise binding method uses
call f90SQLSetStmtAttr(StmtHndl,SQL_ATTR_PARAM_BIND_TYPE,
SQL_PARAM_BIND_BY_COLUMN, iRet)
the parameter SQL_PARAM_BIND_BY_COLUMN.. to use row binding
one must simply enter the size of the structure
)
Of course there are things one must do, but my problem
was due to missing the above statement.
because I was not including the
SQLSetStmtAttr(hstmt, SQL_ATTR_PARAM_BIND_TYPE,
sizeof(Struct), 0);
,
where sizeof(Struct) is the size of the 'struct' data type,
correctly.
(the column-wise binding method uses
call f90SQLSetStmtAttr(StmtHndl,SQL_ATTR_PARAM_BIND_TYPE,
SQL_PARAM_BIND_BY_COLUMN, iRet)
the parameter SQL_PARAM_BIND_BY_COLUMN.. to use row binding
one must simply enter the size of the structure
)
Of course there are things one must do, but my problem
was due to missing the above statement.
- Status