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
[email protected]
https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
