BlackBook Changelog
Socrates Gekas
· SQL Server Windows Authentication (XCO)
· Azure Installations
o Auto Login
o Schedule Jobs using Windows Scheduler
· Params.cfg parameters
· Menu Commands
o AUTOLOCATE = HeaderID
o EXTRALOCATE = LineID
o EDITOPTIONS = NOPRINTFORM, NOPRINTBROWSER, NOPRINTLABEL, NOINSERT, NODELETE, READONLY, NOBROWSER, ONEROW
o STYLE = MODAL / MODELESS
o STYLE = NEW
o SELECTION = Name
· Object Parameters
o CUSTOMBUFEXCLUDE = TableName (Excludes all fields of table)
o RELJOBS = StringList
o EDITOPTIONS = NOPRINTFORM, NOPRINTBROWSER, NOPRINTLABEL
· Form Script Functions
o X.FORMATFLOAT
o X.FILTERSUM Example: Check for duplicate items in Sales Document rows
· Form Scripts Examples
o Add Relative Jobs in SoftOne Objects (Case Study 8)
o Run External Application (Case Study 9)
o
Run function
from script saved inside SoftOne Designer
X.EXEC('CODE:SysRequest.ExecuteXScript',
X.Module, 1, myDesignerScript, 'myFunction');
o X.EVAL example with IncMonth and FormatDateTime
o Added Examples in Events (Fields, Datagrids, Objects, Sub Forms):
§ Change Right Click Menu of Browsers (using custom jobs)
§ Use Selected records of Browser (using SELRECS)
§ Quick Sum of Lines without iteration (using X.FILTERSUM)
§ Hide Form Panels base on specific conditions
§ Disable record editing (Lock / Unlock all form fields)
§ Change Field Editors according to other field data
§ Preserve data on conversion (Get data from initial document)
§ Populate custom virtual table on sub form show
§ Populate sales document lines from virtual table on sub form accept
· Editor Attributes
o W – Example of use in Memory Tables
o L – LocalEditor: LookUp from row data inside an object
o A – Excludes ISACTIVE column
o Z – Displays both Key and Value of a string list