1DB.DBIncResult(3kaya) Kaya module reference DB.DBIncResult(3kaya)
2
3
4
6 DB::DBIncResult - An incremental query result
7
9 DB::DBIncResult< a >
10
11
12 = DBIncRes(DB::DBHandle<a> con,Int rows,Int cols,[String] colnames,Ptr
13 resptr)
14
16 DBIncResult holds data about the result of an incremental query, if the
17 database-specific library supports these.
18
19
20 - rows is the number of rows in the result set.
21
22
23 - cols is the number of columns in each row of the result set.
24
25
26 - colnames is a list of the names of the columns
27
28
29 - resptr is an internal pointer kept by the relevant database interface.
30
31 An incremental query returns data only one row at a time, which may
32 save memory on large result sets. Depending on the internal implementa‐
33 tion in the database-specific library, the rows field may not contain
34 useful information. Database-specific libraries should throw an Excep‐
35 tion if an attempt is made to read more rows than exist.
36
37
38 res = incExec(conn,"SELECT id,name FROM People");
39 row = getRow(res);
40 // row[0] = DBInt(id)
41 // row[1] = DBText(name)
42
44 Kaya standard library by Edwin Brady, Chris Morris and others
45 (kaya@kayalang.org). For further information see http://kayalang.org/
46
48 The Kaya standard library is free software; you can redistribute it
49 and/or modify it under the terms of the GNU Lesser General Public
50 License (version 2.1 or any later version) as published by the Free
51 Software Foundation.
52
54 DB.DBResult (3kaya)
55 DB.DBValue (3kaya)
56 DB.getRow (3kaya)
57 DB.incDiscard (3kaya)
58 DB.incExec (3kaya)
59
60
61
62Kaya December 2010 DB.DBIncResult(3kaya)