Hi everyone, I am trying to write a code snippet library with sqlite. My main problem is when I put an sql statement together with code sample containing quotes and apostrophes from a multiline textbox it does not treat it as text but as code. I have done this in vb6 but cant seem to get it right in b4ppc.
This is the sql statement the problem is txtAddCode.text is the code I want to store.
Addtext = "INSERT into snippet(snip,code,att) values('"
Addtext = Addtext & txtAddSnip.text
Addtext = Addtext & "','" & txtAddCode.text
Addtext = Addtext & "','" & txtAddAtt.text & "')"
If there is a solution it is probably simple.....
thanks tremara1
Australia
This is the sql statement the problem is txtAddCode.text is the code I want to store.
Addtext = "INSERT into snippet(snip,code,att) values('"
Addtext = Addtext & txtAddSnip.text
Addtext = Addtext & "','" & txtAddCode.text
Addtext = Addtext & "','" & txtAddAtt.text & "')"
If there is a solution it is probably simple.....
thanks tremara1
Australia