Exception SOpt

[feland]

Hi,
when i add my column dinamically to my jqgrid and set col.SearchOptions.SOpt to ... my webapplication show the exception:

SetConversion undefined in "TIWCGJQGridColSearchOptions.ConvertSetToString" for property "SOpt"!

Following i post the code that i used to create the JQgridcolumns:

Code: Select all

 
var
      col: TIWCGJQGridCol;
begin
    slCol := TStringList.Create;
    slCol.Delimiter := ';';
    slCol.StrictDelimiter := true;
    slCol.DelimitedText := sIntestazione;

    while (i < slCol.Count) do
    begin
      sFieldName := slCol[i];

      col := JQGridReport.JQGridOptions.ColModel.Add;
      col.Name := sFieldName;
      col.Idx := sFieldName;
      col.Caption := StringReplace(sFieldName, '_', ' ', [rfReplaceAll]);;
      col.Editable := false;
      col.Formatter := gcfNone;

      col.SearchOptions.SOpt:=[gsoEqual, gsoNotEqual, gsoBeginWith, gsoDoesntBegin, gsoIsIn, gsoIsNotIn, gsoEndsWith, gsoDoesntEndsWith,  gsoContains, gsoDoesntContain, gsoLessEqual,gsoGreatEqual];

      col.Search := true;
      col.Sortable := true;

      inc(i);
    end;
end;


On attachment the Exception screen that I show.
Can you help me?

Thanks,
feland

[feland]

The request is urgent please.

[Alexander Bulei]

Hi feland,

When you call that code?

Best Regards.

[feland]

OnCellSelectEvent.
I create that columns to a second JqGrid that is empty without columns.
If I comment the line

Code: Select all

    col.SearchOptions.SOpt:=[gsoEqual, gsoNotEqual, gsoBeginWith, gsoDoesntBegin, gsoIsIn, gsoIsNotIn, gsoEndsWith, gsoDoesntEndsWith,  gsoContains, gsoDoesntContain, gsoLessEqual,gsoGreatEqual];

it works correctly but I don't view the operator LessEqual, GreatEqual.

Help me please.

[Jorge Sousa]

Hello

I'm afraid that code will not work in the event OnCellSelectEvent

Because .jqgrid doesn't support SOpt to be changed on the fly with javascript.

You will have to find a way to do the same at create time,

or

using grid.ajaxrenreder which re-renders the whole grid again.

[feland]

Thank you so much,
using the event ajaxrerender it works correctly.

[feland]

Hi,
on grid.ajaxrerender event I set that code:

Code: Select all

       formatOptionDateTime := TIWCGJQGridColFormatOptionsDateTime.Create(nil);
        formatOptionDateTime.SrcFormat := 'Y-m-d h:i:s';
        formatOptionDateTime.NewFormat := 'd/m/Y h:i:s';
        formatOptionDateTime.NewFormatDelphi := 'dd/mm/yyyy hh:nn:ss';
        gridAggiornamenti.JQGridOptions.ColModel[0].FormatOptions := formatOptionDateTime;
        formatOptionDateTime.Free;


but when i recreate my grid column ,its format is 'yyyy-mm-dd hh:nn:ss'.
How Can I set the format correctly?

Thanks,
feland

[Jorge Sousa]

Hi

Just set NewFormatDelphi

never change SrcFormat

and NewFormat is changed internally by setting NewFormatDelphi

[feland]

Thanks, it work.