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 indicate a quote within quotes, by using two quotes.
>
> Do it like this:
> INSERT into phone (INITIALS,NAME,PHONE_NO,SUBURB) Values
> ('AC','O''Hara','0413000153','Seafort ')
>
> Tom
> BareFeet
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
