Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calling Stored Procedures
Message
De
25/09/1997 14:27:36
 
 
À
10/09/1997 15:12:26
Michael Humphreys
Northern Airborne Technology Ltd.
Kelowna, Colombie Britannique, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00049387
Message ID:
00051634
Vues:
34
Hi Mike.

>I don't seem to be able to call a stored procedure from a method in a form. I use the SP to generate an index key and also need to call it from various methods/programs etc.

Your form is probably opening the tables through its DataEnvironment. When the tables are opened, the database they belong to isn't automatically selected, so the stored procedures aren't available. You need to SET DATABASE TO in the Init of the form. For example, I do something like this:

if set('DATABASE') <> cursorgetprop('Database',
)
set database to (cursorgetprop('Database',
))
endif

Doug
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform