I tried but no success
SCM-120008 Unable to find key values for element 'TestKey' (document with schema 'TestKey') XSV-350023 Unable to save document of type 'ef:TestKey'. SOP-330011 Error while executing the method 'Write' of service 'xtk:persist|xtk:session'.
@David__Garcia, Thinking more I see that sqlExec is better than xtk.session.Write approach.
However, Is there a way to parametrize the DELETE query?
If I try to delete like this:
var sql = "DELETE FROM Marketing.dbo.TestKey WHERE col2 = $(l);"
I get this exception:
@David__Garcia, Thank you for the response.
Yeah, I know this approach. But it looks like a workaround and it does not use TestKey data schema.
Actually, my TestKey data schema is created using External Account, so, table TestKey is not in Neolane database. Having this, and assuming that the ext...
ACC 7.2.2 build 9349@e319b6d of 02/28/2022MSSQL is an external database<srcSchema> is (some values are masked/dotted):
<srcSchema ... entitySchema="xtk:srcSchema" img="xtk:schema.png" label="TestKey" ... name="TestKey" ... view="true" xtkschema="xtk:srcSchema">
Dear Community, I am trying to use DBEngine query() command to select data from MSSQL database and I need to pass parameter/s to my query. I am following this tech spec - DBEngine.query() documentation.There is an example showing how to pass a param - to do this use $(l), $(sz) as a param-holder/s (...