Archives
They are not stated in Syteline manual, but from my experience, I would suggest the following routine after upgrade a Syteline DB. 1) Regenerate _all table, by using “Update _All Tables” form. 2) Regenerate trigger, by using “Trigger management” form. 3) Regenerate Replication Triggers, if you are using multi-site replication. 4) Drop all the _tt […]
In the SyteLine database you will find Temporary tables that start with: tt_* tmp_* tmp_snapshot_* tmp_staging_* There are others that end with: _ii _dd _all. The first six are various forms of permanent "temporary" tables, used for temporary processing of data. The *_all tables are used to remove the requirement that another site must be […]
For those who come from old school of Progress Syteline (Symix) like me, “For Each” command is so nature to us, in terms of loop through record for processing. But SQL is pretty much bulk processing language. There is simply no equivalent command as “For Each” in T-SQL. There are basically two way to loop […]