QueryClear()

Clears all rows from a query

Introduced: 6.0.0.15

QueryClear( query=query );

Returns: Query

Argument Description
query
query, required

query to clear all data.

Examples

    qry = queryNew( "name, age", "varchar, integer",
        [
            [ "Susi", 20 ],
            [ "Urs", 24 ],
            [ "Smith", 21 ],
            [ "John", 26 ]
        ]);
    writeOutput("Before QueryClear :");
    writeDump(qry);

    result = queryClear(qry);

    writeOutput("After QueryClear :");
    writeDump(qry);

See also