Re: [sqlite] SQL Quick Review/Reference

2008-04-15 Thread metro
is this what everybody is looking for?? http://booksforpeople.blogspot.com/2008/03/definitive-guide-to-sqlite-free-book.html there are other sources for free ebooks Laurie Mike Owens wrote: > On Mon, Apr 14, 2008 at 8:45 AM, Martin Jenkins <[EMAIL PROTECTED]> wrote: > >> Mike Owens wrote:

Re: [sqlite] Inserting data containing apostrope

2008-04-10 Thread metro
Tom your a Legend so simple slight code mod to insert extra ' and it works thanks very much Laurie BareFeet wrote: > Hi Laurie, > > >> how do I insert the following >> >> INSERT into phone (INITIALS,NAME,PHONE_NO,SUBURB) Values >> ('AC','O'Hara','0413000153','Seafort ') >> > > You can

Re: [sqlite] Inserting data containing apostrope

2008-04-10 Thread metro
uldn't > recommend doing it. > > Mike > > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von metro > Gesendet: Freitag, 11. April 2008 03:16 > An: sqlite-users@sqlite.org > Betreff: [sqlite] Inserting data containing ap

[sqlite] Inserting data containing apostrope

2008-04-10 Thread metro
Hi all very new to this game, I am creating a reverse search phone book for my POS program I think the problem has something to do with using an ESCAPE clause but at this stage it's beyond my comprehension I am using Liberty Basic (new to that too) + dll how do I insert the following INSERT into