'LAG DATABASE LIST OF COMMANDS:

'

'SAVE

'Purpose:

'Saves the database.

'Syntax:

'SAVE(FILE NAME{text})

'Examples:

'SAVE(d:\databasefile.lagdb)

'SAVE

'Comment:

'If the file name parameter is missing or is empty then the command will save the data into the last saved file. This means you have to actually save the content of the database(not just open a file) before using the command without(or empty) parameter.

'

'NEW

'Purpose:

'Creates a new database.

'Syntax:

'NEW(FILE NAME{text})

'Example:

'NEW(d:\newdatabasefile.lagdb)

'

'OPEN

'Purpose:

'Opens a database file.

'Syntaxes:

'OPEN(FILE NAME{text},READ ONLY{"TRUE","FALSE"}, CACHE CONTENT{"TRUE","FALSE"})

'OPEN(FILE NAME{text})

'Examples:

'OPEN(d:\existingdatabasefile.lagdb,FALSE,FALSE)

'OPEN(d:\existingdatabasefile.lagdb)

'Comment:

'If only the first parameter is given(the file name) then the command will try to open the database read-only with cached content.

'

'IMPORTFROMDIRECTORY

'Purpose:

'Imports data into the database from a directory.

'Syntax:

'IMPORTFROMDIRECTORY(DIRECTORY{text},

'Example:

'IMPORTFROMDIRECTORY(d:\datadirectory)

'

'EXPORTTODIRECTORY

'Purpose:

'Exports database data into a directory.

'Syntax:

'EXPORTTODIRECTORY(DIRECTORY NAME{TEXT})

'Example:

'EXPORTTODIRECTORY(d:\datadirectory)

'

'IMPORTFROMFILE

'Purpose:

'Imports data into the database from a tab separated values(TSV) or a hypertext markup language(HTML) file.

'Syntax:

'IMPORTFROMFILE(FILE NAME{text}, FILE TYPE{"TSV","HTML"}, FIRST ROW CONTAINS COLUMNS NAMES{"TRUE","FALSE"})

'Examples:

'IMPORTFROMFILE(d:\tsvfile.txt,tsv,true)

'IMPORTFROMFILE(d:\htmlfile.html,html,true)

'

'EXPORTTOFILE

'Purpose:

'Exports database data into a tab separated values(TSV) or a hypertext markup language(HTML) file.

'Syntax:

'EXPORTTOFILE(FILE NAME{text}, FILE TYPE{"TSV","HTML"}, FIRST ROW CONTAINS COLUMNS NAMES{"TRUE","FALSE"})

'Examples:

'EXPORTTOFILE(d:\tsvfile.txt,tsv,true)

'EXPORTTOFILE(d:\htmlfile.html,html,true)

'

'SETDEPENDENCIES

'Purpose:

'Sets database dependencies.

'Syntax:

'SETDEPENDENCIES(DEPENDENCIES{text})

'Example:

'SETDEPENDENCIES(d:\images.lagdb;d:\lagdbsdirectory\***,~*)

'Comments:

'Dependencies have to be separated by semicolon(";").

'* returns all files within a directory.

'** returns all files within the subdirectories.

'*** returns all files within the directory and all files within subdirectories, recursive mode.

'~ returns current directory.

'

'GETDEPENDENCIES

'Purpose:

'Shows database dependencies.

'Syntax:

'GETDEPENDENCIES

'Example:

'GETDEPENDENCIES

'

'GETINFORMATIONFONT

'Purpose:

'Shows the font used for displaying database informations.

'Syntax:

'GETINFORMATIONFONT

'Example:

'GETINFORMATIONFONT

'

'SETINFORMATIONFONT

'Purpose:

'Sets the font used for displaying database informations.

'Syntax:

'SETINFORMATIONFONT(NEW FONT{text})

'Example:

'SETINFORMATIONFONT(MS Sans Serif,8,clRed,Bold,Italic)

'Comment:

'The syntax of the font is: font name, font size, font colour, font style, all of them separated by comma(",").

'

'GETTABLEFONT

'Purpose:

'Shows the font used for displaying database table.

'Syntax:

'GETTABLEFONT

'Example:

'GETTABLEFONT

'

'SETTABLEFONT

'Purpose:

'Sets the font used for displaying database table.

'Syntax:

'SETTABLEFONT(NEW FONT{text})

'Example:

'SETTABLEFONT(MS Sans Serif,8,clRed,Bold,Italic)

'Comment:

'The syntax of the font is: font name, font size, font colour, font style, all of them separated by comma(",").

'

'GETLINESCOLOUR

'Purpose:

'Shows the colour of the table lines.

'Syntax:

'GETLINESCOLOUR

'Example:

'GETLINESCOLOUR

'

'SETLINESCOLOUR

'Purpose:

'Sets the colour of the table lines.

'Syntax:

'SETLINESCOLOUR(COLOUR{text})

'Example:

'SETLINESCOLOUR(Blue)

'

'GETTABLETHICKNESS

'Purpose:

'Shows the value of table lines thickness.

'Syntax:

'GETTABLETHICKNESS

'Example:

'GETTABLETHICKNESS

'

'SETTABLETHICKNESS

'Purpose:

'Sets the value of table lines thickness.

'Syntax:

'SETTABLETHICKNESS(TABLE THICKNESS{positive integer number[0,5]})

'Example:

'SETTABLETHICKNESS(3)

'

'GETFORCEALIASEDFONTRENDER

'Purpose:

'Shows if fonts are always rendered aliased.

'Syntax:

'GETFORCEALIASEDFONTRENDER

'Example:

'GETFORCEALIASEDFONTRENDER

'

'SETFORCEALIASEDFONTRENDER

'Purpose:

'Sets if fonts are always rendered aliased.

'Syntax:

'SETFORCEALIASEDFONTRENDER(FORCE ALIASED FONT RENDER{"TRUE","FALSE"})

'Example:

'SETFORCEALIASEDFONTRENDER(TRUE)

'Comment:

'Forcing aliased font render makes some fonts look ugly and at the same time it reduces CPU usage.

'

'GETMAXIMUMCELLRENDEREDCHARACTERS

'Purpose:

'Shows the maximum number of cell characters that are rendered.

'Syntax:

'GETMAXIMUMCELLRENDEREDCHARACTERS

'Example:

'GETMAXIMUMCELLRENDEREDCHARACTERS

'Comments:

'If a column has width set to automatic resize and column cells contain many characters(like a binary file) then instead of having huge column widths with no important information displayed, only a limited number of characters are rendered. That number is the value of maximum cell rendered characters.

'Value -1 means all characters are rendered while value 0 means no characters will be rendered.

'

'SETMAXIMUMCELLRENDEREDCHARACTERS

'Purpose:

'Sets the maximum number of cell characters that are rendered.

'Syntax:

'SETMAXIMUMCELLRENDEREDCHARACTERS(MAXIMUM CELL RENDERED CHARACTERS{integer number greater or equal to -1})

'Example:

'SETMAXIMUMCELLRENDEREDCHARACTERS

'Comments:

'If a column has width set to automatic resize and column cells contain many characters(like a binary file) then instead of having huge column widths with no important information displayed, only a limited number of characters are rendered. That number is the value of maximum cell rendered characters.

'Value -1 means all characters are rendered while value 0 means no characters will be rendered.

'

'GETSCROLLBARTHICKNESS

'Purpose:

'Shows the value of scroll bar thickness

'Syntax:

'GETSCROLLBARTHICKNESS

'Example:

'GETSCROLLBARTHICKNESS

'

'SETSCROLLBARTHICKNESS

'Purpose:

'Sets the value of scroll bar thickness

'Syntax:

'SETSCROLLBARTHICKNESS(SCROLL BAR THICKNESS{positive integer number[5,50]})

'Example:

'SETSCROLLBARTHICKNESS(5)

'

'GETSCROLLSTEP

'Purpose:

'Shows the value of scroll step.

'Syntax:

'GETSCROLLSTEP

'Example:

'GETSCROLLSTEP

'Comment:

'Value 0 means that an entire page is being translated.

'

'SETSCROLLSTEP

'Purpose:

'Sets the value of scroll step.

'Syntax:

'SETSCROLLSTEP(SCROLL STEP{positive integer number[0,200]})

'Example:

'SETSCROLLSTEP(5)

'Comment:

'Value 0 means that an entire page is being translated.

'

'EXPORTCELLTOFILE

'Purpose:

'Exports cell content into a file.

'Syntax:

'EXPORTCELLTOFILE(CELL ROW{integer number}, CELL COLUMN{integer number}, FILE NAME{text})

'Example:

'EXPORTCELLTOFILE(1,1,d:\1_1_content.bin)

'

'IMPORTCELLFROMFILE

'Purpose:

'Imports cell content from a file.

'Syntax:

'IMPORTCELLFROMFILE(CELL ROW{integer number}, CELL COLUMN{integer number}, FILE NAME{text})

'Example:

