BDE or SQL

rbuser

Hi,

Can I use RB 6.03 with BDE and not have to make SQL requests. LocalSQL has
to many restructions. I would like to be be able to use BDE to move thru
the records. I noticed the example programs with 6.03 use SQL statements to
retrieve data from paradox/dbase tables.

Where do I go from here?


Thanks

Dave Evans

rbuser

Hi David,

You can use standard TTable access, however using the End-User solution
relies on SQL.
If you serve your users with all necessary datamodules, no End-User solution
is necessary (but possible with BDE too!).
(btw, there is no need to move through the records by yourself, RB does it
for you :-))

LocalSQL may have some limitations (like any other SQL grammar), but using
Paradox results most the time in corrupted tables - If you have the chance
to use another database, do it (www.AdvantageDataBase.com is one of best
replacement for Pdox, I recommend that).

regards,
Chris Ueberall;

has
to

rbuser

Thanks Chris,


What do you mean by End-User solution. I'm not intending to include the
ability for end-users to adhoc reports. I'm converting 45 delphi rawprint
reports to RB 6.03, D6. these 45 reports already search to first record
needed and then step through the records until the report has finished. I
have decided to convert my most difficult report to RbB6.03, if I can
convert it, then all the remaining reports will be no problem.

Dave

rbuser

answered via private email.