recordset

DBIx::Recordset is a Perl extension for DBI recordsets.

SYNOPSIS

use DBIx::Recordset;

# Setup a new object and select some recods...
*set = DBIx::Recordset -> Search ({!DataSource => dbi:Oracle:....,
!Table => users,
$where => name = ? and age > ?,
$values => [richter, 25] }) ;

# Get the values of field foo ...
print "First Records value of foo is $set[0]{foo}n" ;
print "Second Records value of foo is $set[1]{foo}n" ;
# Get the value of the field age of the current record ...
print "Age is $set{age}n" ;

# Do another select with the already created object...
$set -> Search ({name => bar}) ;

# Show the result...
print "All users with name bar:n" ;
while ($rec = $set -> Next)
{
print $rec -> {age} ;
}

# Setup another object and insert a new record
*set2 = DBIx::Recordset -> Insert ({!DataSource => dbi:Oracle:....,
!Table => users,
name => foo,
age => 25 }) ;


# Update this record (change age from 25 to 99)...
$set -> Update ({age => 99}, {name => foo}) ;

DBIx::Recordset is a perl module for abstraction and simplification of database access.

The goal is to make standard database access (select/insert/update/delete) easier to handle and independend of the underlying DBMS. Special attention is made on web applications to make it possible to handle the state-less access and to process the posted data of formfields, but DBIx::Recordset is not limited to web applications.

DBIx::Recordset uses the DBI API to access the database, so it should work with every database for which a DBD driver is available (see also DBIx::Compat).
Most public functions take a hash reference as parameter, which makes it simple to supply various different arguments to the same function. The parameter hash can also be taken from a hash containing posted formfields like those available with CGI.pm, mod_perl, HTML::Embperl and others.
Before using a recordset it is necessary to setup an object. Of course the setup step can be made with the same function call as the first database access, but it can also be handled separately.

Most functions which set up an object return a typglob. A typglob in Perl is an object which holds pointers to all datatypes with the same name. Therefore a typglob must always have a name and cant be declared with my. You can only use it as global variable or declare it with local. The trick for using a typglob is that setup functions can return a reference to an object, an array and a hash at the same time.

The object is used to access the objects methods, the array is used to access the records currently selected in the recordset and the hash is used to access the current record.

If you dont like the idea of using typglobs you can also set up the object, array and hash separately, or just set the ones you need.

Object for converting DAO or ADO recordset to the DBFfile. Allows direct output of DBF files from the ASP page. Customize Currency, Double and Single fields.

DBIx::Recordset::Playground is a Perl module with working sample usages of DBIx::Recordset.

This document serves several purposes. One, it makes it easy to get started with DBIx::Recordset. Two, it serves as a place for those experienced with recordset to examine the code to discover how to make usage of recordset even simpler. Finally, it serves as a place for me to clarify all the areas in the original docs that were a bit confusing to me.

After creating a database using DBSchema::Sample, you will be able to manipulate it using from DBIx::Recordset using the examples here. Let the games begin!

DC Binding Recordset - Few Lines to add in your Form_Load event and you will have full control over your form and all included (TextBox - Lables-Buttons-Grid-Recordset) and all related events (Leave - paint - Keypress - AfterColEdit - OnAddNew - Click - MouseEnter - MouseLeave-MouseDown-Enter).

Here are some key features of "DC Binding Recordset":

· Navigate first ,previous , next and last
· Add new records, edit it, save it, or delete it
· Retrieve related names to your fields code
· Trigger sensitive DataHelp to select from by pressing F1
· Trigger sensitive Help by pressing F12
· Validate your entry by restrict it to predefined type(Numeric-Alphabetic-AlphaNumeric-Date-Decimal) or to your defined characters
· Notify you with red forecolor if your entry is not proper
· Format data by define decimal places for numeric entry , or define letter case for charactes entry
· Change button image according to mouse movement or focus change
· Support MultiLanguage Application , by populate form labels with predefined translation automatically
· Support Eastern Language , we support right to left application by changing alignment to right and orientation by flip form horizontally 180
· Enable you navigate through controls with Return key as with tab key


Limitations:

· 30 days trial

DC Binding Recordset description
Enhanced class that handles all aspects required with a data form DC Binding Recordset - Few Lines to add in your Form_Load event and you will have full control over your form and all included (TextBox - Lables-Buttons-Grid-Recordset) and all related events (Leave - paint - Keypress - AfterColEdit - OnAddNew - Click - MouseEnter - MouseLeave-MouseDown-Enter).

Here are some key features of "DC Binding Recordset":

· Navigate first ,previous , next and last
· Add new records, edit it, save it, or delete it
· Retrieve related names to your fields code
· Trigger sensitive DataHelp to select from by pressing F1
· Trigger sensitive Help by pressing F12
· Validate your entry by restrict it to predefined type(Numeric-Alphabetic-AlphaNumeric-Date-Decimal) or to your defined characters
· Notify you with red forecolor if your entry is not proper
· Format data by define decimal places for numeric entry , or define letter case for charactes entry
· Change button image according to mouse movement or focus change
· Support MultiLanguage Application , by populate form labels with predefined translation automatically
· Support Eastern Language , we support right to left application by changing alignment to right and orientation by flip form horizontally 180
· Enable you navigate through controls with Return key as with tab key


Requirements:

· .NET Framework


Limitations:

· 30 days trial