Thank you so much for your input. We have an ISP provider that administers
our web site who is trying to convince me that I could just connect to a
MySql database (not remotely, it would reside on my own local server) and it
would take about 5 hours to do and it would all work fine without making any
changes to my application. BTW my app is fairly complicated with at least
20 tables, 35 forms, and 25 reports. I would like to postpone changing the
back end of my app until we plan to incorporate other features such as a
backoffice into our app.
Right now we simply FTP tables that are the results of queries of our VFP
database to the web site and this is only done once a month. We would like
to do it every night and I would simply like the web program to overwrite
the tables once a day with new data uploaded via FTP. I know this is not the
best solution at all but we are on a limited budget and I do not want to
spend a lot of time rewriting/redesigning my existing app which works very
well for what we have to accomplish in house. I was trying to see if I
could use MySql without rewriting my app.
>That means that a VFP builder went and created the code in your GUI to :
>Use Table1 alias BlaBla in 0
>Use Table2 alias BlaBlaBla in 0
>.......
>Your probably going to find switching to remote views the easiest to do
initially, but >hard to deal with in terms of inserts, updates, deletes, as
well as P-Keys.
>SPT would have been just as tough on all the "other stuff" you would have
just had to do >the connections class and then call that for each table on
the back end.
©2005 Judith Barer |
