Judith Barer wrote:
> I have never done any web programming or created a web servcie. I
> have developed a VFP 8.0 app that runs in house. Our company also
> has a web site that was developed by an outside consultant who still
> maintains the site for us. Right now once a month I perform a series
> of queries on our VFP tables and we FTP the tables to the web site.
> When we FTp the tables we actually overwrite the live data tables
> that are being used on the web site. Until now this was good enough
> even though the data was not up to the minute. Now we would like to
> have our web site reflect the most current data. The first thought
> was to upload the data every night. This runs into complications like
> I don't really like the idea of overwriting live data and the data
> should really be uploaded to a temp directory and then have the web
> site down momentarily for processing and then the tables should be
> overwritten. The consultants said that that is very difficult to
> program. Is that true? Anyway I know this is definitely not the best
> way to do this but I am the only programmer in my office and they do
> not want to spend a lot of money on this project.
>
> My other thought is that maybe a better way to do this would be to
> create a web service. If I created a web service to provide the
> above info , would the web site then be able to be programmed to
> access the data via this web site. Is this very complicated (since I
> really don't know much about it) on my end and on the web site end?
> The data itself is basically a list of companies that we certify as
> kosher and what products they produce.
>
> Thanks for any opinions about the simplest way to get this
> accomplished.
First I'd get out of DBF's on a website and go with a server based data
store (RDBMS) like MySQL.
Second I question why you have to blast out data. Why not insert into those
tables in your new environment and then delete what needs to be removed.
Stephen Russell
S.R. & Associates
Memphis, TN 38115
Nothing but a deficit grows under a Bush.
901.246-0159
©2004 Stephen the Cook |
