Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Read VFP Data
Message
General information
Forum:
ASP.NET
Category:
Databases
Title:
Environment versions
Environment:
VB 9.0
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01577552
Message ID:
01577569
Views:
74
There are other options.

Write a COM component in VFP, and instantiate it. But I'm not convinced it will be any faster.

Another option is to automate the process. When a PDF file is dropped into a folder, the .Net application picks it up and reads the data then writes it to MSMQ. A VFP application then reads the information from the queue and writes it to the dbf. Both the .Net and VFP applications would run as services so they're always running.


>That's what I'm doing now.
>
>The app reads PDF's full of invoice payment information into into VFP tables. It looks up the invoice in one table, then writes the payment data to other VFP tables.
>
>The client reported that the application took 6 hours to complete, so I need to find a way to speed it up.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform