Switch to: V12V11V10V9V8V7V6V5

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.

DumpSortOrder

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';

Language

[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';

OnChangeType_ZeroObjectPtr

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.

TuneMode

[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

WarningMode

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

Example:

db.SqlExecute( "SET PROPERTY WarningMode TO FALSE" )

LogFilesLocation

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

Example:

db.SqlExecute( "SET PROPERTY LogFilesLocation TO 'vlogs1'" )

Please note, that if you want to have a log-folder outside of app folder - such a log-folder must exist and you should set LogFilesLocation with absolute path to that log-folder.

Example:

db.SqlExecute( "SET PROPERTY LogFilesLocation TO '/Lib/Logs/vlogs1'" )

KeyPointOptimisation

[NEW in 10.5]

This property enable/disable KeyPoint optimisation for some indexes.

-- Turn OFF optimisation:
SET PROPERTY KeyPointOptimisation TO 0;