Home » Developer & Programmer » Forms » GO_BLOCK restriction in WHEN-VALIDATE-RECORD trigger
GO_BLOCK restriction in WHEN-VALIDATE-RECORD trigger [message #223958] Mon, 12 March 2007 07:25 Go to next message
eduasturias2003
Messages: 1
Registered: March 2007
Junior Member

Hello everybody,

First of all, excuse my english.

I've this situation: a form where are managed "students", for example, and It's necesary to control when a student has "classes" asociated, and if its the case, show in a window a multirecord with those classes.

To do so, i am trying this: when a student's record is changed (WHEN-VALIDATE-RECORD), i check by a SELECT if has classes, if so, i create a cursos to insert in to a multirecord_non_database_blobk those classes and then a GO_BLOCK to show the canvas associated eith that block.

Then problem is that I can't execute a GO_BLOCK in a WHEN_VALIDATE_RECORD trigger, because its restricted.

Anyone knows someway to "invalidate" that restriction, or almost, to something similar to simulate it?

Thanks in advance.
Re: GO_BLOCK restriction in WHEN-VALIDATE-RECORD trigger [message #223971 is a reply to message #223958] Mon, 12 March 2007 08:10 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you try to use the SHOW_VIEW unrestricted procedure instead of GO_BLOCK?
Re: GO_BLOCK restriction in WHEN-VALIDATE-RECORD trigger [message #223995 is a reply to message #223958] Mon, 12 March 2007 10:33 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Maybe I am oversimplifying things, but doesn't this describe a simple master-detail form?
Don't reinvent the wheel.
Re: GO_BLOCK restriction in WHEN-VALIDATE-RECORD trigger [message #224042 is a reply to message #223995] Mon, 12 March 2007 13:36 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Right; but, if it is on a different (hidden) canvas, he should *somehow* bring it to front.
Re: GO_BLOCK restriction in WHEN-VALIDATE-RECORD trigger [message #224215 is a reply to message #223958] Tue, 13 March 2007 07:16 Go to previous message
sameer_am2002
Messages: 129
Registered: September 2002
Senior Member
Its a simple Master Detail Block in which create Detail block on another canvas.Then When You query check the status of your detail block if its query then show up the canvas.
Previous Topic: problem with calling reports from Forms
Next Topic: How many records will fetch
Goto Forum:
  


Current Time: Sun Feb 02 09:44:46 CST 2025