I hope someone out there can help me in this matter
I developed an application using VB 6 and SQL 7.0
The problem i am facing is that in the application whenever a user keys in a data in particular field the the symbol ( ' )
I get a run time error prompt from SQL which is
Run time error '-2147217900(80040214)
[Microsoft][ODBC SQL SERVER DRIVER][SQL DRIVER]Line 1: incorrect syntax near 's'
Is there a way that i can force or even convert this (') in VB to be acccepted by SQL server? I hope someone out there can really help with a solution.....thanx guys & girl
I really would appricate the help.