Have been receiving this message in the Application Error Log since 2/16/16. What does this meaning and how do I deal with it?
Desc.: GM version: 22.214.171.124 R Thread ID 7692:
ADO Error in AdoRecordSetBase::openTheRecordset select top 1 ONDATE, ONTIME from GOLDMINESQL.DBO.CAL where ACCOUNTNO = 'B6021659902$`H4;_'''' order by ONDATE, ONTIME
Com Error IDispatch error #3092
HRESULT : -2147217900
Description: Unclosed quotation mark after the character string 'B6021659902$`H4;_'' order by ONDATE, ONTIME'.
Time: 2016-02-17 10:25:39Z
Thanks so much for your help.
2 of 2 people found this helpful
You have 2 quotation mark in the end of the ACCOUNTNO B6021659902$`H4;_''
In the query there should be in the end of the ACCOUNTNO 5 quotation marks
Try to run the next Query
select top 1 ONDATE, ONTIME from GOLDMINESQL.DBO.CAL where ACCOUNTNO = 'B6021659902$`H4;_''''' order by ONDATE, ONTIME and it should work.
What I can suggest for solving this error problem is to create a new Contact Record and then merge the old record to the new record.
Thanks for you help Shaul. I couldn't get the query to return any records but I was able to find the record by the Account #, create a new record and merge the old record into the new one.