please clarify.. so in the r>prompt you type Run CFOLOAD.RMD and it works? but
when you (click a button or what does a user do to start running the code) it
fails even though everything is the same (data and file)? what version are you
using? did you look at the data in the temp table after it is run?
----- Original Message -----
From: Ed Rivkin
To: RBASE-L Mailing List
Sent: Tuesday, May 18, 2010 10:28 AM
Subject: [RBASE-L] - Macro works from R> Prompt; fails when called from .RBA
Hi folks,
I am scratching my head on this one.
I wrote a macro (CFOLOAD.rmd) to create a table, do some calculations, and
print a report. The macro works fine when run from the R> prompt. The report
is produced with the expected results. I have also run the macro using Trace
and
found no errors except one "No Rows Exist or Satisfy Specific Clause" message
towards the end of the macro.
I added an action to my existing .RBA application to run the macro. The
Action is
Run CFOLOAD.RMD
Return
as a custom action.
The action fails. I added Set Message On and Set Error Message On to the macro
and reran it from the .RBA. It now fails with five:
"No Rows Exist or Satisfy Specific Clause (2059)
Any thoughts or suggestions would be appreciated.
Cheers,
Ed
