State variables not work

[Catalin]

Hi,
I have a problem with state variables. I want to set e._state.myvar = val on OnGridExecute server side event. Debugging I can see that myvar get the value of val. When I try to retrieve the value of myvar with e.__si2.myvar (in ajax callback function) always I find the first value.

Thanks.

[Catalin]

Re: State variables not work

Any idea, please?

[Steve Workings]

Re: State variables not work

If I understand this correctly, you're trying to get something from the e object in javascript? The e object is on the server side - not the client side.

To get the value of a state variable in javascript, use other functions.

//Get the state info as a string of name value pairs
var stateData = {dialog.object}.getStateInfo();

//Read the 'myvar1' property from the state info object
var x = {dialog.object}.stateInfo['myvar1'];

//You can also set a property in the state info object directly. 
{dialog.object}.stateInfo['myvar1'] = 'alpha';

[Catalin]

Re: State variables not work

In fact the problem is the follow:

I have a grid with 2 columns "id_parent" and "name". This grid has a linking grid related by parent.id_parent = child.id_parent
Child grid execute 2 actions:
1. Edit records - (opens a dialog to edit record) - it's working good because child grid has id_parent column
2. Create new record - it's not working because I don't have the id_parent

I try to use a session variable, that I initialize it on child grid on onGridExecute server side event

if variable_exists("e.tmpl.linkDefinition") then
dim tmp as c = e.tmpl.linkDefinition
tmp = stritran(tmp, ")")
tmp = word(tmp,3,"|")
e._state.IdDevizObiect = tmp
end if

Every time that grid parent row changes initialize e._state.IdDevizObiect variable.
The child grid has a button to create the new record. When I click it I call the following javascript function to show the edit form. This function receive a parameter that override the session variable that I retrieve on edit form

window['CreazaDevizNou'] = function(objEle, IdDeviz) {

var rowNum = {grid.object}._selectedRow;
var rowId = $u.s.tran(rowNum,'-','_');


var rowNum = {grid.object}._selectedRow;
var rowId = $u.s.tran(rowNum,'-','_');

var windowName = 'WINDOW_fba3672e_b3a0_4b4b_986f_3e02a6baafc8';
var currWindow = {Grid.object}.getWindow(windowName);
var go = new Object();
go.objectId = objEle.id;
go.dialog2Name = 'deviz_reabilitare_termica_atribute';
go.type = 'dialog2';
go.alias = 'DEVIZ_REABILITARE_TERMICA_ATRIBUTE';
go.submitCurrentFieldValues = true;
go.sourceGridPart = 'G';
go.sourceGridRowNumber = rowNum;
go.workingMessage = '<img src=\'CSS/A5System/images/wait.gif\' />Asteapta...';
go.placeholderValues = '';
go.argumentBinding = '';

go._thisGridAlias = {grid.object}.gridId;
if(typeof {grid.object}.gridId != 'undefined') go._thisGridAlias = {grid.object}.gridId;
if(typeof {grid.object}.dialogId != 'undefined') {
go._thisGridAlias = {grid.object}.dialogId;
}

go._thisGridGUID = {grid.object}.componentGUID;
go._gridCurrentFilter = {grid.object}._gridFilter;

go._gridCurrentOrder = {grid.object}._gridOrder;
go._gridCurrentArguments = {grid.object}._gridArguments;
go._gridCurrentDBType = {grid.object}._gridDBType;
alert(IdDeviz);
go.overrideSettings = 'Style_name = `{Grid.style}`||Style_name = `{Grid.style}`'+'||a5SetSessionVar(`ID_DEVIZ_OBIECT`, `'+IdDeviz+'`)';
go.a5_default_path = '{grid.defaultPath}';
go.windowName = windowName;

go.showWindowParameters = '\'center\'';

if(!currWindow) {
currWindow = {Grid.object}.createWindow(windowName,'modal-resizable',
{
body: {
content: {
type: 'blank',
elementId: '~'
}
},
height: '4in',
width: '3in',
title: {
html: 'Deviz reabilitare termica<span id="DevizId"></span>',
location: 'top',
direction: 'ltr',
show: true
},
disableMove: false,
theme: '{Grid.style}',
onBeforeHide: function() {
var isDirty = window['DEVIZ_REABILITARE_TERMICA_ATRIBUTE_DlgObj']._isDirty;
if(isDirty) {
window['DEVIZ_REABILITARE_TERMICA_ATRIBUTE_DlgObj']._confirmAction();
return false;
} else return true;
},
onHide: function() {{grid.object}.refresh();}
}
);
go.dialog2Div = currWindow.getWindowId('body');
A5.component.runGenericComponent(go)
setTimeout(function() { {grid.object}.blur();},100);
currWindow.show('center');

} else {

var ele = 'DEVIZ_REABILITARE_TERMICA_ATRIBUTE.GRID_PART.FORM_CONTAINER_DIV';
var pele = $(ele);
if(pele) pele.innerHTML = '<img src=\'CSS/A5System/images/wait.gif\' /> Asteapta...';
go.dialog2Div = currWindow.getWindowId('body');
go.parentGridId = '{grid.componentname}';
go.windowPositionArg1 = 'center';
go.windowPositionArg2 = '';

A5.component.runGenericComponent(go)
currWindow.show('center');
setTimeout(function() { {grid.object}.blur();},100);
};
}

