mORMot Open Source

corchi72

Member

Registered: 2010-12-10

Posts: 232

Help me about "AddFilterOrValidate"

I'm Sorry for the question but I do not understand how the function "AddFilterOrValidate"  can filter the records, the filter is similar to the selection of QlikView?

Thanks corchi

Last edited by corchi72 (2013-08-06 09:57:25)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,240

Website

Re: Help me about "AddFilterOrValidate"

Did you read the SAD 1.18 pdf?
See also the old by still available http://blog.synopse.info/post/2011/06/0 … ilter-data

The AddFilterOrValidate() method does not filter nor validate anything.
It registers a filter of validation class for a given TSQLRecord field.

In short, the UI has to handle it, i.e. by calling Validate or Filter method.
This is the case e.g. for mORMot UI editing auto-generated forms (unit mORmotUIEdit.pas), but not standard VCL forms or components.

corchi72

Member

Registered: 2010-12-10

Posts: 232

Re: Help me about "AddFilterOrValidate"

So it is not possible to carry out a series of filters in the same time on multiple tables connected to each other, how does QlikView?

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,240

Website

Re: Help me about "AddFilterOrValidate"

You can do it for one table after the other, I suppose.

Since you can define your on validation class, with access to the global TSQLRest instance, you can do whatever validation you need, even with multiple linked tables.

corchi72

Member

Registered: 2010-12-10

Posts: 232

Re: Help me about "AddFilterOrValidate"

Could you give me an example: type clients "TSQLCustomer" respective cities  "TSQLcountry",
What I must to  write to filter the cities and display only the customers of the Cities filtered?

corchi72

Member

Registered: 2010-12-10

Posts: 232

Re: Help me about "AddFilterOrValidate"

sorry but no one can write a simple example, I read the documentation but can not find an example that performs TSQLRecord.Filter ('01, 02, ... '= array of ID of the table TSQLRecord), and then I execute While TSQLRecord.fillone do.

Thanks