Params for Oracle XE
Posted: 06.11.2015, 09:35
Hi Zeos Team,
I try zeos 7.1.4 stable version, database Oracle XE 11g, Delphi 7.
I set TZconnection protocol to oracle.
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.
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;
When I change where condition in Sql statement like "where username='scott' and password='tiger', it gives a result.
Thank you for help.