Public (software) Library Copyright 1994 Nelson Ford, PsL ALL RIGHTS RESERVED =====Visual Basic Database Routines Also see VB_CTRLS for custom controls and GENERAL for controls, routines and tools which can be used by VB and other languages. -----DATABASE [DBPRN] Access Database Table Structure Printer (Charles Gallo; $0) is a sample access database browser. Prints only. Requires VB3. [ADR] Adr (Anderson, Tim; $0) contains code for a simple address book. It demonstrates how to access, update, and maintain a dBASE IV table, complete with a routine to "pack" the database. [BTCREAT] Btcreate (Highsmith, J.; $0) is sample source for the use of Btrieve Create in VB. Requires the Btrieve for Windows DLL. [BTRTEST] BtrTest (Meyer, David; $0) is source code for a Btrieve for Windows sample program. [CALLBT] CallBT (Kubelka, Bob; $0) contains a function which simplifies using Btrieve with Visual Basic. Requires Btrieve for Windows. [CHARLIE] Charlie 2.5 (Monte Carlo Software; $10) allows you to manage the data-dictionary of an access database, as it's used by the engine delivered with VB 3.0. You can use this to create databases, compress, and repair them. You can delete, add, and change tables, and query definitions, fields, indexes and relations between tables. You can also change the type and size of a field and print a professional overview of your DataDictionary. [DATATBL] DataTable Custom Control 1.1 (Bebber, Douglas; $50) is a tool for building multi-user, network-compatible database management applications. It provides an easy-to-use interface to Borland's Paradox Engine. [DATAWORK] DataWorks is an xBase power user's tool to be used by developers building applications with VXBASE for Visual Basic. [DBDOC] DBDocumentor 1.1 (John L. Dilley; $6) prints formatted definitions of the tables in your Microsoft Access or VB3 databases. [DDFDOC] DDFDoc (Sunil, reg. fee: $0) is everything you need to create DDF files for your Btrieve file using either VB3 or MS ACCESS. [FLDPAK] FieldPack 1.2 (Software Source, reg. fee: $39) is a set of three useful data management add-ons to VB/Windows. SuperString Tools packs mixed data formats into any database. For example, records can contain different-sized arrays. Delimited Substring Tools are PICK/OS-like functions for hierarchical data management with variable-length fields. Utility String Tools features justification, conversion, filters, and more. [FOXADR] FoxAdr (Tim Anderson; $0) is a simple address book that demonstrates how to access, update, and maintain FoxPro tables, complete with a routine to pack the database. Requires Visual Basic 3.0 and VBRUN300. [OLE_GJF] OLE (George J. Febish; $0) contains sample code for OLE 2.0 with a working Edit menu. It also has documentation on OLE 2.0 Automation, VBA, and much more. [OLEDEMO] OLE Demo contains VB functions to allow saving OLE2 objects to database fields. Objects may be written and read in Access 1.x OLE storage format or OLE2 storage format. Includes a DLL for speedy calculation of Access checksum byte. Requires VB 3.0 Professional. (Michael Kosten, reg. fee: $0) [DBTBL1] Paradox Database Table Viewer is a demo VB project demonstrating how to create an editable Paradox database table viewer using the DBEngine (ver 3.0 - release 5) VBX and the DBT Grid 1.0 VBX. The table viewer works with Paradox database tables (3.5 & 4.0) and supports multi-user, network concurent edit operations using record locking. (reg. fee: $?) [PDOXED] Paradox Engine Demo (Jaster, John) contains a DLL and source code for a simple demonstration of the Paradox engine. [PDXBRO] PdxBro (Kesler, John; $0) is VB source code and the executable for a Paradox table browser. It requires the Paradox engine PXENGWIN.DLL. [PROFIT] Profit Chef Source Code is the source code for Profit Chef as an example of accessing Btrieve file. Profit Chef is designed to insure that the products that a deli or restaurant sells are profitable. Requires VB3.0 Pro and wbtrcall.dll from Novell. (Keith Milligan, reg. fee: $25) [PXCREAT] PXCreate (Nech, Jim; $0) provides a way to use the Paradox Engine to create Paradox tables in Visual Basic. Source Code is included, and VBRUN is required. [SNDDEX] SNDDEX.VBX 3.0 (Weimar Software, reg. fee: $18) is a VB custom control for doing "sounds like" word matching. A standard soundex matching and an enhanced soundex matching version are both included. [SOUNDX] Soundex and Metaphone Control (Mabry Software, reg. fee: $10) is a VB custom control that gives your program Soundex, Extended Soundex, and Metaphone information. These algorithms translate words (names) into codes that can be used to look up like-sounding words. [SQLQRY] SQL Query is an upgrade of the Query VB program in MS's VB SQL Server DLL kit (required to run this file). It improves the handling of returned rows. [SQLGRID] SQLGrid (Hyland, Bob; $0) shows how to use a GRID control with the VBQSL SQL Server (from Microsoft). [SUBFRM] SubFrm (Courtesy User Friendly, Inc.; $0) is an example of using an array of data control to simulate the subform capability of Access in VB3. [VB_DC] VB Data Companion 1.1c is a MS Access Data Dictionary tool, as well as an SQL Query By Example tool. (MM Technology, reg. fee: $34) [VBDB] VBDB is a set of forms and code for a dBase engine. A lot of coding has gone into it. The sample application is about 85% complete; the engine is completely done. [VB_ISAM] VB_ISAM (Eibl, Gunter; $0) contains the source code for an ISAM-emulation, using the rules of Basic PDS 7.1. The emulation needs the Btrieve DLL. An an example is included to see how to use Btrieve from Visual Basic. [VBMSDN] Vbmsdn contains a sample application of a custom database. The SQL statement is included. [VBPXENG] VB-Paradox Engine Interface (Dooley, Sharon F.; $0) is a set of declarations that create an interface to the Paradox Engine. It will translate between VB and Paradox data types. [VXBASE_1, VXBASE_2] vxBase 3.07 (Terry Orletsky, reg. fee: $65.00) contains a DLL and sample files for creating dBASE compatible applications. Features include up to eight active browse windows, large indexing buffer, memo functions, multi-user options, and much more. [VXBASST] vxBase Assistant 1.0 (Tim Purcell; $15) - lists all commands and functions available in the vxBase DLL and will paste them into your application as you work. Requires VBRUN200 and vxBase. [WINBTRV] WinBtrv (Novell; $0) is a DLL to allow using Btrieve in VB applications. [XQLMVB] XQLM Declarations are the VB declarations for working with Novell XQL. [GENTYPE] Gentypes (VB3: Database; $0) contains source code for an application to generate TYPE definitions for all tables/querydefs. It will also list the structure of your.MDB file.