Table events do not trigger

Questions and answers regarding general SQL and backend databases

Table events do not trigger

Postby birgit » Tue Dec 13, 2011 8:34 pm

Hi

My table events (onRecordDelete and afterRecordDelete) do no longer trigger. Any idea?
I'm using Servoy 5.2.11 on Mac OS X 10.7.2 with SQLAnywhere12 database.

Thanks and regards
Birgit Rieder
7r gmbh, Switzerland
SAN Developer
User avatar
birgit
 
Posts: 302
Joined: Sun Jan 15, 2006 10:04 pm
Location: Switzerland

Re: Table events do not trigger

Postby Hans Nieuwenhuis » Tue Dec 13, 2011 10:07 pm

Did You try to remove your .servoy directory
(I had this problem once and removing .servoy solved the issue)

Regards,
Hans Nieuwenhuis
Betagraphics
http://www.deltics.nl
http://www.betagraphics.nl

Servoy Version 7.3.1
Java version 1.7.0.x
Database Oracle 11g
User avatar
Hans Nieuwenhuis
 
Posts: 1026
Joined: Thu Apr 12, 2007 12:36 pm
Location: Hengelo, The Netherlands

Re: Table events do not trigger

Postby birgit » Tue Dec 13, 2011 10:42 pm

Hi

Thank you for answering. I checked the (hidden) .servoy file but now, there is none.
Any other ideas?

Kind regards
Birgit Rieder
7r gmbh, Switzerland
SAN Developer
User avatar
birgit
 
Posts: 302
Joined: Sun Jan 15, 2006 10:04 pm
Location: Switzerland

Re: Table events do not trigger

Postby jcompagner » Tue Dec 13, 2011 10:44 pm

a smart client always has a .servoy dir in your user home dir.

But does this happen on multiply client installs?
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8833
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Table events do not trigger

Postby Hans Nieuwenhuis » Tue Dec 13, 2011 10:52 pm

We also had this problem once after replacing one of the servoy modules on our production server.
To repair this we reinstalled all modules and the flushed all modules.

Maybe a flush would have been enough then....

Don't know on what version we where then, I gues it was an early 5.2.x release

Regards,
Hans Nieuwenhuis
Betagraphics
http://www.deltics.nl
http://www.betagraphics.nl

Servoy Version 7.3.1
Java version 1.7.0.x
Database Oracle 11g
User avatar
Hans Nieuwenhuis
 
Posts: 1026
Joined: Thu Apr 12, 2007 12:36 pm
Location: Hengelo, The Netherlands

Re: Table events do not trigger

Postby birgit » Tue Dec 13, 2011 10:55 pm

Actually, I just found, only afterDeleteRecord does not trigger.
Birgit Rieder
7r gmbh, Switzerland
SAN Developer
User avatar
birgit
 
Posts: 302
Joined: Sun Jan 15, 2006 10:04 pm
Location: Switzerland

Re: Table events do not trigger

Postby birgit » Thu Dec 15, 2011 1:56 pm

Will the .servoy directory be created when launching Smart Client (not from within developer)? I did not yet. Since last deletion of the directory, I only started the app from within developer.

Does anybody use an afterRecordDelete event and can confirm it is being triggered?

Thanks for help and regards
Birgit Rieder
7r gmbh, Switzerland
SAN Developer
User avatar
birgit
 
Posts: 302
Joined: Sun Jan 15, 2006 10:04 pm
Location: Switzerland

Re: Table events do not trigger

Postby jcompagner » Fri Dec 16, 2011 1:04 pm

.servoy file is purely there for the real smart client, a client in the developer doesnt work or use that at all.

But you also have this in the developer? So if you create a simple soluton with 1 form on a table and on that table you have the various table events where you print out that it is called
and you insert or update stuff in that table not everything is called?
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8833
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Table events do not trigger

Postby birgit » Thu Dec 22, 2011 12:54 pm

Hi

The problem was on my side, sorry.
See http://www.servoy.com/forum/viewtopic.php?f=22&t=17409 for details.

Thanks and regards
Birgit Rieder
7r gmbh, Switzerland
SAN Developer
User avatar
birgit
 
Posts: 302
Joined: Sun Jan 15, 2006 10:04 pm
Location: Switzerland


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 25 guests

cron