Welcome to ftp.nluug.nl Current directory: /pub/os/Linux/distr/vectorlinux/Uelsk8s/GAMBAS/gambas-svn/gambas2/gb.db.sqlite2/ |
|
Contents of README:(Daniel Campos <danielcampos@netcourrier.com> ) - All float values has been replace by double values, as some extra wrong decimals were added in conversions from sql data types to Gambas data types. Uses the STL and requires the sqliteclient library. Currently tested with SQLite 2.8.13. from www.sqlite.org sqlite is typeless...although in the create you can specify type details (these are just comments!). These types have been defined to map to gambas, those not defined will default to string. Database/Gambas Type : ft_String/ GB_T_STRING DDL Value : BLOB, CHAR(, CLOB, TEXT, VARCHAR, ENUM, SET, YEAR, Non specified Database/Gambas Type : ft_Boolean/ GB_T_BOOLEAN DDL Value : CHAR, TINYINT, INT1, BOOL Database Type/Gambas : ft_Short/ GB_T_INTEGER DDL Value : SMALLINT, INT2, MEDIUMINT Database/Gambas Type : ft_LongDouble/ GB_T_FLOAT DDL Value : BIGINT, INT8 Database/Gambas Type : ft_Long/ GB_T_INTEGER DDL Value : INTEGER, INT, INT4 Database/Gambas Type : ft_Float/GB_T_FLOAT DDL Value : DECIMAL, NUMERIC, REAL, FLOAT, FLOAT8, FLOAT4 Database/Gambas Type : ft_Date/GB_T_DATE DDL Value : TIMESTAMP, DATETIME, DATE, TIME Database/Gambas Type : ft_Double/GB_T_FLOAT DDL Value : DOUBLE Thanks go to Leo Seib for his SQLiteDataset library ( sqlitedataset.sourceforge.net) which has been the base for my hacking. The order for locating database files is: 1) If database is fullpath qualified 2) If Host is specified as a valid path 3) If set, GAMBAS_SQLITE_DBHOME variable 4) Current working directory. The driver will look for databases in the current working directory unless the environment variable GAMBAS_SQLITE_DBHOME is set. There is no concept of users within sqlite. Access is controlled by file permissions on the database file. Creates database /tmp/sqlite.db by default. For the gambas-database-manager this will allow functionality. Sqlite is not case sensative on table or field names. The implementation for Gambas is. Database :memory: will load only in memory |
Name Last modified Size
Parent Directory - .svn/ 11-Jun-2009 18:08 - autom4te.cache/ 11-Jun-2009 18:08 - spec/ 11-Jun-2009 18:08 - src/ 11-Jun-2009 18:08 - AUTHORS 10-Jun-2009 20:29 0 COPYING 10-Jun-2009 20:29 18K ChangeLog 10-Jun-2009 20:29 1.7K DISABLED 10-Jun-2009 21:14 0 INSTALL 10-Jun-2009 20:29 9.1K Makefile 10-Jun-2009 21:14 20K Makefile.am 10-Jun-2009 20:29 66 Makefile.in 10-Jun-2009 20:33 20K NEWS 10-Jun-2009 20:29 0 README 10-Jun-2009 20:29 2.0K TODO 10-Jun-2009 20:29 451 acinclude.m4 10-Jun-2009 20:29 276K aclocal.m4 10-Jun-2009 20:33 32K config.guess 10-Jun-2009 20:29 44K config.h 10-Jun-2009 20:59 2.8K config.h.in 10-Jun-2009 20:33 2.5K config.log 10-Jun-2009 21:14 37K config.status 10-Jun-2009 21:14 32K config.sub 10-Jun-2009 20:29 33K configure 10-Jun-2009 20:33 711K configure.ac 10-Jun-2009 20:29 685 depcomp 10-Jun-2009 20:29 15K gambas.h 10-Jun-2009 20:29 22K gb.db.h 10-Jun-2009 20:29 7.5K gb.db.proto.h 10-Jun-2009 20:29 5.2K gb_common.h 10-Jun-2009 20:29 4.2K install-sh 10-Jun-2009 20:29 11K libtool 10-Jun-2009 21:14 216K ltmain.sh 10-Jun-2009 20:29 196K missing 10-Jun-2009 20:29 10K reconf 10-Jun-2009 20:29 121 stamp-h1 10-Jun-2009 21:14 23
NLUUG - Open Systems. Open Standards
Become a member
and get discounts on conferences and more, see the NLUUG website!