Archives
In Syteline, there are many ways to default field value. The most simple way is to use the default value property of the field component. But if you need to set the default value based on some other field value, that simple property value would not cut it. Syteline Application Case We want to default […]
We will use a sample to run through the process of adding a CLM into IDO. Part of making the Customer Document Profile function available to RMA verification report, we need to create a new CLM to IDO SLRmas. The CLM is based on SP navProfileRMAVerificationSp. create PROCEDURE [dbo].[navProfileRMAVerificationSp] ( @RMAStatusOpen ListYesNoType = NULL, […]
Even thought the UET(User Extended Table) is a more prefer way to add fields into Syteline Form. But sometime, user feel that the UDF(User Defined Field) is more straight forward for adding field to Form, but then later, when they like to show those UDFs into report, it becomes no that straight forward anymore. Adding […]
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 […]
SQL server provides way to connect to remote database (SQL, Oracle and many others). Within your store procedure, you can dynamically connect to the remote DB, fetch data, process them into Syteline DB. Business Case: Let’s say you have a web store database, in a remote database server. You want to replicate the orders into […]
Sometime, while you are making modification on a Syteline form in design mode, system would crush on you. Even after you log out and log back in, and try get into the design mode again, the error message would keep coming up, preventing you using any function in design mode. This usually only happen to […]
In Syteline 8, some time in some forms, the horizontal scrollbar in Grid mod would some how missing. User can not see all records in the data set. This often due to that when developer making modification to the form, some how make the height of Grid mod screen disagree with the height of the […]
Here is a basic way to call a SQL Store Procedure (SP) within a script, either Form Script or Inline Script. The sample we use below is calling a SP: GetCustType and return the CustType value to a form variable. Dim nRetVal As InvokeResponseData Dim nRequest As New InvokeRequestData() nRequest.IDOName = “SP!” nRequest.MethodName = “GetCustType” […]
Google Insights for Search – Web Search Interest: syteline – Worldwide, 2004 – present Looks like Syteline is fading slowly in the past 5 years. The pick up in early this year may be related to the ad campaign Infor recently run. Hope they really do something, no just sit there simply claim themselves […]