TDARemoteCommand & AnyDac 5.0.5

Data Abstract
1

Hello,

I used to execute certain commands TDARemoteCommand on the server.

After I updated to version 5.0.5 AnyDac receive “An exception was raised on the server:. [AnyDAC] [Phys] [ib] -318 take all registrations may be made ​​one-way”, 0, 0, 0 false" exception.

How can I fix this?

I use the last DataAbstract gamma version.

Thanks,
Tiberiu Stoicescu

2

Sorry if my answer does not match the case exactly but maybe it helps to use this thread to find a fixed version of the the uAnyDACDriver.pas. If you do not use this file already … search on both sides please. I think the fix refers to the problem posted in AnyDAC forum but maybe it helps to move one step further.

http://www.da-soft.com/forums/anydac-general-english/error-fetching-all-records-cannot-be-performed-unidirectionally.html#19886

3

Thanks for the reply.
I can not access the proposed link. (404)
Unable to find a fixed version of the uAnyDACDriver.pas.

4

Hello,

I couldn’t get the same exception, it depends on the type of executed command probably. Please specify what commands cause such error.

What about '[AnyDAC] [Phys] [ib] -318 Fetching all records cannot be performed unidirectionally ’ exception - it is already fixed in the latest gamma 6.0.56.975

Best regards

5

Command is an stored procedure
database is firebird
Code is like this:

vRemoteCommand := TDARemoteCommand.Create(nil);
try
vRemoteCommand.RemoteService := fIBaseMdiMainForm.GetRemoteDataAdapter.RemoteService;
with vRemoteCommand.ExecuteCall do
begin

    MethodName := 'ExecuteCommandEx';
    Params.Clear();
    OutgoingCommandNameParameter := Params.Add('aCommandName', rtString, fIn).Name;
    OutgoingParametersParameter := Params.Add('aOutgoingParameterArray', rtUserDefined, fIn, 'DataParameterArray').Name;
    IncomingParametersParameter := Params.Add('aIncomingParameterArray', rtUserDefined, fOut, 'DataParameterArray').Name;
    IncomingAffectedRowsParameter := Params.Add('Result', rtInteger, fResult).Name;
    ParamByName(OutgoingCommandNameParameter).Value := spGET_LICENTE_CLIENTI_NEXT_ID; // sp name
    Execute(); //<--exceptin here
    lParam := Params.FindParam(IncomingParametersParameter);
    lArray := DataParameterArray(lParam.AsComplexType);
    vID := lArray[0].Value;
    lArray.Free;
  end;

finally
  vRemoteCommand.Free;
end;
6

Hello

You can contact also support@da-soft.com and we will provide you updated AnyDAC DAD.