This is the callback function
function CreazaDevizNou as c (e as p)
if variable_exists("e.__si2.IdDevizObiect") then
CreazaDevizNou = "CreazaDevizNou(this, " + e.__si2.IdDevizObiect + ");"
end if
end function


On edit form on onDialogInitialize always I have the first value saved in session variable Session.ID_DEVIZ_OBIECT
if variable_exists("Session.ID_DEVIZ_OBIECT") then
e.control.IdDevizObiect = Session.ID_DEVIZ_OBIECT
end if

Is there any way to have the id_parent on edit form?

Thanks.

[Catalin]

Re: State variables not work

A picture is worth a thousand words

1.png

[WindForce]

Re: State variables not work

The 'Edit Form' there is it a UX?

[Catalin]

Re: State variables not work

Yes, it is.

[GGandhi]

Re: State variables not work

1. Edit records - (opens a dialog to edit record) - it's working good because child grid has id_parent column
2. Create new record - it's not working because I don't have the id_parent

that is the way it is.
how can you have a child record before a parent record?
are you trying to create a child record for a non existing parent using your state info?

I did not read the long code you posted, I want to make sure before I go ahead and look into the problem.

[WindForce]

Re: State variables not work

Catalin i use this method in all my grids/UX for editing / adding:

- for editing in my grid the key field (id) is a link, in the onClick of that link i add the action javascript "Open a UX component to add/edit a record in grid". In the action properties, i just select "edit mode" in the first property, and change the window title or size if needed

- for adding, i add a toolbar button to the grid, and in the onClick of that button i add the same action as above ( open ux component to add/edit..." but in the first property i select "add new record mode"

In my db, the ID field is int autoincrement.

In the UX, i set the ID field to readonly with <Auto> in the watermark so when adding people know that the id will be generated.

That's it...

Jaime

[Catalin]

Re: State variables not work

gandhi - the parent must exist. I select a parent without children and I want to create a new child. To make that I click a toolbar action button and I open the UX form to insert the data, but I don't have the id_parent

Bellow I put the tables:
Parent table:
CREATE TABLE `kleverdev`.`tdeviz_obiect` (
`IdDevizObiect` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'The primary key',
`LogicalDelete` tinyint(1) NOT NULL DEFAULT '0',
`DenumireObiect` varchar(250) NOT NULL,
`CursValutar` double NOT NULL DEFAULT '0',
`TVA` double NOT NULL DEFAULT '0',
`DataCreare` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`IdDevizDet` bigint(20) unsigned DEFAULT NULL,
PRIMARY KEY (`IdDevizObiect`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

Child table:
CREATE TABLE `kleverdev`.`tdeviz_reabilitari_termice` (
`IdDevizRT` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`LogicalDelete` tinyint(1) NOT NULL DEFAULT '0',
`FTick` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`Denumire` varchar(500) NOT NULL DEFAULT '',
`IdDevizObiect` bigint(20) unsigned NOT NULL COMMENT 'The relation with the parent',
`Valoare_RON_FARA_TVA_1` double NOT NULL DEFAULT '0' COMMENT 'Studiu fezabilitate',
`Valoare_RON_FARA_TVA_2` double NOT NULL DEFAULT '0' COMMENT 'Proiect tehnic',
`Valoare_RON_FARA_TVA_3` double NOT NULL DEFAULT '0' COMMENT 'Final achizitii',
`IdTipProprietar` bigint(20) DEFAULT NULL,
`IdTipLucrari` bigint(20) DEFAULT NULL,
`IdDestinatieSpatiu` bigint(20) DEFAULT NULL,
`EligibilPentruSpatiiLocuit` tinyint(1) NOT NULL DEFAULT '0',
`NeeligibilPentruSpatiiLocuit` tinyint(1) NOT NULL DEFAULT '0',
`NeeligibilPentruSpatiiAltaDestinatie` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`IdDevizRT`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='Devize reabilitari termice';

Jaime - as you see the child id is autoincrement but I don't have the parent id to relate the child with his parent

[GGandhi]

Re: State variables not work

i will try little later and post my findings.
when you have a toolbar button it relates to the entire grid, nothing special about individual records in that grid. so when you press the button there is no parent meaning no individual row is selected.
on the other hand if you have grid row button then when you click on that the selected row can be harvested and the id of that row can be passed onto the child, see if this explanation helps.
if not i will post a video on a simple scenario.