QueryDeleteRow()

Deletes the row within a query object. Modifies the original query object

QueryDeleteRow( query=query, row=number );

Returns: Boolean

Argument Description Default
query
query, required

Name of an executed query.
row
number, optional

The query row number to be deleted.

-9999

Examples

qry1=queryNew("a,b,c", "varchar,varchar,varchar", [["a1","b1","c1"], ["a2","b2","c2"], ["a3","b3","c3"]]);
queryDeleteRow(qry1, 2);
writeDump(valueList(qry1.a));

qry2=queryNew("a,b,c", "varchar,varchar,varchar", [["a1","b1","c1"], ["a2","b2","c2"], ["a3","b3","c3"]]);
for(i=3; i>=1; i--){
queryDeleteRow(qry2, i);
}
writeDump(qry2.RecordCount);

See also