Topic: Sql Update
Hi All
Quick question, the line below works fine
SQLExecute ('update tools set machine = '+mach_tool.edit2.text+' where id_jobs = '+mach_tool.edit11.text+' ');
Except when the text string (mach_tool.edit2.text) contains an ("), then the sql command reads this as the end of the string.
I know i'm using the wrong syntax here, but don't know the correct one.
Any help would be great.
John