Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Merge Remote Data Using View?
Message
From
03/09/1998 17:00:00
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00132993
Message ID:
00133011
Views:
20
Hiya Steve,

OIC...OK, it's much clearer now. Here is what I suggest: Create an ASCII file on the remote machine...transfer that (it's safer than DBF files).

On the server side the form that the user will be using to merge the data creates a standalone cursor (using CREATE CURSOR) with the same structure as the "serverdata". This table is appended to from the ASCII disk. Then, you can SCAN through the new cursor records and INSERT INTO the serverdata as each record is checked vs. business rules or other validation.

The cursor is closed, VFP deletes it automatically, and the job is done!


>Here is a scenario of my problem:
>
>A person on a remote stand-along PC does data entry using VFP and saves the VFP files on their PC. They connect via modem to a Server PC and transmit the VFP files directly into an incoming directory named "Remote" on the Server. The files are held there until an administrator or lead operator runs a form that will merge the incoming VFP files into the exisitng VFP files.
>
>Hope this clarifies what I'm trying to do. Sorry if I confused you. That makes two of us.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Reply
Map
View

Click here to load this message in the networking platform