Devart Forums

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??

Set UseUnicode option of TOraSession to True. Then you can assign to TOraQuery.SQL property value: Set DataType for USR parameter to ftWideString and assign value to this parameter using AsWideString property.