SQLTeam.com | Weblogs | Forums

Soap.Execute Concatonate

Hi, The below works when they are all strings. However, I cannot get it to work when I try to concatenate a Variable + Value1 + in the second line. Is it to do with the use of ". Do I need to add a char of a certain value to replace the "?

retobj = MySoap.ExecuteQuery("INSERT INTO Data (Value1, Value2, Value3, Value4, Value5) VALUES ( 'Value1', 'Value2', 'Value3', 'Value4', 'Value5')", obj, out limit);
(It works with just strings).

I have tried a number of ways, hope it can be done.

this is a SQL forum, not SOAP. But what happened when you tried this?