I’ve encountered a problem with a solution that I’ve been tinkering with some time.
The main entry form contains a tab panel accessing data from two other tables. When I swap from design into edit mode the form refuses to allow me to do any data editing at all - the appropriate commands are greyed out. Other forms view or edit the same data without problems. Duplicating the form makes no difference and deleting objects off it also makes no difference. The problem first appeared after i added a button and wrote a method to add a row to a tab.
I’ve just stepped through the user and developer guides looking for any commands that might have given me this problem but nothing stands out as being the cause. I’m even having trouble characterising what the problem is so that I can search for it in the forums. I suppose it could be corrupted - but then what do I do?
I’d appreciate any suggestions as to what the problem might be and failing that what I should do next - apart from rebuilding the form and then if that fails, rebuilding the solution from scratch.
Lee
Servoy Developer
Version R2 2.2.7-build 339
Java version 1.5.0_07-87 (Mac OS X)
MacOSX 10.4.9
If I understand you correctly, it works when you first open the solution, but not after you go in, and back out of designer.
So, going in and out of designer is actually like starting up a new client session, only your startup method doesn’t run. So, check security settings and see if there is anything preventing access on that form.
Second, turn on debugger, and check entry break. Then go in and out of designer and see what methods run. Is anything setting that form to read-only?
goldcougar:
If I understand you correctly, it works when you first open the solution, but not after you go in, and back out of designer.
Not so. It used to work then I did something. Now it never works - at startup or whenever. The solution runs no startup script. Opens this problem entry form instead, which has an onShow method with a single line```
currentcontroller.recordIndex = currentcontroller.recordIndex–;
> So, going in and out of designer is actually like starting up a new client session, only your startup method doesn't run. So, check security settings and see if there is anything preventing access on that form.
No settings that I can see make a difference. I reverted to a previous version of the solution and it does indeed work but in comparing the forms I can see no difference in settings there either.
> Second, turn on debugger, and check entry break. Then go in and out of designer and see what methods run. Is anything setting that form to read-only?
Not that I can see. Nothing explicit.
I should say more about the solution: It melds one database of membership data with data extracted from user tables in a xoops CMS database. I don't want to meddle too much with the xoops schema or else would suffer every time that codebase is updated. Unfortunately this means I keep getting error messages because Servoy reckons some tables have no primary key when in fact they do.
Also some reserved words are used to define columns in the database and I'm unable to change them for the reason just described, plus I can't nominate a pk column without correcting the reserved word. Aaarghh!
I mention these problems not only because they may be contributing to my bad experiences but also maybe someone has solutions to them too.