[V4MD] Escape Chars

[Ruslan Zasukhin]

on 9/5/03 5:04 PM, Martin Kloss at martin.kloss at gmx.de wrote:

> At 16:51 05.09.03 +0300, you wrote:
>> I need to check this Martin.
>> Although I wonder what problems here.
>> You search on some VarChar ?
>> There is NO index by words, yes?
> 
> no, the table has only one field "name" and the field is indexed & unique.
> I can insert a string with a RETURN character, for example:
> 
> myStr = "This is a string
>               with a new line"
> 
> and then use binding function to insert it:
> 
> SqlExecute("INSERT INTO foo (name) VALUES (:1)", [myStr])
> 
> BUT, I can't select it from the db:
> 
> SqlExecute("SELECT RecID FROM foo WHERE name = 'myStr' ")
    ^^^^^^^^^ SqlSelect() probably ?
    
> That's where I get 0 records back, although a
> 
> SqlExecute("SELECT * FROM foo")
> 
> returns the correct values.

Martin, to do SELECT query, you need use

    new Xtra( Vcursor, dbRef, "SELECT .."

Above is typo ?

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------