Hi all,
I have a sql script and previously successfully updated to Sage 200 company database. Now I add the following line
EXECUTE spCreateColumn 'UnprintedInvoice', 'FormNumber', 'bigint', '13', '2', 1, 0, 0, 1, '0', 'None'
EXECUTE spCreateTable…
Hi all,
I see there is tblParameter in configuration table, I would like to store my key value such as custom database name, servername, username, and password in tblParameter to be used in my custom form.
In Sage.MMSAdmin.DBSchema.Others, I see there…
Hi all,
I want to create a custom database using addIn.sql file from an Add on, so user do not have to go to MSSQL to create himself. But I have problem installing the add on because of this error:
"CREATE DATABASE statement not allowed within multi…
Hi all,
I want to create a program where all companies in Sage 200 should be able to access and the data provided in this program should be stored in a custom database, not individual company database. I assume for the create database query, I can add…
Hi All,
I need to do the following:
Update multiple company from one company.
Lets say I have company A, B, C, D, E.
Login in Company A, I add new customer and company B,C,D,E must add the same new customer, and vice versa.
Is it possible to…
