https://community.sap.com/t5/application-development-and-automation-discussions/run-external-program/m-p/12447234#M1999171 <P>I'm using SAP B1, v10.00.120 PL2, with Coresuite customizations.</P> <P>I'd like to run an MS Access procedure, passing an UDF value as parameter. The help file suggests to use an Easy Function (like SQLQuery) with EXEC xp_cmdshell. Once enabled the above, by default it's OFF, I configured this command:</P> <P>SQLQuery("QCT|EXEC xp_cmdshell 'MSACCESS.EXE c:\Sviluppo\QCT\QCT1000.mdb ;$[$COR_G_903.QCT.0]';")</P> <P>msaccess.exe is the runtime, QCT1000.mdb is my procedure, $[$COR_G_903.QCT.0] is the UDF placeholder</P> <P>It does NOT work and I can't sort it out. The command is OK, I can run it directly from Windows, once I replaced the parameter with a proper value.</P> <P> I can't find any alternative, due to my limited knowledge. </P> Fri, 30 Jul 2021 07:02:57 GMT former_member651578 2021-07-30T07:02:57Z https://community.sap.com/t5/application-development-and-automation-discussions/run-external-program/m-p/12447234#M1999171 <P>I'm using SAP B1, v10.00.120 PL2, with Coresuite customizations.</P> <P>I'd like to run an MS Access procedure, passing an UDF value as parameter. The help file suggests to use an Easy Function (like SQLQuery) with EXEC xp_cmdshell. Once enabled the above, by default it's OFF, I configured this command:</P> <P>SQLQuery("QCT|EXEC xp_cmdshell 'MSACCESS.EXE c:\Sviluppo\QCT\QCT1000.mdb ;$[$COR_G_903.QCT.0]';")</P> <P>msaccess.exe is the runtime, QCT1000.mdb is my procedure, $[$COR_G_903.QCT.0] is the UDF placeholder</P> <P>It does NOT work and I can't sort it out. The command is OK, I can run it directly from Windows, once I replaced the parameter with a proper value.</P> <P> I can't find any alternative, due to my limited knowledge. </P> Fri, 30 Jul 2021 07:02:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/run-external-program/m-p/12447234#M1999171 former_member651578 2021-07-30T07:02:57Z