how to override grid settings in the canupdate event

[irwincohen]

In ver 9 I used the following code in the CanUpdateRecord event to dynamically change the content above the grid. This does not work in ver 12. I can find documentation of changes to the grid settings from within the a5w page but I can not find how to do this in a grid event. The grid name is changesuperagree.

		
with tmpl_changesuperagree
	EditRegion.Grid.Top = <<%html%
	<font size="3" color=#ff0000>The start date must be before the end date.</font>%html%
end with

the xbasic tab for the grid includes:

tmpl.EditRegion.Grid.Top = <<%editregion%
%editregion%

but I can not figure out how to change it dynamically. Any help would be appreciated.
Thanks,
Irwin

[Clipper87]

Re: how to override grid settings in the canupdate event

I can't seem to find the CanUpdateRecord event in a v12 grid clients side events, the release notes since v9 don't seem to mention it either so I wonder if it ever existed ? Anything you want to change dynamically should be done using javascript, the xbasic is the code for rendering / creating the grid. So put a span & an id tag in the freeform region above your grid next use javascript in any client side event to get a pointer using getElementById to the element & replace the innerHTML.

[irwincohen]

Re: how to override grid settings in the canupdate event

Thanks Frank
The Canupdate record event is real (http://wiki.alphasoftware.com/Using+...anupdaterecord) and I used it in ver 9. It also is supported in v12 but the code I want to use does not work in v12 as it did in v9. In any case I see what you are saying and I will play with it but I was hoping I could use the same method in v12 as I did in v9 and use xbasic in the event itself.
Irwin

[mumfie]

Re: how to override grid settings in the canupdate event

Thanks Frank
The Canupdate record event is real (http://wiki.alphasoftware.com/Using+...anupdaterecord) and I used it in ver 9. It also is supported in v12 but the code I want to use does not work in v12 as it did in v9. In any case I see what you are saying and I will play with it but I was hoping I could use the same method in v12 as I did in v9 and use xbasic in the event itself.
Irwin

canupdaterecord is a grid serverside event. Not sure EditRegion.Grid.Top is accessible. You can verify with the debugger.

If you want to prevent the update and display an error you typically display the error using Result.ErrorHTML

with PageVariables
Result.Cancel = .t.
Result.ErrorHTML = "Something is wrong"
end with

You can also look at the various ClientSideEvents canGridSubmit etc

[Clipper87]

Re: how to override grid settings in the canupdate event

OK , found it : it is only available when working with DBF tables. Editing EditRegion.Grid.Top will have no effect as is is serverside; xbasic generates the grid and once that is done it's over except for ajax callbacks (=javascript calling xbasic functions that return javascript) So you definitely need to use js as I pointed out.

[Steve Workings]

Re: how to override grid settings in the canupdate event

Disagree with you Frank. This event is not specific to nor limited to DBF tables. I use it quite a bit.

Irwin - go to the grid properties, and find "Error Style". You would set the error the way you describe in this event, and then find the Error Style that suits you. I think you're looking for the Global display choice.

Correction - Colin shows the correct way to set the error message here.

[Clipper87]

Re: how to override grid settings in the canupdate event

Steve,

We are both right but it took me a while to see there's probably a bug. Create a readonly grid with NO detail view, check out server side events & see that canupdaterecord for example is not available which makes perfect sense. Add detail view & make it editable. Save the grid. See how canupdaterecord still isn't available. That's where I got confused because I first created a sql based grid w/o editable dv, next I tried with a dbf based grid with editable dv right from the start. solution is to close & reopen the grid. I will report it. Thx

[irwincohen]

Re: how to override grid settings in the canupdate event

Thank you all, I was trying to save some work porting my v9 code to v12 regarding the error message. But as Colin and Steve suggest I am going to stick with the standard error message protocol as suggested by Colin. I have to rewrite more code but it will be easier for my successor (or me too) to maintain.
Thanks for your suggestions,
Irwin

[Selwyn Rabins]

Re: how to override grid settings in the canupdate event

this has been fixed now. it is no longer necessary to exit and reopen the grid builder to see the correct list of server side events after you change the grid from r/o to r/w or vice-versa. thanks. the fix will be in the next update but is available now in the pre-release build.