Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Correct way to call DBC stored procedure
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00523854
Message ID:
00524275
Vues:
20
This message has been marked as a message which has helped to the initial question of the thread.
Nadya,

When multiple DBCs are opened and have a stored procedure with the same name the CURRENT database's (SET DATABASE TO) stored procedure is executed. If no database is set as current.

If no database is set to current if you open a table in each database without issuing SET DATABASE TO. Both databases are opened but neither are set as the current. In this case, the database opened lasted will execute the stored procedure.

As far as your default values are concerned. They are only used if you don't supply a value. So in your case, updating the cursor's primary key then issuing a TABLEUPDATE() will override the default value procedure from being executed.

Will
Heavy Metal Pedal - click with care
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform