Scripting

Short of getting a developer license, does anyone know how one could get a copy of the File Layouts into a data table from which I could convert to a database? I know I can print it to PDF and use Monarch to convert it, but that's so 90's. TIA

Use a Premium database and sysobjects table? not sure exactly what you are trying to put in the table. If you need to include non-framework modules, you can use the cnnMAS.GetSchema(""Tables"") from .net over an odbc connection to get all the tables, then for each table use cnnMAS.GetSchema(""Columns"", tablename) to get the columns. There is a bit more to it - email me if that's the route you want to take.

Are you trying to recreate the table structures in another database like SQL Server or Access, or are you trying to have somewhere to store the reference information from the layouts in something more convenient than the present form?

@ChrisStAmand No to your 1st part, yes to the second: I want to copy the table's KPRIMARY key information, field names, field types (S|N), size and the class field (to classify dates) to an Access table.

.GetSchema(""Indexes"") can be done per table as well. Be aware that some indexes in Sage 100 contain fields which can be null, and most other databases will tell you where to go when you try to apply them. Hopefully none of those are primary keys....

@PhilMcIntosh that is for Premium only though correct? That would be great if the SOTAMAS90 emulated that, but I am skeptical.

You can run that against the ODBC connection to Providex

VBscript should be able to use ADO. See this article: https://support.microsoft.com/en-us/help/186246/how-to-use-the-ado-openschema-method-in-visual-basic

Thanks @PhilMcIntosh - that's what I'm working...