NAME

DBD::XBase - DBI driver for XBase compatible database files

SYNOPSIS

    use DBI;
    my $dbh = DBI->connect("DBI:XBase:/directory/subdir")
    				or die $DBI::errstr;
    my $sth = $dbh->prepare("select MSG from test where ID != 1")
    				or die $dbh->errstr();
    $sth->execute() or die $sth->errstr();

    my @data;
    while (@data = $sth->fetchrow_array())
		{
		## further processing
		}

DESCRIPTION

DBI compliant driver for module XBase. Please refer to DBI(3) documentation for how to actually use the module. In the connect call, specify the directory for a database name. This is where the DBD::XBase will look for the tables.

The SQL commands currently supported by DBD::XBase include:

select

select fields from table [ where condition ]

Fields is a comma separated list of fields or a * for all. The where condition specifies which rows will be returned, you can compare fields and constants and stack expressions using and or or, and also use brackets. Examples:

    select * from salaries where name = "Smith"	
    select first,last from people where login = "ftp"
						or uid = 1324

delete

delete from table [ where condition ]

The where condition si the same as for select. Examples:

delete from jobs		## emties the table
delete from jobs where companyid = "ISW"

insert

insert into table [ ( fields ) ] values ( list of values )

Here fields is a comma separated list of fields to set, list of values is a list of values to assign. If the fields are not specified, the fields in the natural order in the table are set. Example:

insert into accounts (login, uid) values ("guest", 65534)

update

    update table set field = new value [ , set more fields ]
					[ where condition ]

Example:

update table set uid = 65534 where login = "guest"

create table

create table table name ( columns specification )

Columns specification is a comma separated list of column names and types. Example:

create table rooms ( roomid int, category int, balcony boolean)

VERSION

0.058

AUTHOR

(c) Jan Pazdziora, adelton@fi.muni.cz

SEE ALSO

perl(1), DBI(3), XBase(3)