Archives

Archive for March, 2012

First, determine the current site, after which you must name a configuration, by convention: DECLARE @Site SiteType SELECT @Site = site FROM parms Then determine the current SessionId:   DECLARE @SessionId RowPointerType SET @SessionId = dbo.SessionIdSp() Finally, add the procedure code:   BEGIN TRANSACTION UPDATE coitem SET due_date = dbo.CalcDueDate(@Parm1, @Parm2) WHERE coitem.co_num = @CoNum […]

Mar 20th, 2012 | Filed under Development, SQL

Infor is really terrible sometime when it comes to documentation.  For example, for the application event system to work, you have to make your site name exactly match with your configuration name, and this basic and critical information is not listed in installation guide and event system guide. You can only discover this when running […]

Mar 10th, 2012 | Filed under Application, Implementation