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 'FFFormNumber', 'id' EXECUTE spCreateColumn 'FFFormNumber', 'NextNumber', 'bigint', '13', '2', 1, 0, 0, 1, '0', 'None' INSERT INTO FFFormNumber('id', 'NextNumber') VALUES (1,1)
UnprintedInvoice is added way back in 2020. now I want to add new column.
FFFormNumber is new table that I want to add. But I have encounter an error below. I try to execute the 4 lines above on MSSQL Management Studio and it works ok.