  |
GoFiler Legato Script Reference
Legato v 1.5d Application v 5.25a
|
| Table of Contents | < < Previous | Next >> |
Chapter Eight — Data Functions
8.1 Introduction to Data Support
Legato provides a wide range of data management tools and functions ranging from primitives for arrays to high-level SQL access. This section covers those functions. In addition, high-level access is provided through application specific functions for Data View, Data Control and Forms View. Even higher level access for certain edit views such as EDGAR Submission View or Form 13F View. These are covered in Part II — The Application later in this reference manual.
This chapter does not discuss best practices or database structure. Those are subjects have filled many books. The intent is to describe the functions to provide access to the programmer.
A suite of functions are provided to support the reading and writing of comma separated values (CSV, aka coma delimited data). CSV data can be read and written from strings, files and the clipboard.
A series of functions are provided to aid in converting formatted text into structured array data.
Array tools oriented towards data management are provided over and above the suite of array tools discussed in the Variables Functions section in chapter 3. These include moving data in and out of arrays and tables, searching, inserting, deleting and sorting data items.
An important part of array access is the availability of ‘key names’ or index aliases. This gives the ability to reference lists or tables of data by name rather than integer index.
An interface to Microsoft’s ODBC (Open Database Connectivity) is provided to give access to SQL and other database servers.
Data Sheet is the underlying control class for Data Controls and variations of Data View used in many edit views within the application. Data Sheet provides a high-level ‘sheet’ style collection of data allowing for numerous attributes and types of data as well as interchange with other formats.
| Table of Contents | < < Previous | Next >> |
© 2012-2024 Novaworks, LLC. All rights reserved worldwide. Unauthorized use, duplication or transmission prohibited by law. Portions of the software are protected by US Patents 10,095,672, 10,706,221 and 11,210,456. GoFiler™ and Legato™ are trademarks of Novaworks, LLC. EDGAR® is a federally registered trademark of the U.S. Securities and Exchange Commission. Novaworks is not affiliated with or approved by the U.S. Securities and Exchange Commission. All other trademarks are property of their respective owners. Use of the features specified in this language are subject to terms, conditions and limitations of the Software License Agreement.