Re: Two SQLITE RevBD questions

2015-12-26 Thread jameshale
Thanks Peter, I was hoping that was the case. James -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Two-SQLITE-RevBD-questions-tp4699831p4699834.html Sent from the Revolution - User mailing list archive at Nabble.com. ___

Re: Two SQLITE RevBD questions

2015-12-26 Thread Peter Haworth
Hi James, No need to escape quotes when using bound variables. You'll still need to encode your date before inserting it and decode it when selecting it or you'll lose its utf8-ness. On Sat, Dec 26, 2015, 6:44 AM James Hale wrote: > I am moving my app from LC6 to LC7 (in prep for LC8) and have

Re: Displaying mixed text and images in iOS app

2015-12-26 Thread Todd Fabacher
Hi Richard, We had the same issue, but we needed to actually edit the documents. If you just need to display, HTML is the way to go. I suggest you use Base64 to put the image in the HTML so there are no possible broken links. It is easy to do. Plus, the HTML proved to be more flexible for mobile d

Two SQLITE RevBD questions

2015-12-26 Thread James Hale
I am moving my app from LC6 to LC7 (in prep for LC8) and have a couple of questions regarding some changes I have made in the way I use SQLITE. 1. Escaping quotes when using binding variables Originally I was doing the standard INSERT into the DB where I constructed my SQL and then used "revExe