Hvor er forskellen?
Kan nogen sige mig hvor forskellen ligger imellem disse eksempler er? Eksempel 2 virker ikke, men eksempel 1 gør.Eksempel 1:
Query.Close;
Query.SQL.Clear;
Query.SQL.Text := 'SELECT whenChanged, logonCount, samAccountName, distinguishedname, ADsPath, CN FROM '+ Quotedstr('LDAP://ou=users,ou=so,ou=dk,ou=company,dc=ad,dc=company,dc=org') + ' WHERE objectClass='+ Quotedstr('user') + ' ORDER by CN';
Query.Open;
-----------------------------------
Eksempel 2.
with Query do
begin
Close;
SQL.Clear;
SQL.Add('Select whenChanged, logonCount, samAccountName, distinguishedname, ADsPath, CN');
SQL.Add('FROM LDAP = :LDAP');
SQL.Add('WHERE objectClass = :ObjectClass');
SQL.Add('ORDER by CN');
Parameters.ParamByName('LDAP').Value := 'LDAP://ou=users,ou=so,ou=dk,ou=company,dc=ad,dc=company,dc=org';
Parameters.ParamByName('ObjectClass').Value := 'user';
Open;
end;
