| Allegro CL version 10.0 Object described on page has changed in 10.0. 9.0 version | ||||||||||
Arguments: &key db hstmt row-count width types
Execute the sql statement that was last prepared via prepare-sql. The prepared sql statement is associated with the statement handle.
If statement handle hstmt is true then it
is used for the conversation with its associated database. Otherwise
if
db is true then it is the database on
which the sql statement will be run. If db is
also
nil then the
database used is the one that is the value of *default-database*.
width is the size for character buffers used in retrieving character-valued fields. If not given, then the width for the database, db-width, is used.
types should be either the
keyword :auto or a list of type specifiers from the
following table. The value
:auto means that the types will be determined
automatically from the query results.
| Specifier | Meaning |
| :int | return as a 4 byte signed value |
| :long | return as a 4 byte signed value |
| :double | return as an 8 byte floating point value |
| t | return as a string or
nil for the null value (the default) |
If the sql statement is parameterized then values for all of the parameters must be bound before the statement is executed.
The returned values are the same as for the sql function and are documented in sql's description.
See aodbc.htm for more information on Allegro ODBC.
Copyright (c) 1998-2019, Franz Inc. Oakland, CA., USA. All rights reserved.
The object described on this page has been modified in the 10.0 release; see the Release Notes.
Created 2019.8.20.
| Allegro CL version 10.0 Object described on page has changed in 10.0. 9.0 version | ||||||||||