Your post makes me think Thierry Nivelet will chime in about FoxInCloud.
On 2014-05-27 13:36, Rafael Copquin wrote:
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.
