Read records from the internet through VFP

[VFP]

I want to build an application in VFP and run it on computer cleint, the
cleint should be able to read information stored in internet server.

What is the easiest way to do it ?

Thanks in advance.

[Jan Bucek]

Post by VFP
I want to build an application in VFP and run it on computer cleint, the
cleint should be able to read information stored in internet server.
What is the easiest way to do it ?
Thanks in advance.

Does it help?

DECLARE INTEGER URLDownloadToFile IN urlmon INTEGER, STRING, STRING,
INTEGER, INTEGER

URLDownloadToFile(0, lcRemoteFile, lcLocalFile, 0,0)

[VFP]

Jan,

This function is Gr8 for downloading files from the internet, i check on it
and you can find example on how to use it on
http://www.news2news.com/vfp/?example=175&function=268.

But that not what i am asking for, if the database is big let us sau 20 MB,
you will have to download it to the local machine and then use it, which is
not practical since the database will change daily.

what i want exactly is to read a records from DBF file exist on internet
server based on Query and then show this information to the cleint.

Thanks for your help.

Post by Jan Bucek

Post by VFP
I want to build an application in VFP and run it on computer cleint, the
cleint should be able to read information stored in internet server.
What is the easiest way to do it ?
Thanks in advance.

Does it help?
DECLARE INTEGER URLDownloadToFile IN urlmon INTEGER, STRING, STRING,
INTEGER, INTEGER
URLDownloadToFile(0, lcRemoteFile, lcLocalFile, 0,0)

[Josh Assing]

use a MTDLL on the webserver side -- have it do the query and return the result.

Or -- better, use sql server...

Post by VFP
Jan,
This function is Gr8 for downloading files from the internet, i check on it
and you can find example on how to use it on
http://www.news2news.com/vfp/?example=175&function=268.
But that not what i am asking for, if the database is big let us sau 20 MB,
you will have to download it to the local machine and then use it, which is
not practical since the database will change daily.
what i want exactly is to read a records from DBF file exist on internet
server based on Query and then show this information to the cleint.
Thanks for your help.

Post by Jan Bucek

Post by VFP
I want to build an application in VFP and run it on computer cleint, the
cleint should be able to read information stored in internet server.
What is the easiest way to do it ?
Thanks in advance.

Does it help?
DECLARE INTEGER URLDownloadToFile IN urlmon INTEGER, STRING, STRING,
INTEGER, INTEGER
URLDownloadToFile(0, lcRemoteFile, lcLocalFile, 0,0)

--- AntiSpam/harvest ---
Remove X's to send email to me.

[Jochen Kirstaetter]

Hi,

Post by VFP
I want to build an application in VFP and run it on computer cleint,
the cleint should be able to read information stored in internet
server.
What is the easiest way to do it ?

Take one of the Web server extension written in Visual FoxPro and use it
on your server. I assume that the key to success is a script language on
the web server responses to your requests and provides the information
as XML stream.

So, there are a couple of VFP-based products you might examine:

ActiveVFP
Active FoxPro Pages (AFP)
FoxWeb
Web Connection

Or, as suggested by another reader use may use the HTTP & XML
capabilities of Microsoft SQL Server.

Personally I prefer the script solution due to higher flexibility and
functionality.


Kind regards, JoKi