[Kexi] Re: How to select (highlight) one column in Kexi 1.1.3?

[Swarup]

On Fri, 2011-01-07 at 09:56 +0100, Jaroslaw Staniek wrote:
> On 7 January 2011 04:58, Swarup <dinbandhu at sprynet.com> wrote:
> > Hello,
> > I am using Kexi 1.1.3 (KOffice 1.6.3), and have a table of around 500
> > rows. I need to be able to highlight one full column for:
> >
> > 1. printing the data in that column only;
> > 2. copy/pasting the data in that column into another application, for
> > example OO Writer.
> 
> Selecting a column is not possible with simple click. But user can
> create a query which selects just one column (field) using the Query
> Designer, and then run the query. Then the results should be available
> for copying to clipboard, exporting to a file and printing.

OK, I created the query and exported it. The order of rows is set
according to the primary key column. Is it possible for me to have the
query made with the order of rows set according to a different column? I
want to have the order of rows set according to a column other than the
column I have selected for the query.

> > I would also like to be able to highlight part of the column for the
> > same above two purposes-- for example say, 25 rows only of one column,
> > for copy/paste or for printing.
> 
> That may be possible even with queries in Kexi but not always.
> I mean, that you can proceed with the recipe explained above to create
> a query showing single column, and then you can add condition to only
> display 25 first rows. I said "may be possible" because for this to
> work you need to assume you have primary key column defined with clean
> sequence of numbers, e.g. 1, 2, ... 25. Then the condition would be
> "id <= 25" in the "Condition" column of the query design view.

I do have the primary key column defined with clean sequence of numbers.

1. How would you word the condition if you want say, rows 102 to 143?

2. Having sorted the main table sorted using a DIFFERENT column than the
primary key, can one then request the query condition according to
specific conditions of THAT column?

Thanks,
Swarup