Apostrophes

[Deane Venske]

>
>
>
> My trick in Access  for storing text fields that contain apostrophes was 
> to
> construct SQL variables that enclose text variables in CHR(34), i.e.
> quotation marks. However, since that doesn't appear to work with 
> Valentina,
> what trick do you recommend? I'm about to change all of my SQL statements
> and Getstrings to substitute apostrophes for exclamation marks and back
> again on the fly --- the items I'm storing can never contain exclamation
> marks naturally.
>
> But there's probably a better way that you all will recommend to me.
> chuck
The best way I know of is to escape apostrophes, I've used the backslash : 
INSERT INTO table1 VALUE('O\'Neil') BUT this doesn't always work (I think 
it's selects that don't like it. So you need to use : SELECT FROM table1 
WHERE username = 'O''Neil'.

But give both methods a try, they can be bothersome.


-- 
Deane Venske
Senior Programmer
Eduss Ltd.
+61 7 5597 4600

-------------
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
**If you don't have it you're missing out!**
-------------