Table of Contents
Valentina Engine Properties
On this page you can see list of Valentina Engine properties that you can control to change overall behavior of engine. You can get the list of properties using SHOW PROPERTIES command.
Defines the objects order in DDL statements of SQL-dump. Can be set to “kSchemaDefined” or “kSorted”. Default value is “kSchemaDefined”. If you set it to “kSorted” - all objects will be appeared in the dump in alphabetical order.
SET PROPERTY DumpSortOrder to 'kSchemaDefined'; SET PROPERTY DumpSortOrder to 'kSorted';
[NEW in 4.0]
This property defines the catalog name where the appropriate error resources located. Default value is “en”. So full path should be something like “c:\Program Files\Paradigma Software\Valentina Studio\VResources\en” (It contains two XMLs - kernel_errors.xml and sql_errors.xml)
If you set it to, for example, “ru” then engine will try to load resources from location
“\Program Files\Paradigma Software\Valentina Studio\VResources\ru”. If failed - a default value will be used.
SET PROPERTY Language TO 'en';
This property on default is TRUE. This means that if you convert some field to or from ObjectPtr type then old data are zeroed.
In some case-sensitive you can wish to save your old values. Then you can set temporary this value to FALSE.
[added in v3.3]
If you want that Valentina produce log file that contains execution plan and profile of each SQL query then you can set the
TuneMode global property to be TRUE. Log file has name as “Tunes_YYYYMMDD_HHMMSS.log”.
The value FALSE stops logging of tune information. This is the default value.
SET PROPERTY TuneMode TO TRUE SET PROPERTY TuneMode TO FALSE
If you want to see warnings produced by Valentina Kernel you can set the WarningMode global property to the TRUE value. Warnings will be placed in the file named “Warnings_YYYYMMDD_HHMMSS.log”. This is the default value.
The value FALSE stops logging of warnings.
SET PROPERTY WarningMode TO TRUE SET PROPERTY WarningMode TO FALSE
db.SqlExecute( "SET PROPERTY WarningMode TO FALSE" )
You may tune the location where warnings and tunes logs should be placed in. Default folder is 'vlogs' (will be automatically created if not exist).
In client-server environment this property is ignored and you should operate with vserver's LogFilesLocation property instead.
SET PROPERTY LogFilesLocation TO 'myLogsLocation' GET PROPERTY LogFilesLocation
db.SqlExecute( "SET PROPERTY LogFilesLocation TO 'vlogs1'" )
Please note, that if you want to change the default log-folder location - such a log-folder must exist and you should set LogFilesLocation with absolute path to that log-folder. Default location for any ADK is:
- Mac: ~/Library/Logs/ADK_name/vlogs
- Linux: ~/.cache/ADK_name/vlogs
- Win: HOMEDRIVE\HOMEPATH\Application Data\ADK_name\vlogs
db.SqlExecute( "SET PROPERTY LogFilesLocation TO '/Lib/Logs/vlogs1'" )
[NEW in 10.5]
This property enable/disable KeyPoint optimisation for some indexes.
-- Turn OFF optimisation: SET PROPERTY KeyPointOptimisation TO 0;