Published by K3 SYSPRO LIMITED
Other products by K3 SYSPRO LIMITED
As with much of coding there are always a myriad of ways to achieve an end result, some good, some not so good. We have found these samples useful over the years. We hope that you can use them "as is" or use them to short circuit development. Either way they should provide some interesting reading and hopefully provoke some thought.
The K3 Syspro VBScripting Samples Library consists of a series of scripting samples, code snippets, VBScript classes and functions, and documentation.
Originally developed to help K3 Syspro consultants maximise the VBScripting in SYSPRO (and to assist in writing scripts outside SYSPRO) they have now been made generally available to the SYSPRO community via the SYSPRO App Store.
Changes for Version 2
Classes and Functions
Removed method InsertDSWTransactionSQL. You should now use InsertDSWTransactionSP. This passes insert control to the server rather than execute from the client.
fn_BuildXMLFromListView.vbs – new function
Designed to be used with Syspro Custom Pane list views that have an editable column.
The function will create an XML string for all rows that have data in the editable column
There is a single argument ColumnToCheck. This is the column number (starting at 0 for the first column) to check to see if there is data in it. If there is then all the data for that row is included in the XML
fn_format.vbs – replaced with a new version
The old version used MSSTDFMT.dll that is no longer shipped with Windows 7 and later.
The new version uses the .Net Framework
How to get a record set back from a SQL stored procedure – sample SQL stored procedure in comments at the beginning of the code
How to get a return value from a SQL stored procedure – sample SQL stored procedure in comments at the beginning of the code
How to call Syspro WCF service
Create a zip file and copy files to it.
Lists all SQL triggers in a database
Script to help test the “LoadModule” modules.
SYSPRO Performance V1.02.docx
Notes on our experiences when diagnosing slow performance of Syspro or SRS
Some notes on changing column types after creating views
VBScript Event Detection
Some notes on how to work out when Syspro fires its events
VBScript examples of how to handle command line arguments.docx
Examples of handling arguments in scripts running outside Syspro
An attempt to document the Syspro customisation directories.
Removed testdatabaseclass.vbs and TestDataswitchInsert.vbs
You can test these modules by using the new ModuleTestHarness.vbs in the Examples directory.
|License type: Free|