NAME

       DB::exec - Execute a query

SYNOPSIS

       DBResult exec( DBHandle<a>  con, String query )

DESCRIPTION

       Execute a query with the given connection handle.

    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)
        }
    }

       Non-SELECT queries will generally not return any result rows.

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.DBResult (3kaya)
       DB.DBValue (3kaya)
       DB.incExec (3kaya)

Kaya                                                July 2013                                     DB.exec(3kaya)