Топ-100
 
CerebroSQL

Query Editor Hints

A hint is a hint to the editor engine to perform additional actions.

Each hint must be on a separate line, separator;  at the end is indicated.

Hints
  • print_on  - enable information output to the Output tab of the current sheet of the query editor.

Information is not displayed in the grid, the program opens the cursor, traverses the entire data set and displays information in the field, then closes the cursor

  • print_off  - disable information output to the Output window of the current sheet

  • clear_out  - clear the Output tab

  • colname_on  - Show the names of the columns of the output data

  • colname_off  - Do not show the names of the columns of the output data (by default)

  • cstr ('')  - Output the string in parentheses. The string must be surrounded by single quotes

  • delim ()  - add a separator specified in parentheses for lines in the output. Any character, string, or numbers can be used as a separator. Single quotes are not required

  • qpr_on  - enable the output of the text of the completed request

  • qpr_off  - disable the output of the text of the completed request (by default)

  • rdelim_on  - display the column separator in the output

  • rdelim_off  - do not display the column separator in the output (default)

  • snum_on  - add line numbering in the output

  • snum_off  - do not show line numbering in output (default)

  • qset  - creating a global variable for the sheet. A variable is a pair: variable name = value. Both parameters are of type - Text.

command format:

qset ('variable name', 'value');

​​

IMPORTANT: variable names must differ by the first characters, not the last, i.e.

Correctly

  1. qset ('str', 'value 1');

  2. qset ('2str', 'value 2'); 

Wrong

  1. qset ('str', 'value 1');

  2. qset ('str2', 'value 2');  

Using a variable in the text of requests

To use a variable with the text of requests, you must specify its name in the format ##varname

Using qset.jpg

  • qunset  - delete a global variable. Command format: qunset ('variable name')

Viewing the set variables

To view the set variables, you must use the mechanism for viewing the memory structures of sheets

General menu -  View list info (memory data)

Select "Lists" in the tree

View list info.jpg