---
name: "DB.incExec"
section: "3kaya"
platform: "linux"
package: "kaya"
version: "0.4.4-6.2"
release: "Debian 8 (Jessie)"
platforms: ["linux"]
url: "https://new.carta.tech/DB.incExec"
---

# DB.incExec(3kaya)

Execute an incremental query

## NAME

DB::incExec - Execute an incremental query

## SYNOPSIS

**DBIncResult\<a\> incExec(** *DBHandle\<a\>  con, String query* **)**

## DESCRIPTION

Execute a query with the given connection handle for incremental retrieval of results. Results are then retrieved one row at a time using **DB.getRow (3kaya)**\
  Once you have finished with the query you must call **DB.incDiscard (3kaya)** to discard any remaining rows.

-

   res = incExec(conn,"SELECT id,name FROM People");\
    row = getRow(res);\
    // row\[0\] = DBInt(id)\
    // row\[1\] = DBText(name)\
    incDiscard(res);

## AUTHORS

Kaya standard library by Edwin Brady, Chris Morris and others (kaya@kayalang.org). For further information see http://kayalang.org/

## LICENSE

The Kaya standard library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License (version 2.1 or any later version) as published by the Free Software Foundation.

## RELATED

**DB.DBHandle (3kaya)**

**DB.DBIncResult (3kaya)**

**DB.DBValue (3kaya)**

**DB.exec (3kaya)**

**DB.getRow (3kaya)**

**DB.incDiscard (3kaya)**