[Kexi] Re: kexi queries

[Adam Pigg]

Tom Browder wrote:

> I just started experimenting with kexi after several years.  I
> imported an Access db okay (data and structure fine, no queries were
> imported, too bad).
> 
> I rebuilt a query for my one table but I can't get it to show data.
> I'm sure I've done something dumb but I can't see the error.
> 
> My simplified buggy table looks something like this (the real db has
> more fields):
> 
> fields:
> 
> firstname (text)
> label (Yes/No)
> death (text)
> 
> My query is:
> 
> SELECT name FROM buggy WHERE buggy.label = 'Yes' AND (buggy.death =
> NULL OR buggy.death = '')
> 
> But I get no data results!  (I do on Access).
> 
> I am using the latest trunk version source that I built today.
> 
> I can send both database files (kexi and mdb) if anyone is interested.
> 
> Two immediate enhancements I believe are needed (I haven't looked at bugs
> yet):
> 
> 1.  Remember the last directory used to open a file.
> 2.  Allow import from other file types than Access (I tried xslx and
> tab-separated, kexi complained about both).
> 
This should work...once inside a database, goto the External Data menu.

Import Tables : this option will import tables from another database or 
spreadsheet
Import Data From File : this option will import text data from a tab/csv


Adam 
> I am willing  and able to help with bug fixes but am brand new to the code
> base.
> 
> Thanks and regards,
> 
> -Tom
> 
> Thomas M. Browder, Jr.
> Niceville, Florida
> USA