Bug 145557 - Query Design View Up/Down scroll problem
Summary: Query Design View Up/Down scroll problem
Status: CLOSED WAITINGFORINFO
Alias: None
Product: KEXI
Classification: Applications
Component: KexiDB (show other bugs)
Version: unspecified
Platform: Compiled Sources Linux
: NOR normal
Target Milestone: ---
Assignee: Jarosław Staniek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-05-17 16:16 UTC by Jeremy Johnson
Modified: 2015-10-31 21:12 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jeremy Johnson 2007-05-17 16:16:36 UTC
Version:           1.6.1 (using KDE KDE 3.5.6)
Installed from:    Compiled From Sources
Compiler:          gcc version 4.1.1 (Gentoo 4.1.1-r3) 
OS:                Linux

I was designing a query using the Design View editor using
seven tables:
$query="SELECT judgments.case_no, judgments.date, properties.section, properties.lot, properties.taxmap, properties.water_front, judgments.amount, judgments.attorneys_fees, judgments.court_costs, judgments.interest_rate, contacts.street1, contacts.street2, contacts.city, provinces.abbreviation AS State, contacts.zipcode, countries.abbreviation AS Country, contacts.telephones, contacts.emails, persons.last_name, persons.first_name, persons.initial, persons.suffix FROM persons, contacts, countries, provinces, person_judgment, judgments, properties WHERE properties.id = judgments.property_id AND contacts.id = judgments.contact_id AND provinces.id = contacts.state_id AND countries.id = contacts.country_id AND persons.id = person_judgment.person_id AND judgments.id = person_judgment.judgment_id"

As I connected the various Primary Keys to corresponding fields among the various tables, the working canvas grew in size and a Up/Down scroll bar appeared on the righthand side as expected. After switching to DataView and then back, my righthand scroll bar had disappeared and I could no longer access parts of tables which had gone off the top of the screen. If I dragged the tables boxes to the bottom edge, the scroll bar reappeared but it still did not allow me to access those table boxes which had gone off the top edge of the canvas. If I tried dragging a table box to the top edge, I could not proceed beyond the top edge and I could not get my scroll bar back. I also tried various combinations of keys/mouse clicks (shift-click, alt-click, ctrl-click, etc.) without any luck.


I also cannot seem to rename any fields as an Alias in QueryDesignView which would be useful. For instance, in the above SQL query I have a tables for 
states{Id, country_id, name, abbreviation} and an ISO-3166 table for countries{Id, name, abbreviation}

When I print out the QueryResults, the state and country fields are labeled as "abbreviation" and "abbreviation"
which I would preferred to have aliased AS "state" and
"country".
Comment 1 Jarosław Staniek 2007-06-08 13:01:58 UTC
I am looking at the issue. I am sorry for the delay.
Comment 2 Jarosław Staniek 2011-07-17 22:36:55 UTC
Hello, still a problem in Kexi 2.x?
Comment 3 Jarosław Staniek 2015-10-31 21:12:34 UTC
Closing. Let's reopen if we discover it in 2.x.