Assigning sequence values in input pane

[kctx7]

We have non-programmers using PL/SQL developer to do data input. When they enter data into the result grid, sometimes they must specify new keys from a sequence.

Is there are straightforward way to have BOTH: the new sequence is assigned automatically, AND: the newly assigned number shows up in the result grid when they POST or COMMIT their changes?

I can of course use a trigger to accomplish half of this. I would program an plug-in to accomplish this if necessary, but I'm not sure there are all the right hooks to do it.

 

[hbar]

Like maybe an option that would allow you to choose whether or not "POST" would re-query your result set? I often wish it would do that, so I could see the effects of a trigger on a table I'm manually manipulating. Just a thought.

 

[kctx7]

That's one thought we've had; I can almost program that as a plug-in. A plug-in can execute the query in a window, so all I need is to tie into the event of clicking "POST". Unfortunately I don't think I can do that. Another small problem with this approach would be that the rows might get reordered or filtered upon requerying, and seemingly disappear from the result set.

What I'd *REALLY* like would be to have sequences (or any arbitrary PL/SQL for that matter) pre-fill certain columns when you click the "+" to add a new record. Hmmmmm.

 

[Marco Kalter]

It would indeed be a useful option to requery an inserted or updated record. Both for values changed by triggers and for default values. I have added this to the list of enhancement requests.

 

[kctx7]

Would there happen to be any undocumented features in the plug-in interface that would let me know when someone clicks a button like the "+"? I've tried OnPopup and OnMainMenu: no luck...