Params for Oracle XE

[cahaya]

Hi Zeos Team,

I try zeos 7.1.4 stable version, database Oracle XE 11g, Delphi 7.
I set TZconnection protocol to oracle.

Code: Select all

With QuPassword Do
Begin
       Close;
       Parambyname('USERNAME').value:=edUsername.text;
       Parambyname('PASSWORD').value:=edPassword.text;
       Open;
       Result:=Not IsEmpty;
End;

QuPassword is TZReadOnlyQuery. The result is always empty but the fact there is a record.
When I change where condition in Sql statement like "where username='scott' and password='tiger', it gives a result.

Thank you for help.