Just finished rebuilding the install for BlitzData.
<link removed. see the RC6 thread.>
Here's a quick excerpt from the docs...
The BlitzData userlib is an ADO wrapper for Blitz+ and Blitz3D. Because it wraps COM objects I decided to use Visual Basic and vbAdvance to create the dll. Due to this, you will, in addition to the blitzdata.dll itself need to distribute the VB6sp5 runtimes with your finished app/game. ALSO, you will need to distribute the latest MDAC package which Microsoft has available for download (2.7 at the time of this document’s creation if I am not mistaken). This will increase the size of your distribution, but it will ensure that the end user has all required components.
Features
Connection and Connectionless database access (DSNless)
Quick access to Access/Jet(97/2000), MS SQL(7.0/2000), and Oracle databases
Access to any database that has an MDAC driver installed via a custom connection string
Easy database and table creation via code only
Easily return data on a column by column per-record basis
Easy navigation through records using simple forward and back commands
Return recordsets based on simple or complex T-SQL statements
Use the full T-SQL language (with databases that support it)
Transaction usage via simple begin, commit and rollback commands
Function List
BD_OpenDatabase%(Server$,Database$,UserName$,Password$,dbtype%)
BD_CloseDatabase()
BD_GetDatabaseState%()
BD_GetTableState%()
BD_FirstRecord()
BD_NextRecord()
BD_PreviousRecord()
BD_LastRecord()
BD_RecordCount%()
BD_SQLQuery%(query$)
BD_CloseQuery()
BD_GetColumn$(colname$)
BD_AddRecord()
BD_UpdateRecord()
BD_SetStringColumn(col$, val$)
BD_SetIntegerColumn(col$, val%)
BD_SetFloatColumn(col$, val#)
BD_BeginTransaction()
BD_RollbackTransaction()
BD_CommitTransaction()
BD_CreateJetDatabase(fname$,typ%)
BD_CreateJetTable(fname$,table$)
BD_AddJetColumn(fname$,table$,col$,typ%,siz%)
BD_SendSQLCommand(sql$)
The new build of the install includes a readme file telling how to install the dll and decls file for those that don't know, a few tiny (very tiny) quick and dirty little test programs that show how to use a few of the basic functions, and a constants file so you don't have to remember a bunch of cryptic numbers.
Kanati
<link removed. see the RC6 thread.>
Here's a quick excerpt from the docs...
The BlitzData userlib is an ADO wrapper for Blitz+ and Blitz3D. Because it wraps COM objects I decided to use Visual Basic and vbAdvance to create the dll. Due to this, you will, in addition to the blitzdata.dll itself need to distribute the VB6sp5 runtimes with your finished app/game. ALSO, you will need to distribute the latest MDAC package which Microsoft has available for download (2.7 at the time of this document’s creation if I am not mistaken). This will increase the size of your distribution, but it will ensure that the end user has all required components.
Features
Connection and Connectionless database access (DSNless)
Quick access to Access/Jet(97/2000), MS SQL(7.0/2000), and Oracle databases
Access to any database that has an MDAC driver installed via a custom connection string
Easy database and table creation via code only
Easily return data on a column by column per-record basis
Easy navigation through records using simple forward and back commands
Return recordsets based on simple or complex T-SQL statements
Use the full T-SQL language (with databases that support it)
Transaction usage via simple begin, commit and rollback commands
Function List
BD_OpenDatabase%(Server$,Database$,UserName$,Password$,dbtype%)
BD_CloseDatabase()
BD_GetDatabaseState%()
BD_GetTableState%()
BD_FirstRecord()
BD_NextRecord()
BD_PreviousRecord()
BD_LastRecord()
BD_RecordCount%()
BD_SQLQuery%(query$)
BD_CloseQuery()
BD_GetColumn$(colname$)
BD_AddRecord()
BD_UpdateRecord()
BD_SetStringColumn(col$, val$)
BD_SetIntegerColumn(col$, val%)
BD_SetFloatColumn(col$, val#)
BD_BeginTransaction()
BD_RollbackTransaction()
BD_CommitTransaction()
BD_CreateJetDatabase(fname$,typ%)
BD_CreateJetTable(fname$,table$)
BD_AddJetColumn(fname$,table$,col$,typ%,siz%)
BD_SendSQLCommand(sql$)
The new build of the install includes a readme file telling how to install the dll and decls file for those that don't know, a few tiny (very tiny) quick and dirty little test programs that show how to use a few of the basic functions, and a constants file so you don't have to remember a bunch of cryptic numbers.
Kanati