Refresh fields after Stored Procedures and Triggers run?

Developers Programming
#1

Hi all,

I have just purchased SC and so far it looks great. I have already been able to do some cool things but of course I still am a serious newbie, to PHP too…

I have trawled the forum for this issue and I apologize in advance if I am missing the obvious: I have a fairly large amount of code (about 25,000 lines) written as Stored Procedures and Triggers in MySQL for my new SC application. This means MANY field updates happen in the database automatically. These updated values then need to be immediately visible in SC in my Forms and Grids i.e. automatically refreshed. Is there some way I can simply re-run the original ‘select and load all screen fields’ SQL whenever I need to? Some products (e.g. WaveMaker) offer a ‘Refresh record after Insert or Update’ option specifically to deal with this issue - very cool. But I can’t find anything like that in SC? (I have seen the Edition Lookup ‘refresh’ option but it looks like that only refreshes the lookup field…)

If anyone has any tips or tricks in this direction it would be greatly appreciated.

Thanks.

Zacc

#2

Re: Refresh fields after Stored Procedures and Triggers run?

after insert/update/delete the form display the fields selecting from the database, so if the database is updated, them the application will get it.

But if you want to manually refresh, you can use sc_redir to re-open the apllication itself.

sc_redir(appname);

#3

Re: Refresh fields after Stored Procedures and Triggers run?

I found that the new fields are not automatically showing on my Editable Grid Form but I’ll try the redirect command.

Thanks a lot.

#4

Re: Refresh fields after Stored Procedures and Triggers run?

SCv6 (6.00.006) does not “auto - update” fields after an update. We still need a means of programmatically auto-refreshing, and only the record the user is currently positioned at, not the whole record set, which positions the user back at the first record in the record set. Very annoying to have to re-navigate back to the record that was just updated.