'IMPORTCELLFROMFILE(1,1,d:\1_1_content.bin)

'

'EDITCELL

'Purpose:

'Sets cell content.

'Syntax:

'EDITCELL(CELL ROW{integer number}, CELL COLUMN{integer number}, CELL CONTENT{text})

'Example:

'EDITCELL(1,1,Cell content)

'

'CLEARCELL

'Purpose:

'Empties cell content.

'Syntax:

'CLEARCELL(CELL ROW{integer number}, CELL COLUMN{integer number})

'Example:

'CLEARCELL(1,1)

'

'ADDROWS

'Purpose:

'Adds rows to a table.

'Syntax:

'ADDROWS(NUMBER OF ROWS TO BE ADDED{positive integer number})

'Example:

'ADDROWS(3)

'

'DELETEROW

'Purpose:

'Removes rows from a table.

'Syntax:

'DELETEROW(ROW INDEX{positive integer number})

'Example:

'DELETEROW(3)

'Comment:

'The very first row has index 0.

'

'INSERTROWS

'Purpose:

'Inserts a series of rows.

'Syntax:

'INSERTROWS(ROW INDEX{integer number}, NUMBER OF ROWS TO BE INSERTED{positive integer number})

'Example:

'INSERTROWS(1,10)

'Comment:

'The very first row has index 0.

'

'GETROWSCOUNT

'Purpose:

'Shows the number of table rows.

'Syntax:

'GETROWSCOUNT

'Example:

'GETROWSCOUNT

'

'SETROWSCOUNT

'Purpose:

'Sets the number of table rows.

'Syntax:

'SETROWSCOUNT(ROWS COUNT{integer number})

'Example:

'SETROWSCOUNT(10);

'

'INVERTROWS

'Purpose:

'Inverts the table rows.

'Syntax:

'INVERTROWS

'Example:

'INVERTROWS

'Comment:

'The command exchanges the first row with the last row, the second row with the penultimate row,...

'

'EXCHANGEROWS

'Purpose:

'Exchanges two rows.

'Syntax:

'EXCHANGEROWS(FIRST ROW INDEX{integer number}, SECOND ROW INDEX{integer number})

'Example:

'EXCHANGEROWS(1,10)

'Comment:

'The very first row has index 0.

'

'SORTBYROWVALUESASCENDING

'Purpose:

'Sorts the table by row values, ascending mode.

'Syntax:

'SORTBYROWVALUESASCENDING(ROW INDEX{integer number})

'Example:

'SORTBYROWVALUESASCENDING(1)

'Comment:

'The very first row has index 0.

'

'SORTBYROWVALUESDESCENDING

'Purpose:

'Sorts the table by row values, descending mode.

'Syntax:

'SORTBYROWVALUESDESCENDING(ROW INDEX{integer number})

'Example:

'SORTBYROWVALUESDESCENDING(1)

'Comment:

'The very first row has index 0.

'

'ADDROWFROMDATA

'Purpose:

'Adds an entire row filling cells data.

'Syntax:

'ADDROWFROMDATA(ROW DATA{text})

'Example:

'ADDROWFROMDATA(5,cell15,cell26,cell331,X)

'Comments:

'Row data syntax is: the number of characters of first cell, followed by comma(",") followed by first cell content, followed by the number of characters of the second cell, followed by comma(",") followed by second cell content.

'For the above example:5{number of characters of the first cell},{separator}cell1{first cell 5 characters long content}5{number of characters of the second cell},{separator}cell2{second cell 5 characters long content}6{number of characters of the third cell},{separator}cell33{third cell 6 characters long content}1{number of characters of the fourth cell},{separator}X{fourth cell 1 characters long content}

'

'ADDCOLUMNS

'Purpose:

'Adds columns to a table.

'Syntax:

'ADDCOLUMNS(NUMBER OF COLUMNS TO BE ADDED{positive integer number})

'Example:

'ADDCOLUMNS(3)

'

'DELETECOLUMN

'Purpose:

'Removes a column from a table.

'Syntax:

'DELETECOLUMN(COLUMN INDEX{positive integer number})

'Example:

'DELETECOLUMN(3)

'Comment:

'The very first column has index 0.

'

'INSERTCOLUMNS

'Purpose:

'Inserts a series of columns.

'Syntax:

'INSERTCOLUMNS(COLUMN INDEX{integer number}, NUMBER OF COLUMNS TO BE INSERTED{positive integer number})

'Example:

'INSERTCOLUMNS(1,10)

'Comment:

'The very first column has index 0.

'

'GETCOLUMNSCOUNT

