for Visual Basic/VBA/MS Access Developers
Performance
Programmers who use the Jet database engine for serious applications soon realize
that Jet is just too big and slow to deliver the kind of performance they need. Developers often
tell us that the Jet engine is fine when writing small applications that use small data files.
But as soon as they try to write a serious application that deals with many large tables, the Jet
engine crashes! You'll never have that problem with the stable, high-performance CodeBase engine!
CodeBase gives you that extra performance by providing a highly optimized set of routines that
provide only the core functionality necessary to manipulate data files--there's no fat in the
engine to slow down critical database operations. One developer described using CodeBase as
"programming to the bare metal". Try it for yourself and you will learn
why serious database application developers always turn to CodeBase to deliver the stability and
performance they need in their applications.
Size & Compatibility
Not only is CodeBase faster than Jet, but it also has a much smaller footprint as well. The
CodeBase engine is only a fifth the size of the resources needed to run Jet! This translates into
programs that load faster and reduce the strain on system resources. Your end users will notice
the difference when programs load quickly and respond instantly to database operations.
Plus, if you need xBASE file support, the Jet engine isn't 100% xBASE compatible. Unlike CodeBase,
Jet's locking scheme isn't multi-user compatible with other xBASE programs like FoxPro, dBASE and
Clipper. And with Jet, you can't even perform a full range of xBASE tasks, such as building an
index that includes a filter—a standard database feature when you need fast performance on skips
and lookups.
These are just some of the reasons why Jet users switch to the CodeBase engine, which provides
an easy-to-use API, great performance, compact size, lots of flexibility, and 100% xBASE file
compatibility. Try it free for 30 days and find out for yourself why professional programmers
consistently choose CodeBase for their database applications.
Client/Server
Client/Server database development is quickly becoming the preferred method of sharing data
between multiple users. It provides better security and more robustness than traditional
multi-user applications. It can also improve network performance by reducing network traffic.
Plus, it is the only feasible model for developing distributed database applications on intranets
or over the Internet.
Unfortunately, the Jet engine does not include a client/server configuration to meet this
ever-growing need. Of course, you can still get client/server database capabilities if you want
to spend thousands of dollars for an additional back-end database like Oracle or SQL Server. Or
you could use CodeBase, which includes a royalty free 10 concurrent-user client/server
configuration absolutely free, in addition to a full standalone configuration. There is NO other
client/server solution anywhere that matches CodeBase's ability to give you a truly affordable
client/server solution.
CodeBase API
The CodeBase API is simple and easy to use. No super-long functions names, or hard to remember
"object.this.that().thing" syntax. Just a straight-forward interface
that makes getting started as easy as possible. And if you ever need to use a different programming
language such as C or Delphi, you'll already be 100% familiar with the CodeBase API for those
languages, because they are virtually the same! Even though the CodeBase API offers the best mix
of simplicity and performance, if you and/or your company is committed to only using
database-standard APIs, you can still take advantage of CodeBase power with
CodeBase SQL 2.0 for Windows.
Here's a simple example that show's you how easy it is to use CodeBase API from Visual Basic...
CodeBase 6: Visual Basic Example
' List the MAILING.DBF data file ordered alphabetically by last name.
Sub PrintMail()
Dim cb&, db&, fld&, tag&
Dim rc%, j%
cb = code4init() ' Initialize CodeBase
db = d4open(cb, "MAILING") ' Open MAILING.DBF
tag = d4tag(db, "LASTNAME")
Call d4tagSelect(db, tag) ' Select the 'last name' index tag
rc = d4top(db) ' Go to the top of the data file
Do While rc = r4success ' While not at the end of data file
Print d4recno(db) ' Display the record numbers
For j = 1 To d4numFields(db) ' For each field in the data file
fld = d4fieldJ(db, j)
Print f4str(fld) ' Display the contents of the field
Next j
rc = d4skip(db, 1) ' Skip to the next logical record
Loop
rc = d4close(db) ' Close the data file
End Sub
CodeBase 6 Function List
Here are just a few of the fully documented CodeBase functions:
Data File Functions
| d4append |
d4eof |
d4lockFile |
d4reccount |
d4top
|
| d4blank |
d4field |
d4lockGroup |
d4recno |
d4unlock
|
| d4bottom |
d4flush |
d4numFields |
d4record |
d4write
|
| d4close |
d4go |
d4open |
d4reindex |
d4zap
|
| d4create |
d4index |
d4pack |
d4seek |
|
| d4data |
d4lock |
d4position |
d4skip |
|
| d4delete |
d4lockAppend |
d4recall |
d4tagSelect |
|
Field Functions
| f4assign |
f4assignLong |
f4char |
f4len |
f4ptr
|
| f4assignChar |
f4assignN |
f4decimals |
f4long |
f4str
|
| f4assignDouble |
f4assignPtr |
f4double |
f4name |
f4true
|
| f4assignInt |
f4blank |
f4int |
f4ncpy |
f4type
|
Index File Functions
| i4close |
i4create |
i4open |
i4reindex |
i4tagAdd
|
Relation Functions
| relate4bottom |
relate4master |
relate4querySet |
relate4skip |
relate4top
|
Logging and Transaction Functions
| code4connect |
code4logFileName |
code4logOpenOff |
code4tranRollback |
| code4logCreate |
code4logOpen |
code4tranCommit |
code4tranStart |
If you are developing database applications in Visual Basic that require high-performance, xBASE file
compatibility, portability or royalty-free distribution, then CodeBase is the choice for you. Order
it today at no risk through our 30-day Money-Back Guarantee and
start bringing superior database functionality to all your applications.
|
