Archives
Open the component class “UserDefinedType”, go to validator, add one more parameter %2 to the UserDefinedTypeValue validator. Open the validator, make sure %2 is there. Then open the property of the validator. Open the Parameters screen Set %=Description in Set Prop/Var/Comp section. OK all the way back to save the change in Component Class. Now […]
Here is the way to check a form’s mode in script. If Instr(1, ucase(ThisForm.Caption), “(FILTER IN PLACE)”) > 0 Then ReturnValue = “-1” Exit Sub End If
The out of box Syteline missed some of the detail carelessly. For example, the Grid view for RMA is sorted by RMA date ascending. So it shows the oldest RMA up front and you are seeing those years old closed RMAs. Syteline Application Case Change the sorting of Grid view in RMA form, to show […]
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 […]
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 […]
For Syteline programmer, when doing the form personalization, it is important to understand the various event sequence for Syteline Forms, so you can know where to put your customized logic in. The following list outlines the sequences of events during form execution for non-query forms. 1. Form initialization StdFormPredisplay is always the first event to […]
When doing the VBScript programming, it often need to have a VBScript constant containing a line-break character. Of course this is right out: CONST blah = "hello there" …It’s just bad syntax. The closing string quote has to be on the same line as the opening one. The normally you would try this: CONST blah […]