Topic: Using SqlitePassDataset Filters and SqlitePassDataset.FindFirst etc.

I am had trouble determining if a filter actually resulted in any records because it seemed that, no matter what I tried, functions like SqlitePassDataset.FindFirst would always return false even though filtering did work and there where records that passed the filter. SqlitePassDataset.Found also always returned False. I ended up getting around the problem by just checking the current record contained what I was filtering for after applying the filter (SqlitePassDataset.Filtered:= True).
It might be worth noting that I have set up the database and dataset programmaticely, not using the Lazarus GUI form and object inspector.
Could I be doing something wrong or is this a bug?

Re: Using SqlitePassDataset Filters and SqlitePassDataset.FindFirst etc.

John,

Sorry to answer so late. I was in vacation in spain...

I will try filtering and FindFirst or alike functions. Could you send a db sample and the code you use via email ?
Next version should be out quite soon and I would like to solve bugs if any...

I'm working on Lookup fields and try to implement the ability to sort the dataset on lookup or calc fields.

Thanks.

Re: Using SqlitePassDataset Filters and SqlitePassDataset.FindFirst etc.

I'll try and come up with some test. Sorry for the delay, just got back from overseas this month.