SQL structure Help

[Wonder Fef]

> 1) escape it
>           INSERT INTO T (f1) VALUES ('Brian\'s book')
> 
> 
> 2) use double quotes, yes they work in INSERT
>           INSERT INTO T (f1) VALUES ("Brian's book")
> 
> Second way probably more effective.


The \ trick worked just fine.
I did not use the " trick because some of my fields use this character.
Binds must be the solution to get rid of these workarounds.

> What means refuse with \  ?
> It remove this character ?
> Or totally refuse ?
The SQLExecute returns 0 and the record is not inserted in the database.

Note that I use Valentine in RealBasic.

Thanks all for your help