Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to read data from dbf over the internet
- Thread starter kosta
- Start date
I use FoxWeb, or AFP Web.
Also, there is a nice Web Server built in VFP called eeta server (sp?).
You mix html with foxcode. it is awesome.
for example:
<html>
<body>
<% && this is fox codes
Use \somedir\somefile.dbf in 0
sele somefile
locate for somerec = Somevalue
if found()
xBal = somefile.balance
Response.Write("Balance: " + Str(xBal,10,2))
else
response.write("REcord not found")
endif
use in somefile
%>
</body>
</html>
Ali Koumaiha
Wireless Toyz
Farmington Hills, Michigan
Also, there is a nice Web Server built in VFP called eeta server (sp?).
You mix html with foxcode. it is awesome.
for example:
<html>
<body>
<% && this is fox codes
Use \somedir\somefile.dbf in 0
sele somefile
locate for somerec = Somevalue
if found()
xBal = somefile.balance
Response.Write("Balance: " + Str(xBal,10,2))
else
response.write("REcord not found")
endif
use in somefile
%>
</body>
</html>
Ali Koumaiha
Wireless Toyz
Farmington Hills, Michigan
You'll need a web server utilizing the FoxPro OLE DB provider. My web server runs Windows 2000 Server and utilizes Internet Information Services (IIS) to deploy Microsoft Active Server Pages. I find this group of technology to be the easiest if you're using FoxPro as your database.
You can get a tutorial book on Active Server Pages from any bookstore. While the book probably won't tell you how to setup your web service for FoxPro, the only difference is how you define the OLE DB provider in your web application. The rest is all SQL which is standard across the board.
ToddWW
You can get a tutorial book on Active Server Pages from any bookstore. While the book probably won't tell you how to setup your web service for FoxPro, the only difference is how you define the OLE DB provider in your web application. The rest is all SQL which is standard across the board.
ToddWW
The nice part about using something like IIS with ASP and the OLE DB provider for FoxPro is that if you ever have a need to change your database say to Oracle or Microsoft SQL, all you have to do is change the provider in your web service. 99% of your SQL code written in ASP will be compatible. The only difference might be how you format your SQL strings for field types other than the standard character, numerical, logical, etc..
For that, I use procedures to generate my SQL strings so if I ever have to make a database change, the changes to the way I format my SQL strings would be minimal.
ToddWW
For that, I use procedures to generate my SQL strings so if I ever have to make a database change, the changes to the way I format my SQL strings would be minimal.
ToddWW
- Thread starter
- #5
Thanks for the replies but, i wantto use the tables from vfp application, eg. each client will be a different locations (city or building) and user will connect to the server pc via DSL connection. how was your solutions for this ?
Soykan OEZCELIK
Soykan OEZCELIK
- Status
Similar threads
- Locked
- Question
- Locked
- Question