Query with unicode data

[Adil]

Hello.

How I can send query with unicode parameters. For example:

OraQuery1.SQL.Text='
SELECT * FROM "ADIL"."USERS" WHERE "username"='+usr;

Where usr is widestring.

If it`s not possible, what tricks I can use??

[Plash]

Set UseUnicode option of TOraSession to True. Then you can assign to TOraQuery.SQL property value:

Code: Select all

SELECT * FROM "ADIL"."USERS" WHERE "username"=:usr

Set DataType for USR parameter to ftWideString and assign value to this parameter using AsWideString property.