'Purpose:

'Shows the number of table columns.

'Syntax:

'GETCOLUMNSCOUNT

'Example:

'GETCOLUMNSCOUNT

'

'SETCOLUMNSCOUNT

'Purpose:

'Sets the number of table columns.

'Syntax:

'SETCOLUMNSCOUNT(COLUMNS COUNT{integer number})

'Example:

'SETCOLUMNSCOUNT(10);

'

'INVERTCOLUMNS

'Purpose:

'Inverts the table columns.

'Syntax:

'INVERTCOLUMNS

'Example:

'INVERTCOLUMNS

'Comment:

'The command exchanges the first column with the last column, the second column with the penultimate column,...

'

'EXCHANGECOLUMNS

'Purpose:

'Exchanges two columns.

'Syntax:

'EXCHANGECOLUMNS(FIRST COLUMN INDEX{integer number}, SECOND COLUMN INDEX{integer number})

'Example:

'EXCHANGECOLUMNS(1,10)

'Comment:

'The very first column has index 0.

'

'EXCHANGECELLS

'Purpose:

'Exchanges two cells.

'Syntax:

'EXCHANGECELLS(FIRST CELL ROW INDEX{integer number}, FIRST CELL COLUMN INDEX{integer number}, SECOND CELL ROW INDEX{integer number}, SECOND CELL COLUMN INDEX{integer number})

'Example:

'EXCHANGEROWS(1,10,3,5)

'Comment:

'The very first row and column have index 0.

'

'SORTBYCOLUMNVALUESASCENDING

'Purpose:

'Sorts the table by column values, ascending mode.

'Syntax:

'SORTBYCOLUMNVALUESASCENDING(COLUMN INDEX{integer number})

'Example:

'SORTBY COLUMNVALUESASCENDING(1)

'Comment:

'The very first column has index 0.

'

'SORTBYCOLUMNVALUESDESCENDING

'Purpose:

'Sorts the table by column values, descending mode.

'Syntax:

'SORTBYCOLUMNVALUESDESCENDING(COLUMN INDEX{integer number})

'Example:

'SORTBYVALUESDESCENDING(1)

'Comment:

'The very first column has index 0.

'

'RENAMECOLUMN

'Purpose:

'Renames a column.

'Syntax:

'RENAMECOLUMN(COLUMN INDEX{integer number}, NEW NAME{text})

'Example:

'RENAMECOLUMN(1,AVERAGE ANGLE [AVANGLE])

'Comment:

'The very first column has index 0.

'

'GETCOLUMNWIDTH

'Purpose:

'Shows the width in pixels of a column.

'Syntax:

'GETCOLUMNWIDTH(COLUMN INDEX{integer number})

'Example:

'GETCOLUMNWIDTH(1);

'Comments:

'The very first column has index 0.

'Negative values mean the column should auto-determine the width according to cells content.

'

'SETCOLUMNWIDTH

'Purpose:

'Sets the width in pixels of a column.

'Syntax:

'SETCOLUMNWIDTH(COLUMN INDEX{integer number},COLUMN WIDTH{integer number})

'Example:

'SETCOLUMNWIDTH(1,50);

'Comments:

'The very first column has index 0.

'Negative column widths mean the column should auto-determine the width according to cells content.

'

'GETCOMMENT

'Purpose:

'Shows the comment of database.

'Syntax:

'GETCOMMENT

'Example:

'GETCOMMENT

'

'SETCOMMENT

'Purpose:

'Sets the comment of the database.

'Syntax:

'SETCOMMENT(COMMENT{text})

'Example:

'SETCOMMENT(Comment);

'

'GETCOMMENTPOSITION

'Purpose:

'Shows the position of the database comment.

'Syntax:

'GETCOMMENTPOSITION

'Example:

'GETCOMMENTPOSITION

'Comment:

'The command returns one of the following values: "0" or "HIDDEN", "1" or "TOP", "2" or "BOTTOM".

'

'SETCOMMENTPOSITION

'Purpose:

'Sets the position of the database comment.

'Syntax:

'SETCOMMENTPOSITION(COMMENT POSITION{"0","1","2","HIDDEN","TOP","BOTTOM"})

'Example:

'SETCOMMENTPOSITION(TOP);

'Comment:

'Comment position can be one of the following values: "0" or "HIDDEN", "1" or "TOP", "2" or "BOTTOM".

'

'GETPRIORITYVALUES

'Purpose:

'Shows priority values.

'Syntax:

'GETPRIORITYVALUES

'Example:

