Key macro allows the user to enter a dynamic field. The value of the field is a function of the entry, such as customer name, surname, area, total amount, etc. When the value is retrieved by the macro, it retrieves it as a string because all the functions you use require text (eg: CONCAT(), etc)
Key macro can be used with all your data, regardless of the current record. The user can enter any data type that fits into the string, whether integer, text, date, double, datetime or blob.
Key macro can be integrated with macros, macros with users and macros with fields.
Key macro combines all the following functions:
Actions:
Sorting
Searching
Filtering
Advanced search
Exporting to Excel
Export to PDF
Export to word
Exporting to PDF or MS Word
Export to CSV
Import to Excel
Import to CSV
Import to MS Excel
Import to Access
Import to MS Access
Import to MS SQL Server
Import to MS SQL Server
Dynamic counter
Grouping (by the field that you used)
Validation
Customisation
Customisation of the results
Dynamic setting of the default sort
Nesting
Nesting the hierarchy of your data
Data validation
Formula
Paging
Deleting
Visible/Insertable/Editable/ReadOnly
Constraining
Grouping
Totals
Multiple delete
Tables, recursive macros, functions
Macros, recursive macros, functions, when macros and functions are used together you need to specify the type of macro
When macros and functions are used together you need to specify the type of macro you're using
Working with multiple users in a single macro
Setting the default sort
Setting the default filter
Password protection
Managing rows that are not visible
Password protection
Extending SQLCMS with macros, macros with users and macros with fields
Extra Data Types:
Dates
Date ranges
Custom Types
Number
Number ranges
Radians
Radians ranges
Default values
Call to library
Custom drop down
Dynamic drop down
Text file
Excel file
MS Word file
MS Excel file
MS Access file
Compatibility with Open Office
Key macro:
- Counting by the user or the field
- Counting from the current row to a specified row
- Counting from the current row to the first record or from the first record to a specified row
- a77f14ba26 parndayb
https://www.dbcbrewery.com/profile/well ... rd/profilehttps://www.deeprootsholistic.com/profi ... fa/profilehttps://www.parrucchieristradella.it/pr ... ah/profilehttps://www.movatic.co/profile/Crime-An ... ED/profilehttps://ti.bocastwist.com/profile/jymme ... ta/profile