Archives
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” […]
Every combobox in Syteline form has a pull-down list. For example the item pull-down list may show item# and description. You may want to add more fields to this pull-down list to show more information for your user. Business Case: The current Syteline customer ship-to pull-down list only show the ship-to seq and the customer […]
In Syteline form, quite often, you would need to assign some field value, base on another field value entered. Business case: Let say in Customer Order, for certain payment terms, you would not allow partial shipment. So in the CO header form, when user select certain payment term, you want the system automatically uncheck the […]
This is considered by some people as Holy Grail of Syteline Form Personalization. Here is what we want to do. In “Time Phased Inventory” form, we want to change the color to yellow for those rows that is PO. First, we need to create a new form script method, called SetPOColor() Sub SetPOColor() Dim i […]
When deploying an UET customization in Syteline 7 & 8, there is SP can be used to script out the UET. Just do exec ExportUETClassSP ‘classname’ Some server don’t this SP installed. I just keep a copy here for in case set ANSI_NULLS ON set QUOTED_IDENTIFIER OFF GO ALTER PROCEDURE [dbo].[ExportUETClassSP] ( @PClassName Infobar ) […]