Hello,
is it possible to load some script from DB (with lda global object) inside beforeProcessDeltaChange event and then execute that script inside that event?
Hi,
in general, it is possible.
You can try to play with external method where you can pass your statement & parameters.
in this method you can run code via EcmaScriptComponent.
You can get access to it via EcmaScriptProvider.ContextChanged event.
example:
method (dataAdapter: LinqLocalDataAdapter; serviceInstance: DAScriptingTestService)
begin
self.SetScript(serviceInstance, 'Customers',
"function onNewRow(row) {
log(userDefinedNumber);
if (userDefinedNumber !== 123)
fail('UserDefined variable has incorrect value');
}");
EcmaScriptProvider(dataAdapter.ScriptProvider).ContextChanged += (sender, e) -> begin e.Engine.Globals.SetVariable('userDefinedNumber', 123); end;
try
dataAdapter.InsertRow(new Customers());
finally
dataAdapter.CancelChanges();
end;
end;