Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Having a user fire a job from a button.
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00808933
Message ID:
00808937
Vues:
22
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform