Information générale
Catégorie:
Codage, syntaxe et commandes
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement