Archives
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 […]
When populating an empty or initialized database, it is recommended that you enter the following information on the following forms in the following order: Step 1: Users Use this form to register users to the application. A user ID is required for each user who logs on to the application. Step 2: Object Authorizations for […]
1) To move around the db extent to differ location Bring down the DB and make a backup of the DB. Copy the db extent file, such as .b1, .b2 or .d1, .d2, to a new location Edit the .st file to point to the new location prostrct repair db-name [.st description file], This will […]
1) For the original DB, dump the .df file. Can be done by go to Progress -> Data Administration -> Admin -> Dump Data and Definitions -> Data Definitions; or Syteline admin -> Admin -> Database maintenance -> Dump Data Definitions. 2) Create a new DB from Progress empty DB: Progress -> Data Administration -> […]
Copy DB in Windows1) Command prompt, CD to DB directory.2) %DLC%\bin\procopy oldname newname. newname can be full path like F:\db\shimadzu\shimadzu3) This will copy over the .db, .b1, .d1, .st and .lg. Then manually copy over any .pf and update .pf accordingly.