The following tables lists and provides brief descriptions for the ASQL opcodes. Click on the opcode link for more details, parameters, comments, and examples.
Opcode |
Value |
Notes |
|---|---|---|
1 |
Initialize library |
|
2 |
End lib |
|
3 |
Get error info for last op |
|
4 |
Init connection structure |
|
SQLOP_OPTIONS |
5 |
<< replaced by SQLOP_SET_CONNATR >> |
6 |
Connect to database |
|
7 |
Disconnect from database |
|
8 |
Get misc info - per flags |
|
9 |
Execute query |
|
10 |
Fetch column info (for last query) |
|
11 |
Set column info (for last query) |
|
12 |
Fetch next row |
|
13 |
Free resources used by result set (after query) |
|
14 |
Get connection attributes (ODBC) |
|
15 |
Set connection attributes |
|
16 |
Get statement attributes (ODBC) |
|
17 |
Set statement attributes (ODBC) |
|
18 |
Get data sources (ODBC) |
|
20 |
Initialize / define a prepared statement |
|
21 |
Define parameter bindings for prepared statement |
|
22 |
Execute prepared statement |
|
23 |
Close / release prepared statement |
|
24 |
Executes SQLOP_DISCONNECT for all current connections |
|
25 |
Retrieve current result set into a gridmap |
