| Name | Summary | Category |
| database_database | [ database_database ] will return the full system path to the database registry of the current Lasso9 instance. | Database |
| database_table_datasources | [ database_table_datasources ] returns the internal table name containing datasources configuration. | Database |
| database_table_datasource_hosts | [ database_table_datasource_hosts ] returns the internal database table containing datasource hosts configuration. | Database |
| database_table_datasource_databases | [ database_table_datasource_databases ] returns internal database table containing datasource database configuration. | Database |
| database_table_database_tables | [ database_table_database_tables ] returns the internal table name containing datasources table configuration. | Database |
| database_table_table_fields | [ database_table_table_fields ] returns the internal table name containing datasources tables configuration. | Database |
| database_qs | [ database_qs ] accepts a string, or other value which will be cast as a string, adds single quotes and returns an sql92 encoded string or if no value is passed, returns null | Database |
| database_initialize | [ database_initialize ] performs the basic creation and setup of the SQLite tables used by lasso to store database connection and structure information. | Database |
| database_util_cleanPath | [database_util_cleanPath] checks the path of the string parameter, and replaces any double slash '//' with a single slash '/'. Used in database_addDefaultSQLiteHost to clean paths... | Database |
| database_addDefaultSQLiteHost | [ database_addDefaultSQLiteHost ] uses the database_registry to add the default internal SQLite host if it does not already exist. | Database |
| column | [Column] returns the value for a field from the current database search. This tag can be used within [Inline] containers that return a database found set or on the response page for a Classic Lasso... | Database |
| field | Synonymous with [ column ]. [Field] returns the value for a field from the current database search. This method can be used within [Inline] code blocks that return a database found set. ... | Database |
| column_names | The [Column_Names] method returns a staticarray that contains the names of all of the fields that were returned by the current database search. This method is usually used within [Inline] methods.... | Database |
| field_names | Synonymous with [ column_names ], the [Field_Names] method returns an array that contains the names of all of the fields that were returned by the current database search. This tag is usually used... | Database |
| column_name | [Column_Name] returns the name of a field in the current database and table. A number parameter returns the name of the field in that position within the current table. Other parameters are described... | Database |
| field_name | [Field_Name] returns the name of a field in the current database and table. A number parameter returns the name of the field in that position within the current table. Other parameters are described... | Database |
| found_count | [Found_Count] returns the total number of records found by a Lasso query. Note: The maximum number of records that is shown by Lasso on each page is set by the -MaxRecords tag. [Shown_Count]... | Database |
| lasso_currentaction | [Lasso_CurrentAction] returns the current database action which is being performed. If no database action is being performed then the string Nothing is returned. This tag can be used within... | Database |
| maxrecords_value | [MaxRecords_Value] returns the value for the -MaxRecords command tag for the current database action. The default return value is 50 if no -MaxRecords paramater was specified. This method can... | Database |
| database_name | [Database_Name] returns the name of the current database. If this method is called within [Inline] ... [/Inline] methods, it returns the name of the database which is specified in the... | Database |
| layout_name | [Layout_Name] returns the name of the current table. If this tag is called within [Inline] ... [/Inline] tags, it returns the name of the table which is specified in the parameters of the... | Database |
| keycolumn_name | [KeyColumn_Name] returns the name of the current key field. If this method is called within an [Inline] ... [/Inline] method, it returns the name of the key field which is specified in the... | Database |
| keyfield_name | [KeyField_Name] returns the name of the current key field. If this method is called within an [Inline] ... [/Inline] method, it returns the name of the key field which is specified in the... | Database |
| keycolumn_value | After a database search is performed using a -Search, -FindAll, or -Random tag, [KeyColumn_Value] returns the value of the current key field. For FileMaker Pro databases, the [KeyColumn_Value] is the... | Database |
| keyfield_value | After a database search is performed using a -Search, -FindAll, or -Random tag, [KeyField_Value] returns the value of the current key field. For FileMaker Pro databases, the [KeyField_Value] is the... | Database |
Please note that periodically LassoSoft will go through the notes and may incorporate information from them into the documentation. Any submission here gives LassoSoft a non-exclusive license and will be made available in various formats to the Lasso community.
LassoSoft Inc. > Home
©LassoSoft Inc 2015 | Web Development by Treefrog Inc | Privacy | Legal terms and Shipping | Contact LassoSoft