Обсуждение: Can Clipper connect Postgresql

Hello

I have an old Clipper 5.1 based application.
I would like to change dbase to postgresql without
change program's businsess logic only database
connect.
Is it possible?

Joe








___________________________________________________________
ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com

At 05:27 AM 2/23/05, Mester József wrote:
>I have an old Clipper 5.1 based application.
>I would like to change dbase to postgresql without
>change program's businsess logic only database
>connect.
>Is it possible?


Maybe.

Clipper itself cannot, but you might still be able to find/get a 3rd party
package/library which provides this functionality.

You might also try looking at the Harbour Project:
         http://www.harbour-project.org/
Harbour is a free cross-platform compiler for Clipper code.  Join their
mailing list and ask your question there. I played with it a few years ago,
but I had no serious need for it.

Even if you could connect to a Postgresql database, you would still have
to rewrite a lot of code. Clipper like other xBase environments have a
slew of commands that have no analog in SQL.

Your best bet would be to port the code to run under Visual FoxPro.
FoxPro should run 95% of Clipper code w/o issue. Use ODBC to connect to
Postgresql. Then find a few strategic places to add in code to retrieve
tables into cursors (FoxPro cursors) that match the names of the
previous DBF tables. And a few places that update tables based on the
changes to the cursor.


Mester József wrote:
> Hello
>
> I have an old Clipper 5.1 based application.
> I would like to change dbase to postgresql without
> change program's businsess logic only database
> connect.
> Is it possible?