Macro's and stored procedures

[allyne]

I have a macro that opens a stored procedure in SQL 7.0 which executes a delete statement and an append statement. Once this is completed I need to have the macro open a form. The problem is when I run the macro I get the following error message:

"The stored procedure executed successfully but did not return records." Action failed.

Is there a way to run the stored procedure without getting this error message and then open the form. I tried to turn off the error messages with echo. This does not show the error message but it also doesn't open the form.

Thanks for you help
Cathy

 

[ghubbell]

Hi Cathy,
You'll do yourself a great favor to select the macro from the database window, right-click and then save as (a name) and as...module.

Now refer to this new module instead...you will be able to do exactly the same as before but with more flexibility and...error handling. You will be able to stop the code in action to pinpoint a problem and more. I guarantee you, you will never look back. Gord
ghubbell@total.net

 

[allyne]

Thanks! I'll give it a try.

Cathy