Scripts_repository

Custom scalar functions

Custom aggregate functions

Qt scripts

• cnt() - replicates standard count(*) function from SQL - it's a simple example of how to implement aggregate function
• any() - it will select randomly one value from entire set of aggregated values of the passed column
• stddev() - "Standard Deviation" function

Custom collation scripts

Custom SQL function scripts

See Custom SQL functions chapter in User Manual for instructions how to use Custom SQL function scripts.

Qt scripts

• Display execution context - if you're not sure what variables do you have available in your QtScript function, check it with this function

Tcl scripts

• find string - finds occurrence of given string in all tables in the database
• save to file - creates a file for each data row
• evaluate Tcl code - runs any Tcl code passed in first argument to the function