Purebasic with Apollo and is anyone working on DBF access

nicksteel · Post by **nicksteel** » Fri Jan 28, 2005 1:40 am

I use the commercial version of xHarbour, which handles Clipper commands via Apollo. It is very weak with GUI.

How could I access Apollo functions through Purebasic? As Apollo functions are xbase, they fit well with my Clipper/xbase experience.

Is anyone currently developing Purebasic routines to access Dbase (DBF) files directly (without ODBC)?

blueb · Post by **blueb** » Fri Jan 28, 2005 3:22 am

nicksteel,

Apollo does work with PureBasic, if you use the their DLL's... But anyone can access the functions, if you have the code to the declarations.

Since Apollo does NOT have a test version available, access to the DLL's is only available to registered users through Apollo (Vistasoftware.com). I have started to write a PBI file in PureBasic, but have not yet finished. I lost interest when I found that Cheetah was much faster.

Remember, if a person such as myself, gave you the declares to Apollo's DLL, I would be in violation of my purchase agreement.

You can go to Cheetah's web site http://www.planetsquires.com/files/PureBasicStarter.zip) and download the PureBasic PBI file for Cheetah and test it with the demo version of Cheetah. The purchased version gives you a unique activation code to allow TOTAL use of their DLL.

hope that helps,
--blueb

nicksteel · Post by **nicksteel** » Fri Jan 28, 2005 10:20 am

Thanks, blueb.

I can see that Apollo is not the way for me to go.

I am also trying Cheetah, but am waiting for their new release before purchasing. Their demo version is very slow to test with due to all the nag screens, but the only option left to me.

Could you direct me to a sample code source for Purebasic/Cheetah? I wish to build a scrolling window with multiple horizonal fields with add, insert, delete records.
Thanks again.

blueb · Post by **blueb** » Fri Jan 28, 2005 4:19 pm

The Zip file above contains about 15 examples from myself and Stefan (see the PBI file).

Sounds to me as if a good grid might be what you are looking for.

Check out: http://www.softwareinnovators.com/produ ... &PD=SIGRID

It works with Apollo, Cheetah, Tsunami and many other databases and it includes PBI source file for PureBasic (and others).

--blueb

nicksteel · Post by **nicksteel** » Sat Jan 29, 2005 3:57 pm

blueb wrote: Check out: http://www.softwareinnovators.com/products.php?
--blueb

Will try. I'm also having some positive results with xHarbour/Minigui. It handles DBF files within complete xbase command structures and is relatively easy to use for an exClipper type. (Minigui is free and runs with the free version of xHarbour and free Borland C++.)

I still would rather go Purebasic, so will pursue both. The upcoming release of Cheetah will probably be my best bet, but it may be awhile before it becomes available. I am awaiting the next release to avoid having to buy it two times (personal version). Purebasic with xbase in Cheetah would be faster and both systems have a large support group.

Thanks

blueb · Post by **blueb** » Sun Jan 30, 2005 5:46 pm

I am awaiting the next release to avoid having to buy it two times (personal version).

I would not wait for the new version, which I expect won't be ready until this summer. Paul Squires is very reasonable with his updates (I have three of his products and he has updated ALL for free).

Regrds,
--blueb

the.weavster · Post by **the.weavster** » Sun Jan 30, 2005 9:21 pm

You could buy Clarion 6 http://www.softvelocity.com

It's brilliant and if you've got a commercial version of xHarbour they may give you a competitors upgrade price. Try e-mailing sales and asking.

It has native drivers for dBase iii, dBase iV, dBase V, FoxPro 2.6, Clipper, it's own TopSpeed format, ODBC, MS SQL, Oracle, + more

It also has an application generator wizard that handles alot of creating browse forms, input forms and basic reports for you. You just need to do a bit of fine tuning afterwards.

If you define relationships between tables referential integrity is automatically generated as part of your application even if you're using a dumb back-end like dBase.

The app generator will also use the relationships you have defined to create selection lists in the auto generated forms. It just saves so much work.

You can embed Clarion language code or c++ code and you end up with a compiled executable that you can distribute royalty free.

What more could a database programmer ask for?

Weave

nicksteel · Post by **nicksteel** » Mon Jan 31, 2005 2:20 am

blueb wrote:
I am awaiting the next release to avoid having to buy it two times (personal version).
I would not wait for the new version, which I expect won't be ready until this summer. Paul Squires is very reasonable with his updates (I have three of his products and he has updated ALL for free).

Regrds,
--blueb

Is there a source containing a small sample Purebasic/Cheetah application that does not display to debug or console, but something that actually looks like an application? Like with a simple menu and browse screen.

I've looked at PureBasicStarter and Cheetah2PureBASIC.

menschmarkus · Post by **menschmarkus** » Wed Mar 16, 2016 9:19 pm

Hi guys,

would like to revive these posts. I am working on Apollo by myself in the moment and would like to share my experience.

nicksteel wrote: How could I access Apollo functions through Purebasic? As Apollo functions are xbase, they fit well with my Clipper/xbase experience.

That is really simple. You just need to directly call the functions from Apollo DLL. Open Apollo DLL with OpenLibrary() and you directly have access with callfunction() or callfunctionfast()
Within the installation directory structure you will find something like a header file which was written for PowerBasic. This is easy to convert to PureBasic. After you have done this you just need to follow the manual for the different commands. Keep in mind that by using this DLLs directly the standard Query is not usable any longer. You have to change it to the direct commands!

Now a question from my side to someone who may know it.
How can I connect a client to a runing Apollo Server? Due to the fact you do not use any PB Database command I have no idea how to connect to the dedicated IP address and port.

Thanks you for help