When installing patches to SyteLine, one of the key tasks you should complete is determining if any of the affected objects you are applying interfere with customizations… Read more “Finding Customizations”
Automatically Creating Error Messages for Primary Keys
Have you ever been working with a custom form in SyteLine, on top of your own custom table, and gotten this error message? Helpful, right? This error… Read more “Automatically Creating Error Messages for Primary Keys”
Printing an Entire “Load IDO Collection” Resultset in an Inbox Notification
Have you ever wanted to fire an Inbox notification, with all the pertinent data related to the notification right in the message text? Is the “Show Context”… Read more “Printing an Entire “Load IDO Collection” Resultset in an Inbox Notification”
Create your IDO before you set up primary/foreign keys on your new table.
This was a strange one that I had to go to Infor Support to resolve. I used the SQL Tables Form to set up a brand new… Read more “Create your IDO before you set up primary/foreign keys on your new table.”
Cleaning up non-Vendor objects that are identical to Vendor objects
In my Vendorization talk at the SyteLine User Network conference, I mentioned how simply poking around in SyteLine can sometimes cause unintended changes to Vendor objects. We… Read more “Cleaning up non-Vendor objects that are identical to Vendor objects”
Restoring Explorer folders after an APAR blows them away
December 2015’s recommended patch list included two APARs, SL201638 and SL201781. Both APARs affected “xModules.sql,” which essentially means that the Master Explorer folders get reset. This removes… Read more “Restoring Explorer folders after an APAR blows them away”
Script out hundreds of SQL objects from a list, all at once (DANGER, WILL ROBINSON!)
DISCLAIMER: I am about to describe a way to batch generate discrete CREATE <object> .sql files, based on a list of objects. Please be aware of licensing… Read more “Script out hundreds of SQL objects from a list, all at once (DANGER, WILL ROBINSON!)”
Unload Doc-Trak Code prior to using FormSync to bring over APAR changes
This is one of those things that should be obvious, but the thought only occurred to me today. When you are using FormSync to bring over APAR… Read more “Unload Doc-Trak Code prior to using FormSync to bring over APAR changes”
Setting Form Component Flags in SQL
DISCLAIMER: I am about to talk about editing form components directly in the forms database. Under almost every circumstance, this is a terrible idea. Please do not… Read more “Setting Form Component Flags in SQL”
Deadlock Hunting!
We found recently that we were dealing with an insane number of deadlocks in our system. This was causing issues during our receiving process, and we believe… Read more “Deadlock Hunting!”
SyteLinePSA 