pav
July 1st, 1999, 03:24 AM
Hi!
This don't work! Why?
Examples:
~~~~~~~~~
CDatabase dbase;
dbase.Open("ibase");
dbase.ExecuteSQL("{CALL p_refer (?,?,?)}");
dbase.Close();
...
CDatabase::BindParameters()
{
// Here binding a three parameters: 1 - VARCHAR(10), 2 - DATE, 3 - BLOB(22)
char m_PhoneA[10];
char m_Src[22];
TIMESTAMP_STRUCT m_DateCall;
SQLTemp = SQL_NTS;
rc = SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_CHAR,
SQL_VARCHAR, (UDWORD)10, 0, (PTR)m_PhoneA, 0, &SQLTemp);
VERIFY(rc == SQL_SUCCESS);
SQLTemp = sizeof(TIMESTAMP_STRUCT);
rc = SQLBindParameter(hstmt, 2, SQL_PARAM_INPUT, SQL_C_TIMESTAMP,
SQL_TIMESTAMP, (UDWORD)19, 0, (PTR)&m_DateCall, 0, &SQLTemp);
VERIFY(rc == SQL_SUCCESS);
SQLTemp = 22;
rc = SQLBindParameter(hstmt, 3, SQL_PARAM_INPUT, SQL_C_BINARY,
SQL_LONGVARBINARY, (UDWORD)22, 0, (PTR)m_Src, 0, &SQLTemp);
VERIFY(rc == SQL_SUCCESS);
}
Thanks!
This don't work! Why?
Examples:
~~~~~~~~~
CDatabase dbase;
dbase.Open("ibase");
dbase.ExecuteSQL("{CALL p_refer (?,?,?)}");
dbase.Close();
...
CDatabase::BindParameters()
{
// Here binding a three parameters: 1 - VARCHAR(10), 2 - DATE, 3 - BLOB(22)
char m_PhoneA[10];
char m_Src[22];
TIMESTAMP_STRUCT m_DateCall;
SQLTemp = SQL_NTS;
rc = SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_CHAR,
SQL_VARCHAR, (UDWORD)10, 0, (PTR)m_PhoneA, 0, &SQLTemp);
VERIFY(rc == SQL_SUCCESS);
SQLTemp = sizeof(TIMESTAMP_STRUCT);
rc = SQLBindParameter(hstmt, 2, SQL_PARAM_INPUT, SQL_C_TIMESTAMP,
SQL_TIMESTAMP, (UDWORD)19, 0, (PTR)&m_DateCall, 0, &SQLTemp);
VERIFY(rc == SQL_SUCCESS);
SQLTemp = 22;
rc = SQLBindParameter(hstmt, 3, SQL_PARAM_INPUT, SQL_C_BINARY,
SQL_LONGVARBINARY, (UDWORD)22, 0, (PTR)m_Src, 0, &SQLTemp);
VERIFY(rc == SQL_SUCCESS);
}
Thanks!