General information
Category:
Coding, syntax & commands
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only