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".
I am looking at the issue. I am sorry for the delay.
Hello, still a problem in Kexi 2.x?
Closing. Let's reopen if we discover it in 2.x.