iwcgjqgrid search and memtable

[hsbelli72]

hi, this event is possible to use when a IWCGJQGridDataSetProvider1 dataset is attach a tkbmemtable?. because not run the filter property of memtable.

regards

procedure TIWFrameConsuStock.IWCGJQGridDataSetProvider1SearchSQL
(Sender: TObject; AData: TIWCGJQProviderSearchData; const ASQL: string);
var
SQL: string;
begin
SQL := ASQL;
if SQL <> '' then
SQL := ' ' + SQL;

if SQL = '' then
begin
memstock.Filter := '';
memstock.Filtered := false;
Exit;
end
ELSE
BEGIN
memstock.Filter := '';
memstock.Filtered := false;
memstock.Filter := SQL;
memstock.Filtered := True;

END;
end;

[Jorge Sousa]

Hi

You can use the event JQGridProviderDataSet.OnRuleToSQL to define how the SQL will be.

Why it doesn't accept the SQL? what are tkbmemtable filter specifications?

[hsbelli72]

hi, the filter in my tkbmemtable is simple like this memstock.Filter := 'nombreapellido='JUAN' ' . nothing do when execute the events JQGridProviderDataSet.OnRuleToSQL or JQGridProviderDataSet.OnSearchSQL. show the iwcgjqgrid empty and the value exists... any suggestions?.

regards

[Jorge Sousa]

Hi

Are you saying that when you call

memstock.Filter := 'nombreapellido='JUAN' '

The filter doesn't work? what is the ASQL value?

[hsbelli72]

yes not run a filter. the value os ASQL is (nombreapellido='JUAN'). is possible a remote session ?

regards

[Jorge Sousa]

Hello

if you do this

Code: Select all

memstock.Filter := 'nombreapellido='JUAN' '

~

in a Windows application, what happens?

[hsbelli72]

hi, in windows application run ok the filter.

[Jorge Sousa]

Hi

You must check the properties of your memdataset

it's obvious that we have nothing to do with this

[hsbelli72]

hi, change the tkbmemtable for a tclientdataset and have the same problem..

regards

[Jorge Sousa]

Hi

Please submit a test case with TClientDataSet