BlackBook new version 3.5

[Socrates Gekas]

BlackBook Download Link

SoftOne Developers Database Params

Change log

ver. 3.5

• Form Scripts 
  • Methods & Functions 
    • HTTPCALL
    • GetConvertSeries
    • COPY – PASTE
    • Added example for JS Field event "ON_xxx_VALIDATE"
  • New Case Studies
    • ABC (Activity Based Costing): Check / Add / Delete ABC lines data
• SBSL 
  • Functions 
    • ExecuteNetFunction(Dll FileName, Class (with Namespace), FunctionName, Params). Example using Javascript command.
      .NET InProcess Examples: Login / Selected Records / Object Events / Field value / Add DLL Form as new Tab in S1 Object
    • GetFieldProperty
    • SetFieldProperty
    • ExecuteReport
    • ShowWarning
    • Added Examples for functions StrToDate & GetWhere
    • Added Example for JS function FORMATDATE that returns date and time
    • CacheTable Example: Dialog Filter that uses dynamic query Editor (populated by selected browser records)
    • Use ExecuteXScript to include “Advanced JS” code
  • Connection with Oracle19
  • Section Scripts (JavaScript code)
• Appendix 
  • New Section: Internal Object Parameters 
• Object Parameters
  • NOGRIDTOOLBAR=1
• Other
  • Menu Parameter: SELECTION=Name
  • PARAMS.CFG: Parameters for on-premises installations: TCPPING, TCPNONEWS

ver. 3.4

• Form Scripts 
  • Methods & Functions 
    • X.MULTISQL – AddSQL – X.RESOLVE – Sum
      Execute multiple queries in a single transaction.
    • X.STRINGS
      Returns the value of the given StringList key. 
    • X.WSCALL
      Executes SoftOne web service requests (built-in or custom).
      Examples using Advanced JS function getItemCategories.
  • New Case Studies
    • Add / Retrieve HTML Data from Blob fields.
• SBSL 
  • CreateForm - GetFormModule
    Creates an instance of a module using specific form.
• Web Services 
  • New Case Studies
    • Add HTML Data to Blob fields.
    • Get HTML Data from Blob fields.
    • Add Related Documents.

ver. 3.3

• Form Design 
  • Attached Files - Add attachments to any object 
• Form Scripts 
  • Methods & Functions 
    • X.NAME
      Returns the name of the current object 
    • X.TEMPDIR
      Returns the temporary directory path of the Windows user 
    • X.WEBREQUEST
      Function that executes external or internal SoftOne web service requests (Examples using S1 SQL Scripts, getData and setData) 
    • GETPROPERTY('GRIDSELECTED:GRIDNAME|FIELDNAME'): string
      Returns the FIELDNAME values of the selected rows for the GRIDNAME grid. 
    • GETPROPERTY('CUSTOMFIELDS,TABLENAME'): string
      Returns all the custom fields of the defined table. Returned data are separated by semicolons. 
    • GETPROPERTY('MASTERTABLENAME'): string
      Returns the name of the current object's master table. 
    • GETPROPERTY('HASCHANGES'): boolean
      Returns true when record is on edit mode. 
  • New Case Studies 
    • ASCII Export / Import encoded file 
    • Get browser field data (including User-defined fields) 
• SBSL 
  • CREATETEXT / OPENTEXT
    New parameter – Codepage 
  • DATASETLOCATE
    Examples using with more than one fields 
  • Case Study - Read ASCII file using specific Codepage 
• Internal Printout Forms 
  • Add QR code 
• Appendix 
  • Csttypes of Cstinfo 
    
    

ver. 3.2

• Form Design
  • Analysis of all Table Properties
  • New Table Property: Sort Fields
• Form Scripts
  • New Feature (ver.520) – Parameters work in the following db functions (added examples).
    • X.GetSQLDataset
    • X.RunSQL
    • X.SQL
  • New Section “General Features”
    • Script Editor
    • Debug Javascript
    • Global Variables
    • S1P – Runs built-in functions
  • New Section “Advanced Javascript”
    • JSMain – Module triggered on Login
    • Custom Libraries
    • Debug / Test Functions
  • Custom Browser Menu (RefreshPopUpMenu)
    • Sub Menus
    • Display on Line Analysis
    • Show menu Job only when one row is selected
    • Divider
  • New Case Studies
    • 10. Run SBSL script without UI (filters screen)
    • 11. Auto apply ABC model.
    • 12. SubMenu in Button
  • Methods & Functions
    • PRINTDOCURL
      Prints a template in PDF format and returns the URL
    • SETPROPERTY('EDITOPTIONS', ''READONLY=True/False'');
      Enables / Disables record editing
    • SETPROPERTY ('FIELD', 'FieldName', READONLY, 'True/False or 1/0')
      Sets field Readonly and allows to change data through code.
    • X.FORM
      Added example
    • GΕΤXML
      Added parameter that displays/hides tags for null values.
• Object Parameters
  • NOSIDEBAR=1
• SBSL
  • UI - Info analysis (L=Lines, E0=Expandable ,etc.) for Panels
  • Oracle connection string
• XCO
  • RDefaults - Displays last login data on Login Dialog (Default=1) (0=No, 1=Yes)
  • Oracle Driver + XCO Example
  • SQL Windows Authentication

ver. 3.1

• SQL Server Windows Authentication (through XCO)
• Azure Installations
  • Autologin
  • Schedule Jobs using Windows Scheduler
• Params.cfg parameters
• Menu Commands
  • AUTOLOCATE = HeaderID
  • EXTRALOCATE = LineID
  • EDITOPTIONS = NOPRINTFORM, NOPRINTBROWSER, NOPRINTLABEL, NOINSERT, NODELETE, READONLY, NOBROWSER, ONEROW
  • STYLE = MODAL / MODELESS
  • STYLE = NEW
  • SELECTION = Name
• Object Parameters
  • CUSTOMBUFEXCLUDE = TableName (Excludes all fields of table)
  • RELJOBS = StringList
  • EDITOPTIONS = NOPRINTFORM, NOPRINTBROWSER, NOPRINTLABEL
• Form Script Functions
  • X.FORMATFLOAT
  • X.FILTERSUM Example: Check for duplicate items in Sales Document rows
• Form Scripts Examples
  • Add Relative Jobs in SoftOne Objects (Case Study 8)
  • Run External Application (Case Study 9)
  • Run function from script saved inside SoftOne Designer
    X.EXEC('CODE:SysRequest.ExecuteXScript', X.Module, 1, myDesignerScript, 'myFunction');
  • X.EVAL example with IncMonth and FormatDateTime
  • 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
  • W – Example of use in Memory Tables
  • L – LocalEditor: LookUp from row data inside an object
  • A – Excludes ISACTIVE column
  • Z – Displays both Key and Value of a string list

 

[Socrates Gekas]

Form Script 

Dialog object event "ON_AFTER_EXECUTE" - Example with mass conversion (JavaScript)

Appendix 

Command 100061 (Recalculation of Sales Documents with no confirmation messages)

[Antony Georgopoulos]

Καλημέρα.

Ευχαριστούμε πολύ.

Η δυνατότητα για COPY - PASTE είναι πάρα πολύ βοηθητική.

Μια ερώτηση, τεκμηρίωση για το DATABUF πότε θα δούμε στο BlackBook;

Γιατί και αυτό βοηθάει πάρα πολύ.

[Socrates Gekas]

Καλησπέρα,

στην επόμενη έκδοση θα υπάρχει ανάλυση της DATABUF.