[V4MD] Escape Chars

[Martin Kloss]

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' ")

That's where I get 0 records back, although a

SqlExecute("SELECT * FROM foo")

returns the correct values.

Martin.