Foxpro is hardly "open"
It was bought by M$ presumably to reduce competition - it seems to be
their "middle" tier DB platform/language, looking at their website
MSS "Classic" uses it (what we have in the practice)
R
Peter Machell wrote:
On 24/05/2006, at 9:35 PM, Mario Ruiz wrote:
My understanding is that one cannot compare this two.
MDW2 is not Foxpro, it's DB2. MSS Classic is the only health IT
system I'm aware of based on Foxpro.
Foxpro is an open file based DBF system (like MD2).
I object to your use of the word 'open'.
A bit of trivia, it originates from Fox Software purchased by M$
circa 1992 and pre-dates Access and MS-Sql (designed by Sybase not M
$) during the times that M$ was trying to build a database product
and customer base.
Sybase learnt from that experiment and went on to build much better
database engines like ASA.
Foxpro features a max address space of 2GB (up to 4GB in some
configs) and it does not provide real Sql features such as
replication, interleaved or nested queries, etc.
MSDE which is what many will be running MD3, Pracsoft 3 and Best
Practice on, also has a 2GB limit.
Foxpro features an inbuilt db engine intended for RAD and not meant
to be a stand alone DBMS, rather is meant to be a front end to the
real thing (MS-SQL).
No, as you said it pre-dates MSSQL. A file based database system is
fine until you try to network it. Consequently, they run particularly
well and very quickly in a terminal server environment.
In fairness to Foxpro, I understand it is fast and easy to develop
with it.
As is MSSQL, if you are trained to develop with a mouse rather than a
brain.
Peter.
_______________________________________________
Gpcg_talk mailing list
[email protected]
http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
_______________________________________________
Gpcg_talk mailing list
[email protected]
http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
