[MSEide-MSEgui-talk] Filter Data
Hi Martin, Filtering data via Navigator is a nice way brcause we know the dataset concerned. Before Apply filter, the user has to type any data in the field he wants to be filtred Is there any function to know the fieldName concerned? ps: I want to know this fieldname in the datamodule of the application because the dataset and all events are tere? -- Time is money. Stop wasting it! Get your web API in 5 minutes. www.restlet.com/download http://p.sf.net/sfu/restlet___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] Filter Data
On Sunday 01 June 2014 18:01:33 Med Hamza wrote: > Hi Martin, > > Filtering data via Navigator is a nice way brcause we know the dataset > concerned. > > Before Apply filter, the user has to type any data in the field he wants > to be filtred > Is there any function to know the fieldName concerned? > I don't understand, can you make an example? Martin -- Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech ___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] Filter Data
Let's have a DBNav, different tmse*edit field and a Datasource in MainForm. DBNav [dbnb_filter dbnb_filteronoff ] are set to true In Datamodule we have the TmseSqlQuery and events handlers : BeforeBeginFilteredEdit, BeforeEndFilteredEdit and OnFilterRecord. I want to know which field, the user has typed in BeforebeginFiltered or BeforeEndFiltered ? Med. 2014-06-02 7:47 GMT+01:00 Martin Schreiber : > On Sunday 01 June 2014 18:01:33 Med Hamza wrote: > > Hi Martin, > > > > Filtering data via Navigator is a nice way brcause we know the dataset > > concerned. > > > > Before Apply filter, the user has to type any data in the field he > wants > > to be filtred > > Is there any function to know the fieldName concerned? > > > I don't understand, can you make an example? > > Martin > > > -- > Learn Graph Databases - Download FREE O'Reilly Book > "Graph Databases" is the definitive new guide to graph databases and their > applications. Written by three acclaimed leaders in the field, > this first edition is now available. Download your free book today! > http://p.sf.net/sfu/NeoTech > ___ > mseide-msegui-talk mailing list > mseide-msegui-talk@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk > -- Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] Filter Data
On Monday 02 June 2014 10:32:47 Med Hamza wrote:
> Let's have a DBNav, different tmse*edit field and a Datasource in
> MainForm. DBNav [dbnb_filter dbnb_filteronoff ] are set to true
>
> In Datamodule we have the TmseSqlQuery and events handlers :
> BeforeBeginFilteredEdit, BeforeEndFilteredEdit and OnFilterRecord.
>
>
> I want to know which field, the user has typed in BeforebeginFiltered or
> BeforeEndFiltered ?
>
"isnull" is false for fields with user entries in onafterbeginfilteredit and
onbeforeendfilteredit.
"
procedure tmainfo.endfiltereditexe(const sender: tmsebufdataset;
const akind: filtereditkindty);
var
int1: integer;
begin
writeln('');
for int1:= 0 to sender.fields.count - 1 do begin
with sender.fields[int1] do begin
if not isnull then begin
writeln(fieldname); //user entered a value
end;
//store the field values for later use in OnFilterRecord.
end;
end;
end;
"
There is also tmsebufdataset
"
function fieldfiltervalue(const afield: tfield): variant;
function fieldfiltervalueisnull(const afield: tfield): boolean;
"
I probably should add functions for min and max too.
Martin
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
___
mseide-msegui-talk mailing list
mseide-msegui-talk@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] Filter Data
On Monday 02 June 2014 11:11:01 Martin Schreiber wrote: > There is also tmsebufdataset > " >function fieldfiltervalue(const afield: tfield): variant; >function fieldfiltervalueisnull(const afield: tfield): boolean; > " > I probably should add functions for min and max too. > There already is the property tmsebufdataset.filtereditkind for the purpose. git master 686058771c47f6c8cffe14c3dd721cc8e1d52bc9 has an additional filter kind parameter for convenience: " function fieldfiltervalue(const afield: tfield; const akind: filtereditkindty = fek_filter): variant; function fieldfiltervalueisnull(const afield: tfield; const akind: filtereditkindty = fek_filter): boolean; " there is also a new dbnavigator button dbnb_filterclear (experimental). Martin -- Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech ___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] Filter Data
Using filter is clear, and very simple to use when working with mseide-msegui, but how to set controling index of a tmsesqlquery ? I tried indexname, IndexFieldNames. I believe it's for dbf files. Med 2014-06-02 19:09 GMT+01:00 Martin Schreiber : > On Monday 02 June 2014 11:11:01 Martin Schreiber wrote: > > > There is also tmsebufdataset > > " > >function fieldfiltervalue(const afield: tfield): variant; > >function fieldfiltervalueisnull(const afield: tfield): boolean; > > " > > I probably should add functions for min and max too. > > > There already is the property tmsebufdataset.filtereditkind for the > purpose. > git master 686058771c47f6c8cffe14c3dd721cc8e1d52bc9 has an additional > filter > kind parameter for convenience: > " >function fieldfiltervalue(const afield: tfield; > const akind: filtereditkindty = fek_filter): variant; >function fieldfiltervalueisnull(const afield: tfield; > const akind: filtereditkindty = fek_filter): boolean; > " > there is also a new dbnavigator button dbnb_filterclear (experimental). > > Martin > > > > > -- > Learn Graph Databases - Download FREE O'Reilly Book > "Graph Databases" is the definitive new guide to graph databases and their > applications. Written by three acclaimed leaders in the field, > this first edition is now available. Download your free book today! > http://p.sf.net/sfu/NeoTech > ___ > mseide-msegui-talk mailing list > mseide-msegui-talk@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk > -- Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] Filter Data
On Wednesday 04 June 2014 13:42:14 Med Hamza wrote: > Using filter is clear, and very simple to use when working with > mseide-msegui, but how to set controling index of a tmsesqlquery ? I tried > indexname, IndexFieldNames. I believe it's for dbf files. > Correct. Please use the "indexlocal" property. Martin -- Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech ___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] Filter Data
How much memory does it cost. I mean RAM used. 2014-06-04 14:12 GMT+01:00 Martin Schreiber : > On Wednesday 04 June 2014 13:42:14 Med Hamza wrote: > > Using filter is clear, and very simple to use when working with > > mseide-msegui, but how to set controling index of a tmsesqlquery ? I > tried > > indexname, IndexFieldNames. I believe it's for dbf files. > > > Correct. Please use the "indexlocal" property. > > Martin > > > -- > Learn Graph Databases - Download FREE O'Reilly Book > "Graph Databases" is the definitive new guide to graph databases and their > applications. Written by three acclaimed leaders in the field, > this first edition is now available. Download your free book today! > http://p.sf.net/sfu/NeoTech > ___ > mseide-msegui-talk mailing list > mseide-msegui-talk@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk > -- Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] Filter Data
On Wednesday 04 June 2014 15:22:00 Med Hamza wrote: > How much memory does it cost. I mean RAM used. > A pointer (4 or 8 bytes) per record and index, probably insignificant. Btw, active index and direction can be switched by mouse in grids by activating fixrows[n].captions[m].options dco_colsort. Martin -- Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech ___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] Filter Data
Is it possible to build local index manually? Adding keys to this index depending on a certain condition. something like if c then addkey( nkey) ; 2014-06-04 14:29 GMT+01:00 Martin Schreiber : > On Wednesday 04 June 2014 15:22:00 Med Hamza wrote: > > How much memory does it cost. I mean RAM used. > > > A pointer (4 or 8 bytes) per record and index, probably insignificant. > Btw, active index and direction can be switched by mouse in grids by > activating fixrows[n].captions[m].options dco_colsort. > > Martin > > > -- > Learn Graph Databases - Download FREE O'Reilly Book > "Graph Databases" is the definitive new guide to graph databases and their > applications. Written by three acclaimed leaders in the field, > this first edition is now available. Download your free book today! > http://p.sf.net/sfu/NeoTech > ___ > mseide-msegui-talk mailing list > mseide-msegui-talk@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk > -- Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] Filter Data
On Wednesday 04 June 2014 16:24:30 Med Hamza wrote: > Is it possible to build local index manually? > Adding keys to this index depending on a certain condition. > something like if c then addkey( nkey) ; > Yes. The count of indexes can not be changed if the dataset is active. Martin -- Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech ___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
