problem with DynamicUpdateCommand when insert values that contain COMMA and semicolon

wizardo — Fri, 05 Feb 2010 19:43:26 GMT

hi all.

i am using DynamicUpdateCommand to insert values into a table: MyTable

the table has 2 fields:

Name

Description

this is the code


myStr= "INSERT INTO MyTable (varname1,varcontent1) VALUES (" & vName & "," & vDescription & ")"
objQVMain.DynamicUpdateCommand (myStr)

this works great in most cases.

but if one of the values to insert contains a comma or a semikolon then strange things happens

i was able to make it work when there is a coma in the value by adding dblquots around it

but this doesnt work for if the value contains semikolon and then the app just hangs.

here is my last try


myStr= "INSERT INTO MyTable (Name,Description ) VALUES (" & """" & vName& """" & "," & """" & vDescription & """" & ")"
objQVMain.DynamicUpdateCommand (myStr)

anyone ever had similiar problem?

topic problem with DynamicUpdateCommand when insert values that contain COMMA and semicolon in QlikView

problem with DynamicUpdateCommand when insert values that contain COMMA and semicolon