Re: [sqlite] How to Use an Apostrophe in a Text Field?

>True. I will get rid of the habit of using double quotes for string >literals. >Thanks for information. But most of the databases support this non >standard >behavior. Yeah ... until things break under your feet due to a new version not sticking to the "non-standard" behavior anymore or

Re: [sqlite] How to Use an Apostrophe in a Text Field?

Hi, True. I will get rid of the habit of using double quotes for string literals. Thanks for information. But most of the databases support this non standard behavior. Thanks Venkat VENKAT From: Jean-Christophe Deschamps To: General

Re: [sqlite] How to Use an Apostrophe in a Text Field?

> The apostrophes are escaped by apostrophes. Correct. http://www.sqlite.org/faq.html#q14 > One more way you can do. > >insert into () values ("*Goin' Down > >> the Road Feelin' Bad*"); > >It is double quotes before and after *. Similarly double quotes will >be escaped by one more double

Re: [sqlite] How to Use an Apostrophe in a Text Field?

Sorry if my reply didn't make it through the first time, but doubling up on the apostrophes worked just fine. My thanks to those of you who suggested it. On Thu, Apr 21, 2011 at 4:27 AM, venkat easwar wrote: > > > The apostrophes are escaped by apostrophes. One more way

Re: [sqlite] How to Use an Apostrophe in a Text Field?

The apostrophes are escaped by apostrophes. One more way you can do. insert into () values ("*Goin' Down >> the Road Feelin' Bad*"); It is double quotes before and after *. Similarly double quotes will be escaped by one more double quote VENKAT From: Jim

Re: [sqlite] How to Use an Apostrophe in a Text Field?

Thanks to all for all the suggestions. Doubling up the apostrophe worked. On Mon, Apr 18, 2011 at 10:55 AM, Jim Morris wrote: > Did you try doubling the apostrophes? > > *Goin'' Down the Road Feelin'' Bad* > > > On 4/17/2011 6:16 PM, Simon Slavin wrote: > > On 17 Apr

Re: [sqlite] How to Use an Apostrophe in a Text Field?

Did you try doubling the apostrophes? *Goin'' Down the Road Feelin'' Bad* On 4/17/2011 6:16 PM, Simon Slavin wrote: > On 17 Apr 2011, at 11:54pm, Alan Holbrook wrote: > >> I'm using SQLite with VBE2008. I've defined a table with a number of text >> fields in it. If the information I want to

Re: [sqlite] How to Use an Apostrophe in a Text Field?

On 17 Apr 2011, at 11:54pm, Alan Holbrook wrote: > I'm using SQLite with VBE2008. I've defined a table with a number of text > fields in it. If the information I want to write to the database contains > an embedded apostrophe, the program throws an error. That is, if I set > textfield1 to

Re: [sqlite] How to Use an Apostrophe in a Text Field?

On Sun, Apr 17, 2011 at 3:54 PM, Alan Holbrook wrote: > I'm using SQLite with VBE2008.  I've defined a table with a number of text > fields in it.  If the information I want to write to the database contains > an embedded apostrophe, the program throws an error.  That is,

Re: [sqlite] How to Use an Apostrophe in a Text Field?

On Apr 17, 2011, at 5:54 PM, Alan Holbrook wrote: > I'm using SQLite with VBE2008. I've defined a table with a number of text > fields in it. If the information I want to write to the database contains > an embedded apostrophe, the program throws an error. That

[sqlite] How to Use an Apostrophe in a Text Field?

I'm using SQLite with VBE2008. I've defined a table with a number of text fields in it. If the information I want to write to the database contains an embedded apostrophe, the program throws an error. That is, if I set textfield1 to *Going Down the Road Feeling Bad*, the data gets written