'GETPRIORITYVALUES

'Comment:

'Priority values separated by ";" character and they override cell stored values.

'

'SETPRIORITYVALUES

'Purpose:

'Sets priority values.

'Syntax:

'SETPRIORITYVALUES(PRIORITY VALUES{text});

'Example:

'SETPRIORITYVALUES([a]=100;[b]=22)

'Comment:

'Priority values are separated by semicolon(";") character and they override cell stored values.

'Instance: A database with 2 columns where the first column(index 0) has the alias "[a]", the second column(index 1) is INTERPRET type, visualization mode is set to USER, the first cell has the value "11" and the second cell has the value "[a]*2". The database will show value "+22" when reading the data for the second cell. At this moment, setting priority values to "[a]=100" will change the shown value for the second cell to "+200".

'

'GETCOLUMNTYPE

'Purpose:

'Shows the type of the column.

'Syntax:

'GETCOLUMNTYPE(COLUMN INDEX{integer number})

'Example:

'GETCOLUMNTYPE(3);

'Comments:

'The very first column has index 0.

'The command returns one of the following values: "1" or "As-Is", "2" or "Interpret".

'

'SETCOLUMNTYPE

'Purpose:

'Sets the type of the column.

'Syntax:

'SETCOLUMNTYPE(COLUMN INDEX{integer number}, COLUMN TYPE{"1","2","AS-IS","INTERPRET"})

'Example:

'SETCOLUMNTYPE(3,INTERPRET);

'Comments:

'The very first column has index 0.

'Column type can be one of the following values: "1" or "As-Is", "2" or "Interpret".

'When column type is "AS-IS", displayed data is exactly the cell content. This means that even the cell contains a formula, the formula will not be applied and it will be displayed.

'When column type is "INTERPRET", then when reading cell data from that column, the data might be interpreted according to cell content(formulas). This happens only in user visualization mode, not in developer mode.

'The following syntaxes are implemented:

'[x,y) Intervals(open or closed) by using the average(middle)value.

'[Aliastext] Content of the cell on the same row number in the file that contains a column with Aliastext. Database dependencies are used if the alias is not found within the main database file.

'+,-,*,/,(,) Basic arithmetic operations using parenthesis.

'arcsindeg{DEGREES{real number}} Computes the arc-sinus of the value expressed in degrees.

'arcsinrad{RADIANSS{real number}} Computes the arc-sinus of the value expressed in radians.

'arccosdeg{DEGREES{real number}} Computes the arc-cosinus of the value expressed in degrees.

'arccosrad{RADIANSS{real number}} Computes the arc-cosinus of the value expressed in radians.

'tandeg{DEGREES{real number}} Computes the tangent of the value expressed in degrees.

'tanrad{RADIANSS{real number}} Computes the tangent of the value expressed in radians.

'sindeg{DEGREES{real number}} Computes the sinus of the value expressed in degrees.

'sinrad{RADIANSS{real number}} Computes the sinus of the value expressed in radians.

'cosdeg{DEGREES{real number}} Computes the cosinus of the value expressed in degrees.

'cosrad{RADIANSS{real number}} Computes the cosinus of the value expressed in radians.

'abs{VALUE{real number}} Computes the absolute(non-negative) of the value.

'log{VALUE{real number}} Computes the logarithm(base 10) of the value.

'As a recommendation, it is a good practice to add parenthesis to the values: "sindeg(48.99)" instead of "sindeg48.99", "abs([ANGLE])" instead of "abs[ANGLE]".

'As a reminder: the cell content is interpreted only when column type is set to "INTERPRET" and visualization mode is set to "USER".

'In order to increase speed interpreted data might be (upper/lower)case sensitive.

'

'GETVISUALIZATIONMODE

'Purpose:

'Shows the database visualization mode.

'Syntax:

'GETVISUALIZATIONMODE

'Example:

'GETVISUALIZATIONMODE

'Comment:

'The command returns one of the following values: "DEVELOPER" or "USER".

'

'SETVISUALIZATIONMODE

'Purpose:

'Sets the database visualization mode.

'Syntax:

'SETVISUALIZATIONMODE(VISUALIZATION MODE{"DEVELOPER","USER"})

'Examples:

'SETVISUALIZATIONMODE(USER);

'SETVISUALIZATIONMODE(DEVELOPER);

'Comment:

'Setting visualization mode to "USER" makes database engine interpret cell content values of the cells found in "INTERPRET" type columns.

'Setting visualization mode to "DEVELOPER" makes database engine read cell content values "AS-IS" regardless of the column type value.