Apostrophes

[Deane Venske]

Hi Ruslan,
What is escapeString()? Is that a REALBasic function or something within 
Valentina, and is it available in the current version of Valentina 
Client/Server.

Deane
On Thu, 04 Dec 2003 09:30:32 +0200, Ruslan Zasukhin 
<sunshine at public.kherson.ua> wrote:

> on 12/4/03 7:21 AM, Deane Venske at deane.venske at eduss.com wrote:
>
>>> 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.
>
> And you need use EscapeString() function to make life easier.
>



-- 
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!**
-------------