tip on "bogus" frm-42100
lakeJul 14 2007 — edited Jul 16 2007I've had this happen to me a couple times. As soon as a form
starts if you have an on error trigger that does display_error, you
get frm-42100. So it appears like a bogus error, as if the on-error trigger
were fired when there was no error. If you try to avoid displaying the
error_code 42100 that doesn't work either. In my case I found that
what actually happened was there was an error in the when-new-forms-instance
trigger. This occurred because some code in there tried to set an
item that was query only before enter-query mode. I think that the error code
is apparently lost before the on-error trigger fires. Or something. Anyway
I thought I'd mention it that if someone was plagued by this check out the
form level triggers.
Personally I am really having problems with things like this. As another example:
"FRM-30113: Block must have non-query-only database item. Cause: A block that allows updating and inserting must have at least one item derived from the database. Action: Create a derived item in the block."
What on earth does that mean? What is a "derived item"? I had huge problems
with this error and the actual cause was in the block the dml data target type
was set (by default by forms). Apparently that isn't acceptable with a query only block. What I'm wondering is if there is a third party
tool that makes forms development easier?