Biferno 1.7 Tabasoft.it

Application: ItaliaScuola Back-Office3
Reference
Admin | Edit | Reference | Cache | Logs
Click on a class name to see the description of that particular class:

Predefined Classes

ansi
array
biferno
boolean
cacheItem
char
classInfo
client
collection
curApp
curFile
curScript
db
double
error
file
folder
header
httpPage
imageUtils
int
long
memberInfo
multipart
object
ref
regexp
request
search
serverInfo
smtp
stackItem
string
time
unix
unsigned
 

Application Classes

Banner
BrowserBar
Ctrl_Form
FCKeditor
Form
GridChartGraph
Histogram
LocalDate
Result
condb
cookie
folderExt
headerExt
httpExt
mysqlFulltext
objHtml
requestExt
tableExport
utils
 

Functions

Functions

db

Method:

Exec

int Exec(string sql_statement, int mode=defaultMode, int rowSetSize=1, boolean freeCursor)

Description:

Sends to the DBMS the sql query contained in the sql_statement parameter.

Parameters:
sql_statement

The string containing the sql statement to execute. Parts of the string must be escaped (with method.db.Escape method) if contain single quote character ("'").

mode

The type of cursor result of the operation. Possible types are: db.dynamicMode: the cursor is dynamic, data is retrieved from the DBMS in multiple requests db.staticMode: the cursor is static, data is retrieved from the DBMS in a single request db.defaultMode: best mode is choosen by the driver

rowSetSize

The number of rows requested at every Fetch in order to cache records returned by the DBMS

freeCursor

If this parameter is set to true, the cursor is disposed before returning from Exec

Returns:

A cursor id to use in subsequent calls of db class

Notes:

For DBMSs that require prepares, Biferno prepares the query internally

Errors:

When the generic error error.db.ErrDBMSError is returned the real error is contained in the property.error.subErr and property.error.subErrDescr properties of global err error.db.ErrBadCursorMode is returned if an invalid cursor mode is passed to the function

See also:

method.db.Escape

Implementation:
C
 

Return to the db class