🚀 go-pugleaf

On Fri, 17 Sep 1999 12:29:43 GMT, tonylees@datarev.udashnet.com (Tony
Lees) wrote:

>mrocciNOSPAM@tin.it (Marco Rocci) wrote:
>
>>
>>Anyway... good luck... I don't know of anyone that succeeded in this
>>task... but I think it *is* possible.
>>
>
>Thank you for your considered reply.  We certainly don't want to get
>involved with creating non-standard approaches, or doing something
>that no-one has ever done before.
>
>It seems that we probably will be best adopting an SQL/Client-Server
>approach using Interbase and tackle the issue of other databases when
>the situation arises.  
>
>Do you have any feel for how comprehensive LOCALSQL is?  For instance,
>if Paradox was used, will LOCALSQL place limitations on what can be
>done - or are all the "normal" database functions catered for?

LocalSQL covers most of the "normal" database functions.  A complete
list of unsupported SQL language elements can be found in LocalSQL.hlp
(if you have the updated help file).

I'd say that the most useful thing missing is the ability to create
and mantain constraint via SQL.  Be aware that you *can* have
constraints on the Paradox table (appropriate level)... you just can't
create tables with CHECKs and FOREIGN KEYs by using a TQuery.

I have to say that I don't create or restructure dbs by using Delphi
apps anyway... so I can live without it.

Your real issue is speed.  To have Paradox scream on a LAN you might
have to use TTables and indices instead of TQueries.

If you go the InterBase way... you can easily scale down to Local
InterBase Server.  You can deploy that for 20$-60$ per seat (depending
on how many you intend to deploy).  It's fully compatible with the
InterBase Server (the gdb files can be copied and opened by both).
Administration is easy.  It might be a bit slower than Paradox on a
single user PC, but it really means you have to add
*not*a*single*line*of*code* to make it work on both.

Regards,

--
Marco Rocci
MicroEra srl
Turin, Italy
-----------------
vota contro lo SPAM su: http://www.politik-digital.de/spam/