Correction of mistyped db name is not recognised

Scriptcase 9 Bugs
#1

In the form attached to db table sec_groups_apps there is a field group_id. I have added a select field “description” and an automatic evaluation with "SELECT description FROM sc_groups WHERE group_id={group_id}.
The test failed because the table name is sec_groups.

I corrected the table name and generated it afresh. It still fails and reports the error with table sc_groups!!

#2

Hello Sir,

I did some tests and wasn’t able to replicate this behavior.

What is your SC version?

#3

Dear Mr Roberto Ferraz
Thank you for responding to my post.
In the meantime I experienced a lot of frustration because of very strange behavour of scriptcase.
Finally I had to restart the whole porject afresh. An then, what a suprise, things worked as expected.

This leads me to the conclusion:

  • I had used the security modul and then disabled it again. Obviously the undo of security module is producing unexpeced results. NEVER DO TRY TO UNDO SECURITY MODULE!
  • Since then (not using the security module) I notice from time to time that an application behaved unexpectedly (e.g. complaining about clearly correct sql statement). Here again some unfinshed undoing seems to lingers. Delete the application and start afresh with the app.

Kind Regards Sawjer