I need to clarify this:
In all my new apps I use SQLServer Express as the database engine,
however some all perfectly good apps that have been operating for years
are of course based on DBF.
Some of those clients want to upgrade and include some web
functionality, but do not want to pay for the cost of migrating dbf's to
sqlserver. With SQLServer you have things like replication and even
without that you could access your server from the internet. You need
of course to enhance security, but then, if the money is there, the
thing is perfectly doable.
But they do not want to pay for the effort of converting from dbf to sql
server (MySQL or whatever). And you know that there are no REPLACE,
BROWSE, LOCATE etc in SQL Server. So you need to replace zillions of
statements to SELECT or UPDATE. Plus the fact that some VFP functions
are nonexistent in T-SQL. So you need to create new functions or even
change some of them, from VFP syntax to T-SQL syntax (INLIST comes to
mind, a statement such as "INLIST(X,1,2,3)" becomes "X IN (1,2,3)" in
T-SQL).
Again, that is a lot of work. But a client that has been using
successfully a DBF based app is very reluctant to pay for all that, just
to add "a simple web form"
So, the idea to place some DBF's in the cloud came to mind, especially
in a free site. Lots of thrifty people down here :-(
Rafael Copquin
El 27/05/2014 12:13, [email protected] escribió:
On 2014-05-27 10:22, Ted Roche wrote:
On Mon, May 26, 2014 at 11:24 AM, Rafael Copquin
<[email protected]>wrote:
I just had this idea (crazy? mmmm......)
Just upload a VFP table to one of the free cloud stores
(dropbox,cubby,google drive,one drive, etc)
And then use it, like one would use any ordinary table:
A good idea but, yeah, crazy. I don't really know all the details
involved, but smarter people than me explain that the sharing and
locking
mechanisms used with DBFs really depend on DOS/network/smb/CIFS
protocols
that understand the commands to lock or share the table and/or
lock/share
specific rows or areas of the table. Ditto for indexes. Without these
APIs
supported specifically, you're going to run into trouble.
Another reason to stop using DBFs and start using something like MySQL.
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
