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?
>