DB::DBResult(3) A query result

SYNOPSIS

DB::DBResult< >
= DBRes([[DB::DBValue]] table,Int rows,Int cols,[String] colnames,Ptr resptr)

DESCRIPTION

DBResult holds data about the result of a query.

- table gives the result of the query. It will usually be empty for non-SELECT queries.
- rows is the number of rows in the result set.
- cols is the number of columns in each row of the result set.
- colnames is a list of the names of the columns
- resptr is an internal pointer kept by the relevant database interface.

 res = exec(conn,"SELECT id,name FROM People");
 if (res.rows > 0) {
     for row in res.table {
         // row[0] = DBInt(id)
         // row[1] = DBText(name)
     }
 }

AUTHORS

Kaya standard library by Edwin Brady, Chris Morris and others ([email protected]). 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.DBIncResult(3kaya)

DB.DBValue(3kaya)

DB.exec(3kaya)