I am developing an AIR app which has a lot of text-entry fields. I have not managed to figure out how to escape apostrophes that users may enter so that the text can be saved properly to the Sqlite database. As a workaround, we can insert '' where we mean ', and the dB swallows it. This is not a satisfactory long-term solution. I have tried using a regexp forced-replace of ' with '', or with ', and neither is working.
Does anyone have some advice, or a pointer to where I can go to understand more? Thanks in advance. a
