I have spent a few days trying to find a solution using Google. Has anyone had luck with this problem? Simply put we are trying to send data from our web service to our I-Series. We need to do this via a SQL stored procedure. When we do the insert dynamically it works as long as there are no single quotes in the data. If someone has a name like Dave's Plumbing it blows up. We can do a replace of the char like this.
dr("SoldToCompany") = dr("SoldToCompany").replace(Chr(39), " ")
But the data is not "really" correct. The name is now Dave s Plumbing.
Is there a way to keep the single quote doing it dynamically?
Or has anyone found a better method?
Any suggestions would be great.