Inherited Methods
Class: VMssqlTable
- VMssqlTable::__construct()
- Class constructor
- VMssqlTable::createFilter()
- Create a filter
- VMssqlTable::getMatches()
- Get Matches
- VMssqlTable::getPaging()
- Get paging object
- VMssqlTable::getProperties()
- Get table properties
- VMssqlTable::getRow()
- Get a row from a table
- VMssqlTable::listColumns()
- List Columns
- VMssqlTable::loadColumns()
- Load table columns
- VMssqlTable::loadData()
- Load table data
- VMssqlTable::setPaging()
- set paging object
- VMssqlTable::setProperties()
- Set table properties
- VMssqlTable::__destruct()
- Class destructor
Class: VMssqlDatabase
- VMssqlDatabase::__construct()
- Class constructor
- VMssqlDatabase::getRow()
- Get a row from a table
- VMssqlDatabase::getTable()
- Get database table
- VMssqlDatabase::listTables()
- List database tables
- VMssqlDatabase::loadAssocList()
- Get database response as associative list
- VMssqlDatabase::loadResult()
- Get database response as single data field
- VMssqlDatabase::nameQuote()
- Quote a database identifier
- VMssqlDatabase::query()
- Send database query
- VMssqlDatabase::quote()
- Quote a database value
- VMssqlDatabase::__destruct()
- Class destructor
Class: VDatabase
- VDatabase::__construct()
- Class constructor
- VDatabase::connect()
- Connect to database
- VDatabase::createQuery()
- Create Query
- VDatabase::disconnect()
- Disconnect from database
- VDatabase::drop()
- Drop database
- VDatabase::getDBType()
- Get database type
- VDatabase::getRow()
- Get a row from a table
- VDatabase::getTable()
- Get database table
- VDatabase::loadTables()
- Load tables
- VDatabase::setQuery()
- Set database query string
- VDatabase::unloadTables()
- UnLoad tables
Class: VDBI
- VDBI::__construct()
- Class constructor
- VDBI::createQuery()
- Create Query
- VDBI::createTable()
- Create Table
- VDBI::getDatabase()
- Get a database object
- VDBI::getDefaultDatabaseName()
- Get default database name
- VDBI::getInstance()
- Get instance of DBI object
- VDBI::getRow()
- Get a row from a table
- VDBI::getTable()
- Get database table
- VDBI::isError()
- Test if a value is an error
- VDBI::isWarning()
- Test if a value is a warning
- VDBI::listDatabases()
- List databases
- VDBI::listDBTypes()
- Get list of supported database types
- VDBI::listTables()
- List database tables
- VDBI::loadDatabases()
- Load databases
- VDBI::lock()
- Lock a section of code
- VDBI::nameQuote()
- Quote a database identifier
- VDBI::quote()
- Quote a database value
- VDBI::raiseError()
- Generate an error
- VDBI::raiseWarning()
- Generate a warning
- VDBI::unlock()
- UnLock a section of code
Class: VObject
- VObject::__construct()
- Class Constructor
- VObject::bind()
- Bind values to this object
- VObject::delete()
- Delete Object
- VObject::get()
- Get value
- VObject::getAll()
- Get all object values
- VObject::getError()
- Get error message
- VObject::getErrors()
- Get errors
- VObject::getMethods()
- Get object methods
- VObject::getProperties()
- Get object properties
- VObject::save()
- Save Object
- VObject::set()
- Set a value
- VObject::setError()
- Set error value
- VObject::setProperties()
- Set property values
- VObject::setProperty()
- Set property value
- VObject::toString()
- Convert object to string
- VObject::__destruct()
- Class Destructor
- VObject::__get()
- VObject::__isset()
- VObject::__set()
- VObject::__toString()
- Return object as a string
- VObject::__unset()
Class Details
Virtual Web Platform - MsSQL Table Row
This class provides the driver for MsSQL Row Access.
Tags:
- author - Ralph Ritoch <rritoch@gmail.com>
- copyright - (c) Ralph Ritoch - All Rights Reserved
- link - VNetPublishing.Com
- license - VNETLPL Limited Public License
[ Top ]
Class Variables
$fields
[line 46]
Tags:
- var - Fields
- access - public
Type: array
Overrides:
[ Top ]
Class Methods
delete
true|object True delete(
)
[line 178]
Delete row
Tags:
- return - on success, warning or error on failure
- access - public
Overrides VObject::delete() (Delete Object)
Parameters:
[ Top ]
load
true|object True load(
[mixed
$oid = null])
[line 201]
Load a row
Tags:
- return - on success, warning or error on failure
- access - public
Parameters:
- mixed $oid - Row Identifier (Primary key value)
[ Top ]
save
true|object Returns save(
)
[line 85]
Save row
Note: If the table does not have a primary key this function will fail with an error. If the columns primary key has a null value a new row will be inserted. The primary key must be an identity column or else the primary key may be filled in with a useless value.
Tags:
- return - true on success or an error on failure
- access - public
Overrides VObject::save() (Save Object)
Parameters:
[ Top ]
set
void &set(
string
$key,
$value, mixed
$val)
[line 56]
Set the value of a field
Tags:
- access - public
Overrides VObject::set() (Set a value)
Parameters:
- string $key - Field identifier
- mixed $val - Value
- $value -
[ Top ]