How to call Delphi function in ClientEvent

[Masteritec]

1. Delphi has LockColumn function to determine column is readonly or not.

function TMainForm.LockColumn(ColIdx: Integer): boolean;
begin
  if ColIdx in [1,2] then
  begin
    Result:= ClientDataSet1.FieldByName('EmpNo').AsInteger < 20;
  end;
end;

 

2. UniDBGrid -> ClientEvents -> ExtEvents -> beforeedit to call LockColumn.

function beforeedit(editor, context, eOpts)
{ 
  return MainForm.LockColumn(context.colIdx); 
}

Please refer sample, can't call LockColumn to get lock or not

Grid.zip

[mhmda]

ajaxRequest(MainForm.window,'myfunction',[]);//js code to call a function inside MainForm->AjaxEvents

 

[Masteritec]

Hi,

  Thanks for reply.

If Delphi function return True/False, how to pass back to JS?

like below: LockColumn(context.colIdx) return True/False

function beforeedit(editor, context, eOpts)
{ 
  return MainForm.LockColumn(context.colIdx); 
}

[Sherzod]

1 hour ago, Masteritec said:

If Delphi function return True/False, how to pass back to JS?

Hi,

Something like this:

1. 

function beforeedit(editor, context, eOpts)
{
    return ajaxRequest(this, 'getCheck', [], false).responseText == 'true';
}

2. 

procedure TMainForm.UniDBGrid1AjaxEvent(Sender: TComponent; EventName: string;
  Params: TUniStrings);
begin
  if EventName = 'getCheck' then
  begin
    if ClientDataSet1.FieldByName('EmpNo').AsInteger < 20 then
      UniSession.SendResponse('true')
    else
      UniSession.SendResponse('false')
  end;

end;

 

[Masteritec]

This work well. Thanks

[Masteritec]

Hi,

  context.colIdx return is not match with Column.ColID when some column is hide.

Eg. Column1 - Visible, Column2 - Visible, Column3 - Visible, Column4 - Hide, Column5 - Hide, Column6 - Visible,

Column6 - context.colIdx is 3, but Column.ColID is 6.

Any solution match with context.colIdx?

[Sherzod]

1 minute ago, Masteritec said:

Any solution match with context.colIdx?

You may need dataIndex?

[Masteritec]

10 minutes ago, Sherzod said:

You may need dataIndex?

Only Index, but also can't match with context.colIdx.

[Sherzod]

15 minutes ago, Masteritec said:

Only Index, but also can't match with context.colIdx.

Maybe I don't quite understand your case, could you re-create the test case to see the problem?

[Masteritec]

17 minutes ago, Sherzod said:

Maybe I don't quite understand your case, could you re-create the test case to see the problem?

Refer below: colIdx 4 is not City, cause i hide few columns. Refer test case

Grid2.zip

[Sherzod]

Ok, I will check it. 

[Sherzod]

29 minutes ago, Masteritec said:

Grid2.zip 146.42 kB · 0 downloads

Can you check with this code?

function beforeedit(editor, context, eOpts)
{ 
    return ajaxRequest(this, "GridEditing", ["colIdx="+context.field], false).responseText == "true";
}

 

[Masteritec]

Hi,

  It work well, thank you.

[Masteritec]

Hi,

  I want to check if column is 'Last Name' or 'First Name' in beforeedit like below:

Quote

function beforeedit(editor, context, eOpts)
{
  if ((context.field == 1) || (context.field == 2)) { 
    return ajaxRequest(this, "GridEditing", ["colIdx="+context.field], false).responseText == "true";
  };
}

But if column change position will get wrong, any solution?

Column no change checking is correct:

Column changed checking is incorrect:

Grid3.zip

[Sherzod]

12 hours ago, Masteritec said:

But if column change position will get wrong, any solution?

I think we need to reconsider our decisions with you.

Please tell me again the main goal, what would you like to achieve.

[Masteritec]

7 minutes ago, Sherzod said:

I think we need to reconsider our decisions with you.

Please tell me again the main goal, what would you like to achieve.

1. Column A, Column B, Column C, Column D

2. Column D read only is depend on Column A is empty or not. If Column A empty then Column D can't assign value.

3. Customer allow to move Column position.

[Sherzod]

1 hour ago, Masteritec said:

1. Column A, Column B, Column C, Column D

2. Column D read only is depend on Column A is empty or not. If Column A empty then Column D can't assign value.

3. Customer allow to move Column position.

Ok, I'll analyze again.

[Masteritec]

On 3/10/2021 at 1:25 PM, Sherzod said:

Ok, I'll analyze again.

Hi,

  Any solution for it?

 

thanks

[Sherzod]

On 3/10/2021 at 10:25 AM, Sherzod said:

2. Column D read only is depend on Column A is empty or not. If Column A empty then Column D can't assign value.

Hi,

What if there is such a scenario?
1. The user will assign the value to Column A
2. Then the user will assign the value to Column D
3. After, the user will delete the value in Column A

[Masteritec]

8 minutes ago, Sherzod said:

Hi,

What if there is such a scenario?
1. The user will assign the value to Column A
2. Then the user will assign the value to Column D
3. After, the user will delete the value in Column A

Delete the value in Column A and system auto delete the value in Column D.

[Masteritec]

Hi, 

Quote

 function beforeedit(editor, context, eOpts)
{
  if ((context.field == 1) || (context.field == 2)) { 
    return ajaxRequest(this, "GridEditing", ["colIdx="+context.field], false).responseText == "true";
  };
}

above coding can be write on the fly? Then I can assign context.field after column move in grid.

[Masteritec]

Hi, any idea for it?

[Sherzod]

9 hours ago, Masteritec said:

Hi, any idea for it?

Hi,

Do you mean these values "==1, ==2" ?

[Masteritec]

11 hours ago, Sherzod said:

Hi,

Do you mean these values "==1, ==2" ?

Yup, how to dynamic it when column position change.

[Sherzod]

59 minutes ago, Masteritec said:

Yup, how to dynamic it when column position change.

I will try to provide you one of the possible solutions.