Hello,
I am trying to execute a command, but unfortunately I keep getting the message ‘An exception has been thrown on the server: Only one result is allowed when WrapResult is false’. The SQL command executes without any problems… Do you have any tips on what else I can try?
Client Request:
begin
cmd := TDARemoteCommand.Create(nil);
try
cmd.RemoteService := dataClient.RemoteDataAdapter.RemoteService;
with modDataProspects do
begin
cmd.Execute('prospects_UPDATE', ['ncp_id', 'ncp_modified', 'activ', 'group_id', 'status_id', 'language_id',
'web'], [tbProspectsList.FieldByName('ncp_id').AsString, tbProspectsList.FieldByName('ncp_modified').AsDateTime,
tbProspectsList.FieldByName('active').AsBoolean, tbProspectsList.FieldByName('group_id').AsString,
tbProspectsList.FieldByName('status_id').AsString, tbProspectsList.FieldByName('language_id').AsString,
tbProspectsList.FieldByName('web').AsString]);
end;
finally
FreeAndNil(cmd);
end;
end;
SQL:
UPDATE dbo.nbs_crm_prospects
SET
modified = :ncp_modified
,active = :activ
,group_id = :group_id
,status_id = :status_id
,language_id = :language_id
,web = :web
WHERE
id = :ncp_id