Archives
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 […]
Each component in Syteline form can have its own right click menu, and this right click menu is customizable. See the sample, the “Ship To” field has a standard right click menu, with “Add”, “Detail”, “Find” and “Help” menu items. If you look into the component property of “Ship To” field, you can see the […]
One of the trickier aspects of application development is dealing with null or nonexistent data. It gets complicated when the application expects a data value and gets nothing or unexpected values; that’s when you must perform coding that properly handles these situations to avoid application failure. This requires a close examination of the data wherever […]
Use CDate to convert a string to a date/time. Dim d1 As Date Dim d2 As Date Dim d3 As Date d1 = CDate(“August 12, 2004”) d2 = CDate(“2:07:30 PM”) d3 = CDate(“August 12, 2004 2:07:30 PM”) Print d1 ‘ prints 8/12/2004 Print d2 ‘ prints 2:07:30 PM Print d3 ‘ prints 8/12/2004 2:07:30 PM
It is very often that you need to get current date/time in your development. T-SQL To get today date without time as string variable use following script: Select CONVERT( CHAR(8), GetDate(), 112) To get datetime variable of today date without time use following script: Select CAST( CONVERT( CHAR(8), GetDate(), 112) AS DATETIME) VB System.DateTime.Now.ToString(“yyyyMMddhhmmss”) Now() […]
Problem:
Many business would not allow product shipped to a “PO Box” address. So would like to block any “PO Box” address being entered into any ship to address.
Solution:
1) Enter design mode of “Customer Ship Tos” Form.
2) We are going to first create a script. Go to “Menu -> Edit -> Script”, a Script window should open. Click “New”, enter Script Name called “NoPOBox”, then click OK.
Payroll Generation: pr/pr-trxg.p, main logic in pr/pr-trxg1.p Payroll record prlog can be generated from 4 differ sources: Manufacturing transaction jobtran. The Generate Payroll From field on the Employee Master must also be set to M. The summarized transactions include: WC Labor, WC Machine Time and Job Labor. prlog.posted-from = “M”. Manufacturing Project transaction projtran. The […]
The table contains MPS is rcpts with the ref-type = “M”. rcpts also contain other records that generated by MRP. To remove any MPS demand, remove rcpts records with ref-type = “M”.