Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calling stored procedures
Message
De
03/02/1999 12:46:56
Nancy Folsom
Pixel Dust Industries
Washington, États-Unis
 
 
À
03/02/1999 12:36:05
Daniel Christensen
University of Wisconsin River Falls
River Falls, Wisconsin, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00183511
Message ID:
00183520
Vues:
17
Try this:
 SET DATABASE TO (the database with the stored procedure)
DO next_id
The trick is that the database with the stored procedure must be the current dbc. Just because a DBC is open doesn't mean it's current.

Note that when you do this from a field-level default value you don't need the SET DATABASE TO ... part.

>I am having trouble calling a stored procedure from one of my form methods. The procedure that I am trying to call returns the next available unique id for a given table. As I call the procedure I get a runtime error stating that it cannot find "next_id.prg". I have checked to make sure that the database container is actually open at the time of the call. Can anyone help me out here?
>
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform