DTW_TB_DELETEROW

AIX HP-UX Linux OS/2 OS/390 OS/400 PTX SUN Win NT
X X
X X X X X X

Purpose

Deletes one or more rows from a Net.Data table.

Format

@DTW_TB_DELETEROW(table, start_row, rows)

Parameters

Table 126. DTW_TB_DELETEROW Parameters
Data Type Parameter Use Description
table table INOUT The macro table variable from which rows are to be deleted.
integer start_row IN The row number of the first row in table to delete.
integer rows IN The number of rows to delete from table.

Return Codes

Table 127. DTW_TB_DELETEROW Return Codes
Return Code Explanation
-1001 The server could not process a Net.Data request to allocate memory.
1001 An input parameter contained a NULL value.
1003 An incorrect number of parameters were passed on a function call.
1004 A parameter passed on a function call, required to be a Net.Data macro table variable, was of a different variable type.
1005 A parameter passed on a function call, required to be a string variable, was of a different variable type.
1007 A parameter contains a value which is not valid.
1008 A parameter is outside of table bounds.

Usage Notes

The number of columns in the table must be set before calling DTW_TB_DELETEROW(). You can set the number of columns with the DTW_TB_SETCOLS() or DTW_TB_INSERTCOL() functions, or by passing the table to a language environment to be set.

Examples

Example 1: Deletes five rows starting at row 10 of a table

%DEFINE myTable = %TABLE
 
@DTW_TB_DELETEROW(myTable, "10", "5")

Example 2: Deletes all of the rows of a table

%DEFINE myTable = %TABLE
 
@DTW_TB_DELETEROW(myTable, "1", @DTW_TB_rROWS(myTable))


[ Top of Page | Previous Page | Next Page | Index ]