XBSQL: An SQL wrapper for the XBase DBMS library

6. Supported SQL

Currently, XBSQL supports the following:

select e1, ... from t1, where c1 ... order by o1, ...

insert into t values (e1, ...)

insert into t (c1, ...) values (e1, ...)

update t set c1 = e1, ... where c1, ...

delete from t where c1, ...

create table t (colspec, ...)

drop table t

Expressions e1 are currently fairly limited, just some basic arithmetic and string concatenations, plus equality.

Available column types for create column specifications are:

int

double

char

blob

XBase files all contain fixed-width columns, with the exception of the blob type, which maps to a memo column. The first three cases can therefore have (width) appended. Individual columns can be indexed, for example, (...., ident int(10) index, ...).

Unsupported SQL includes

sub-selects

select .... into

create .... as

alter table ...

aggregate functions (including count(*))

group by and having

inner, etc., joins