Using ApolloDB with Purebasic

[swhite]

Hi

I have been interested in using Apollodb because I have a number of apps using FoxPro tables so I wondered what your experience was like with Apollodb. Did you use Purebasic's Import/EndImport to define all the functions in Apollodb?

Simon

blueb wrote:
While PureBasic can be used with many database systems, personally I use:

Apollo DBMS - a dBase/FoxPro variant (single user and Client-Server versions)
I use the DLL's directly.. although they have other tools

see: http://www.apollodb.com/apollo_engine.asp

I also tinker with SQLite and PostgreSQL. Both are very easy to use with PureBasic.

The only thing I miss is VB6's data-aware controls. Any Visual Designer that would
add this to their ability would have my money NOW!

[blueb]

Hi

I have been interested in using Apollodb because I have a number of apps using FoxPro tables so I wondered what your experience was like with Apollodb. Did you use Purebasic's Import/EndImport to define all the functions in Apollodb?

Simon:

Apollo sells an 'embedded' package and a Sever add-on (if req'd):

Apollo Embedded includes everything developers need to create Windows, .NET and classic ASP applications that manage CA-Clipper and FoxPro 2.6 DBF/Xbase database files. Developers can create single and multi-user desktop and web-based database applications using Delphi, C++Builder, RAD Studio, Visual Studio (C#, VB.NET), classic Visual Basic, VBScript and C/C++ that run on Win32, .NET and classic ASP.

Although I am only interested in the actual DLL's and not the 'total' package above, I have tried COM Objects with srod's COMatePlus...
e.g.
ApolloCOM7.Database
ApolloCOM7.Table
ApolloCOM7.Query


To help with conversion to PureBasic...
Apollo packaging comes with:
- Lib files
- C++ header file
- Delphi/Pascal include file
- PowerBASIC include file (what I used)

Bottom line... very easy to convert to PureBasic, but because of licencing restrictions the headers are only for paid customers.

If all you need is a dBase/FoxPro tool, and don't need Client-Server... the free Cheetah4 DLL (Paul Squires) and the samples with header file by infratec (Bernd) is on the forum at: http://www.purebasic.fr/english/viewtop ... t=cheetah4

HTH,
blueb

[swhite]

I have looked at the Cheetah database but I needed full compatibility with existing Visual FoxPro applications. I have used Apollo in COM mode but I am very interested in just using the DLLs. I wrote a wrapper for the Advantage Local Database Server several years ago by importing the lib file so I expect I can do the same thing with ApolloDB. I certainly do not mind paying for ApolloDB since it will be used in commercial applications.

Simon

[blueb]

I have looked at the Cheetah database but I needed full compatibility with existing Visual FoxPro applications.

I haven't run into any compatibilty issues with FoxPro 2.6 files and Cheetah 4, so I can't comment.

[thanos]

Hi

I have been interested in using Apollodb because I have a number of apps using FoxPro tables so I wondered what your experience was like with Apollodb. Did you use Purebasic's Import/EndImport to define all the functions in Apollodb?

Simon

Hello.
Due to my experience it is better to convert the .dbf files to SQlite and use this database system.
Export the data in an ascii file (,csv) and import them to a SQLite database.
SQLite is very powerful, built-in in Purebasic and free.
I had too many Clipper and FoxPro applications and tried to convert them and continue using the .dbf files.
I was just loosing my time.
Regards.

Thanos

[blueb]

Makes perfect sense unless you needs Client/Server, then SQLite falls short.

[thanos]

Makes perfect sense unless you needs Client/Server, then SQLite falls short.

You can handle it with SQLitening.
http://www.sqlitening.com/support/index.php
It is really good.
Regards.

Thanos

[blueb]

I looked at it once a few years ago.

Do you have an include file for use with PureBasic?

--blueb

[thanos]

I looked at it once a few years ago.

Do you have an include file for use with PureBasic?

--blueb

No.
I had use this with VB6
Sorry.