>I would like to be able to have a user fire off a SQL job from our VFP app by pressing a button when needed. The job requires taking data from a VFP table and transforming it to SQL format and appending it to the SQL table. I have the job created, however, I am not sure how to code the VFP button to fire off the job when the user needs to have the job ran instead of myself manually starting the job from the EM. Any suggestions?
I would create an updatable remote view of the SQL table. Open the view with no data using table buffering, APPEND FROM the VFP table, then issue TABLEUPDATE(1) to send the data to the server.
Mark McCasland
Midlothian, TX USA