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 D.O.T kherson.ua> wrote:
> on 12/4/03 7:21 AM, Deane Venske at deane.venske@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!**
-------------
_______________________________________________
Valentina mailing list
Valentina AT lists D.O.T macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2003 Deane Venske |
