I am using Forms 10G.
I am calling a package in INSERT PROCEDURE NAME property in mu BOLCK .
In this package I have coded like if you have permission then it will insert and if no then it should not insert . And it is working fine .
But I am getting this message in both the cases .
"Transction Complete: 1 Records Applied and Saved"
What could be the problem ?
wouldn't that just be the default behaviour for forms? e.g. if you change something in the form (entered data or updated data), then it assumes you have changes to save, so it says 'transaction complete..." It does not depend on what you are doing in your procedure. as far as it's concerned, you made a change in the form, so it will attempt to commit when you commit.
the items that you are taking user input for (text items for instance), are they part of a database block? Can you move them to a control block?
If not, you might possibly be able to set the record_status to 'QUERY' with the set_record_property built in. That way the record won't be marked for insertion or update.
i don't actually know if that will work but you might give it a try.