query.insertAt()

Adds data (query,struct or array) into query.

Introduced: 6.0.0.16

query.insertAt( value=any, index=numeric )

Returns: Query

Argument Description
value
any, required

data to insert, can be a query, a struct or an array.
index
numeric, required

position to insert data into, existing data get moved to the "right".

Examples

qry1 = queryNew( "name, age", "varchar, integer",
        [
            [ "Susi", 20 ],
            [ "Urs", 24 ],
            [ "Smith", 21 ],
            [ "John", 26 ]
        ]);
    qry2 = queryNew( "name, age", "varchar, integer",
        [
            [ "Jeni", 19 ]
        ]);
    writeOutput("Before QueryInsert :");    
    writeDump(qry1);
    qry1.insertAt( qry2, 3 );
    writeOutput("After QueryInsert :");
    writeDump(qry1);

See also