Archives
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.