VB6 and SQL

March 16, 2009 at 03:47:41
Specs: Windows XP SP3

I have a problem, I am using VB6 to get around 30 fields and there values in a loop and then copying them. Everything works fine and it copies 20 out of the 50 lines that i want it to, after doing an investigation i have spotted that i am getting an error because one of the name fields has an apostrophe in it such as:


This is causing SQL a problem cos it is recognising the apostrophe and throwing an error as not it thinks there is an extra apostrophe, can anyone help. Thanks

See More: VB6 and SQL

Report •

March 16, 2009 at 04:59:58
I have figured it out, sorry,

Report •
Related Solutions

Ask Question