-
Products and Technology
By Category
-
Groups
Activity Groups
Industry Groups
Influence and Feedback Groups
Interest Groups
Location Groups
Customer Only Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
Products
Learning and Support
-
- Products and Technology
- Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
- Explore SAP
-
Products
- Products
- SAP Business Suite
- Artificial Intelligence
- Business applications
- Data and analytics
- Technology Platform
- Financial Management
- Spend Management
- Supply Chain Management
- Human Capital Management
- Customer Experience
- SAP Business Network
- View products A-Z
- View industries
- Try SAP
- Partners
- Services
- Learning and Support
- About
- SAP Community
- Groups
- Interest Groups
- Application Development and Automation
- Discussions
- Run external program
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Run external program
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2021 Jul 30 8:02 AM
- SAP Managed Tags
- SQL
I'm using SAP B1, v10.00.120 PL2, with Coresuite customizations.
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:
SQLQuery("QCT|EXEC xp_cmdshell 'MSACCESS.EXE c:\Sviluppo\QCT\QCT1000.mdb ;$[$COR_G_903.QCT.0]';")
msaccess.exe is the runtime, QCT1000.mdb is my procedure, $[$COR_G_903.QCT.0] is the UDF placeholder
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.
I can't find any alternative, due to my limited knowledge.
Bluesky