SQL function reports error(cvi 7.0)

[DavidLee]

Hello,

I use the SQL toolkit 2.05 programming database which is MS Access 2000. My code is as follows:
...
hstmt = DBActivateSQL (connectHandle, "SELECT ReaderID, TagID, ReadTime FROM tblTagReads");
DBBindColInt (hstmt, 2, &tRecord.readerID, &colStatus[0]);
DBFetchNext (hstmt);
...

When execuating the application , it always reports such an error :"Function DBBindColInt: The specified column is already bound to a varibale"
Please give an advise ,what is wrong ? Thanks.

David

[zhenve]

Hi!
I think the code you posted here has no problem. Did you use "DBActivateSQL" executing another query before this code? If you did, may be you forgetted to call "DBDeactivateSQL" to terminate the statement.If you did not, please post the whole function including this code.