Here is the function
CString CRDoc::GetChairNo(CString strAcctNum, CString strDepNum, CString strSequence)
// [login to view URL]
memset(temp, 0, sizeof(temp));
val = temp;
size = sizeof(temp);
type = SQL_C_CHAR;
// [login to view URL] the patient email from resp table.
// 2.1 Create the sql.
memset(sql, 0, sizeof(sql));
sprintf_s(sql, sizeof(sql), "select first chair from [login to view URL] where acctnum='%s' and depnum='%s' and sequence in (%s) ",
strAcctNum, strDepNum, strSequence);
// 2.2 Execute the sql.
CSCISet::GetSQLValues(sql, &val, &size, &type, 1);
strChairNo = temp;
Most times it return the correctly but sometimes it returns zero (which is incorrect)
Need knowledge of VS2008 c++ and sql
8 freelancers are bidding on average $41 for this job
I think - Your issue is in select first chair from [login to view URL] where acctnum='%s' and depnum='%s' and sequence in (%s) are You getting the result from it?