DB-Grid Functions

GridSetSqlStmt

DeclarationGridSetSqlStmt(string Win, string Elem, string Stmt)
FunctionSets the SQL statement stmt of the data grid specified by Elem in the Win window.
Cross-referenceGridRefresh
ExampleGridSetSqlStmt(‘Fenster_1’, ‘Datengrid_1’, ‘select * from P_VALUES’)
GridRefresh(‘Fenster_1’, ‘Datengrid_1’)

GridRefresh

DeclarationGridRefresh(string Win, string Elem)
FunctionRefreshes the data grid specified by Elem in the Win window.
Cross-reference
ExampleGridRefresh(‘Fenster_1’, ‘Datengrid_1’)

GridGetCol

Declarationlong GridGetCol(string Win, string Elem)
FunctionReturns the currently selected column of the data grid specified by Elem in the Win window (if no column is selected, -1 is supplied …).
Cross-referenceGridSetCol
Examplelong l
l := GridGetCol(‘Fenster_1’, ‘Datengrid_1’)

GridGetRow

Declarationlong GridGetRow(string Win, string Elem)
FunctionReturns the currently selected data record of the data grid specified by Elem in the Win window (for the first record 0 is supplied …).
Cross-reference
Examplelong l
l := GridGetRow(‘Fenster_1’, ‘Datengrid_1’)

 GridGetText

Declarationstring GridGetCol(string Win, string Elem)
FunctionReturns the contents of the column where the cursor is located.
Cross-referenceGridSetText
Examplestring s
s := GridGetText(‘Fenster_1’, ‘Datengrid_1’)

 GridSetCol

DeclarationGridSetCol(string Win, string Elem, long Col)
FunctionSets the currently selected column of the data grid specified by Elem to Col in the Win window.
Cross-referenceGridGetCol
ExampleGridSetCol(‘Fenster_1’, ‘Datengrid_1’, 2)

GridSetRow

DeclarationGridSetRow(string Win, string Elem, long Row)
FunctionSets the currently selected data record of the data grid specified by Elem to Row in the Win window (for the first record 0 must be passed …).
Cross-reference
ExampleGridSetRow(‘Fenster_1’, ‘Datengrid_1’, 5)

GridSetText

DeclarationGridSetText(string Win, string Elem, string Txt)
FunctionSets the contents of the column in which the cursor is located to Txt.
Cross-referenceGridGetText
ExampleGridSetText(‘Fenster_1’, ‘Datengrid_1’, ‘Test’)