Contents tagged with Alter Table
today I want to leave another post about internals of Acumatica, about which you may heard something like "Never try it at home". In another words, sometime you may need to do the following in Acumaitca:
Insert directly into database ( for this purpose I'd recommend you to use PXDatabase.Insert )
Alter Schema of Table
.... this list is not exhaustive
and any other system level activities. By default and for SOLId SOLID SOLID reasons you can't achieve it. But sometime you may need it.
Below goes sample of code, which you can use for setting identity insert to on, and then execute some update onf the table, and … more