Urgent - had to force quit Servoy Developer

Classic Servoy
1

Hi - I created a one line script that when executed presented the error "error while executing method with name Go, id 1737. I clicked OK but after 10 minutes of clicking back and forth found no way to exit other than forcing a quit of servoy.

Is there really no other way to exit a failed script than to force quit? As a new developer I’m sure I’ll run into this again.

Running on Windows 2000 serv pack 4, most recent BETA version of servoy developer.

PLEASE NOTE: by force quitting, what kind of corruption might have occurred either in the application itself or in the solution (I’m told corruption is impossible for the solution - really?)?

Thanks.

2

If you get stuck on what reason whatso-ever (wrong looping etc..) try to use the ESC-key, push it a few times and the method is stopped.
As far as I know, this is only working in developer.

Has helped me a few times!

3

thank you - but escape did nothing.

4

I would really appreciate a response - I’m in the middle of developing and this issue and fear of it happening again has halted my work.

I pressed the escape key many times and it did nothing.

BACKGROUND
The script was just this 1 line:

forms.detail.controller.showRecords(servoy_to_servoy);

I set a field in a portal to, “on focus gained” execute this script. Upon execution I got caught in the loop and had to force quit.

5

The escape key wil stop executing the current script, however IF you write events that keep triggering each other that won’t be of much help. As always: be carefull when using Events. If you make them recursive a force quit will be your only option. The good news is that it is impossible to corrupt your repository with Servoy so you don’t have to worry about force quitting.

6

Thanks Jan.

  1. Since the repository is a Firebird database, does this mean that a Firebird database is completely uncorruptable - even if you pull the power cord on it several times a day, etc.? The table structure won’t be affected? Of does Servoy do something to rebuild damaged tables?

  2. Does this also mean that if I force quit, my DATA tables are also completely free from corruption?

  3. could you pls tell me how to go to a related record from a portal? I want to click on a record in a portal and through a self join go to that record. That’s what I was trying to do.

Thanks very much.

7

about 3:
you have a portal with records and you want to show the selected record in the portal in it’s own form? Is that what you are trying to do?

Because a lockup on such a simple script shouldn’t happen..
Can you send me a sample solution?

8

Thank you. Before I force-quited I stopped the Firebird service to see if that would get me out of Servoy. And after I had to force quit I kept getting errors in the solution - was told the table wasn’t there. So I chose to trash the solution as it seemed there was some corruption (caused by my stopping Firebird while it was connected, right? that’s why I’m not completely convinced this is corruption-free). I’ve since deleted all *.gdb files except emtpy.gdb and deleted my servoy.properties file as was told to do by Jan so I could start over. So the solution isn’t here anymore. I’m sorry I didn’t save and send to you.

But please do answer my questions:

  1. Does this also mean that if I force quit, my DATA tables are also completely free from corruption?

  2. could you pls tell me how to go to a related record from a portal? I want to click on a record in a portal and through a self join go to that record.

Thank you.

9

2> of course if the file (gdb) get’s corrupted somhow because firebird itself crashes or something when it was writing to it. Then it can go wrong of course.
What we mean is that when you force quite servoy it will not harm the database. Youre data will stil be consistant (so now half updates portions of the solution)

3> you do it ok with that method you showed us
What i do is place a buttong in the portal. And when pressing that button load the portals foundset in the other detail form. (like you do above)

10

OK, thanks so much!