I have a simple application with one menu and two forms. The app runs on the development machine but, on the delivery system I get a database error message when I access a form which does a simple search. The development and delivery systems are almost identical (SUSE 13.2, MariaDB, Firefox browser) so I’m almost sure the problem is mine. But, how do I find out what the real error is ? The actual message in the app is “Error while accessing the database”. Clicking the View SQL link shows nothing at all.
As the delivery system is physically different I ran the deployment tool to check the database connection and it was happy with it ie the test worked and it showed my correct database name. I duplicated the database too so it is identical to the development system.
I have seen older posts which advised turning on “debug” mode. I have checked the FAQ’s and knowledge base and also gone through all of the settings I can find but I cannot find a debug mode option. Is it now deprectated?
Clearly what I need to know is what database operation (SQL probably) caused the problem. Can anyone point me in the right direction? Why didn’t the View SQL link not show me anything? Is there a debug mode and how do I switch it on?
I am only one full week into Scriptcase and I am liking it thus far. But, if debugging is this obscure, I may have to abandon it as the real world beckons…
David Goadby, North Wales.