At 09:27 PM 22-09-00 +0000, you wrote:

>
>Howdy, all. New to this grp.
>I'm currently involved in maintaining/updating reports of a paradox
>app. Has anyone converted Pdox tbls to IB5 and continued to use the
>paradox gui as the frontend?

It is not possible to use Paradox as a front-end to any database but
Paradox and (original) DBase IV. pdox and pdxwin are integrated IDE's.

If you have full Paradox, you have several export options. There are
various ways to import data to IB.

>Notice many post related to using
>Delphi - Delphi5 is available to me - but I've not really done any
>work in it since taking a course in Delphi2.
>
>Additionally, are there any "gotchas" regarding TCursors - can they
>be used or do they need to be converted to SQL queries??

TCursor is a client-side concept. I use them extensively in Paradox
developments - it's as close as a file-server database can get to stored
procedures!

In Client/Server, you can operate on cursors (MSSQL depends heavily on
it!). The IB engine **can** operate on dataset cursors but it has superior
capability to loop through a dataset and do exactly what TCursor does in
Paradox. The "gotcha" for client/server is that you don't have access to
anything in the client application during the process. You need to pass
anything needed from the client side as input parameters before the
operation begins. In stored procs you can also nest loops as you do with
nested TCursors.

In a Delphi client, you can exactly simulate TCursor by bringing a TQuery
into memory and operating on it there. But client-side iteration through
datasets is not effective client/server practice. All data manipulation is
done under transaction control, so the logic of updating a row and then
operating on it again within the same loop is not available.

hth

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
___________________________________________________