Devart Forums

I was using prNativeClient and all was working.

I switch to pdDirect and i see all update returns 0 row affected

My connection has this settings:

Options.KeepDesignConnected:=True;
ProviderName:='SQL Server';
SpecificOptions.Values['Provider'] := 'prDirect';
SpecificOptions.Values['Authentication'] := 'auServer';
SpecificOptions.Values['ConnectionTimeout'] := '90';
SpecificOptions.Values['LockTimeout'] := '10000';

Example code:
q2.SQL.text:='update cliente set nome=:nome where id=:id';
q2.ParamByName('nome').AsString:=ragsoc;
q2.ParamByName('id').AsInteger:=idclifor;
q2.ExecSQL;

The update is succesfull but q2.RowsAffected is always 0

I'm using Delphi Tokyo Update 1

We tested the work of the RowsAffected property on the latest UniDAC version, but found no problems. In order for us to analyze the issue, please provide the script to create the table, as well as a simple sample demonstrating the issue.