On Fri, 2011-01-07 at 09:56 +0100, Jaroslaw Staniek wrote: > On 7 January 2011 04:58, Swarup <[email protected]> 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 _______________________________________________ Kexi mailing list [email protected] https://mail.kde.org/mailman/listinfo/kexi
