[Kexi] importing mdb files

[Martin Ellis]

On Tuesday 30 May 2006 15:07, you wrote:
> > Then just use the "Import Existing Database" feature in the
> > startup dialog box.
>
> Yes, it works really good. My MS data bases were fine imported
> except of querries and forms (there was no other objects like
> reports, macra, modules etc.) 

Yeah, queries and forms haven't been reverse engineered yet (and may 
never be).    I guess we might be able to get the SQL out of queries, 
not sure.

> Unfortunately, I can not find any useful thing like a filter :( I
> do not exactly remember, but probably there was such a tool in any
> previous version of kexi (present version is 1.0.1 compiled with
> koffice 1.5.1). Is it real lack?

No.  Don't think so.

Create a query

Select a tablename in the drop-down box

Double click the column names you want

Add your search criteria to the "Criteria" field for the respective 
column. Examples  are:
  >5                 (for numbers)
  ="Martin"    (for strings),  
  =0                 (for Boolean fields)
  =1                 ( "     "           ")

Click View->Data View, and your data should be filtered.


Martin