🚀 go-pugleaf

In article <388d792d.0@news2.tm.net.my>,
  "xyz" <boonshyang@pd.jaring.my> wrote:
> VFoxpro or VBasic which one is better to develope database
application. At
> the moment I using the MS-Access for the creating db app.
>
> Regards,
>
> BP
>
>

VB is not a database.  It can access databases (SQL,
Oracle,MSDE,Access, VFP.....) though ODBC, ADO, RDO ,DAO or OLE DB.  If
you develop a database app in VB you still need the backend.  Visual
FoxPro is a Database application.  It uses it's own extremely fast and
versatile data engine or it can access other databases using the same
technology as VB.

You need to ask your self how much data am I storing?
How data security do I need?
How much do I want to spend?
Is this a 7/24 app?

VFP databases are wide open.  There is no built in security like in SQL
server.  VFP has not runtime distributions Costs.  There is no limit or
user count built into the product.  SQL server you must buy licenses
for each user (connection) of the database. (Building a Middletier to
access the database will cut the number of licenses need but adds other
costs).  VFP supports single tables to 2 Gig and a database container
to 2 gig.  Sql Server does not have that limit.  VFP tables need
maintenance like SQL server tables, but VFP tables cannot be accessed
while or open by anything other than the app performing maintenance
while maintenance is occuring.  Therefore, you must have scheduled down
time.

VB builds smaller apps with better integration with most ActiveX
controls.  VFP has greater data manipulation capabilities whether local
tables or another backend is used.

Hope this helps.


Sent via Deja.com http://www.deja.com/
Before you buy.