SqlFormWizardBase ********************************************************************* ** Copyright (C) 2001-2008 Trolltech ASA. All rights reserved. ** ** This file is part of Qt Designer. ** ** This file may be used under the terms of the GNU General ** Public License versions 2.0 or 3.0 as published by the Free ** Software Foundation and appearing in the files LICENSE.GPL2 ** and LICENSE.GPL3 included in the packaging of this file. ** Alternatively you may (at your option) use any later version ** of the GNU General Public License if such license has been ** publicly approved by Trolltech ASA (or its successors, if any) ** and the KDE Free Qt Foundation. ** ** Please review the following information to ensure GNU General ** Public Licensing requirements will be met: ** http://trolltech.com/products/qt/licenses/licensing/opensource/. ** If you are unsure which license is appropriate for your use, please ** review the following information: ** http://trolltech.com/products/qt/licenses/licensing/licensingoverview ** or contact the sales department at sales@trolltech.com. ** ** Licensees holding valid Qt Commercial licenses may use this file in ** accordance with the Qt Commercial License Agreement provided with ** the Software. ** ** This file is provided "AS IS" with NO WARRANTY OF ANY KIND, ** INCLUDING THE WARRANTIES OF DESIGN, MERCHANTABILITY AND FITNESS FOR ** A PARTICULAR PURPOSE. Trolltech reserves all rights not granted ** herein. ** ********************************************************************* SqlFormWizardBase 0 0 577 570 Sql Wizard databasePage Choose the Database and Table unnamed 0 6 TextLabel4 0 7 0 0 qtwizards_table_1.png Layout5 unnamed 0 6 TextLabel3_2 &Table: listBoxTable Layout4 unnamed 0 6 PushButton5 &Setup Database Connections... Click here to manage your database connections Here you can add, modify and delete your database connections Spacer1_2 Horizontal Expanding 20 20 TextLabel3_3 Database &Connection: listBoxConnection listBoxTable Displays all tables inside the selected Database listBoxConnection Displays a list of available connections on your system populatePage Displayed Fields unnamed 0 6 TextLabel4_2 0 7 0 0 qtwizards_table_2.png Layout11 unnamed 0 6 Spacer1_10 Vertical Expanding 20 20 buttonAddField_2 designer_right.png Move field to list of displayed fields Click here to add the selected field to the list of fields that will be displayed. buttonRemoveField_2 designer_left.png remove field from list of displayed fields Click here to remove the selected field from the list of fields that will be displayed. Spacer2_5 Vertical Expanding 20 20 buttonFieldUp_2 designer_up.png Move Field up Click here to move the selected field in the displayed fields list up. Spacer3_3 Vertical Expanding 20 20 listBoxField This is a list of all available fields in your selected table. Fields in this list will not be displayed. buttonFieldDown_2 designer_down.png Move field down Click here to move the selected field in the displayed fields list down. listBoxSelectedField All fields in this list will be displayed. TextLabel2_3 Displayed Fields: TextLabel1_7 Available Fields: navigPage Navigation and Editing unnamed 0 6 TextLabel4_2_2 0 7 0 0 qtwizards_table_3.png Layout6 unnamed 0 6 checkBoxNavig &Include Navigation Buttons true Activates the navigation bar Activates the navigation bar GroupBox2 5 7 0 0 &Navigation unnamed 11 6 checkBoxPrev &Previous true Toggles whether the "Previous" button will be displayed Toggles whether the "Previous" button will be displayed checkBoxNext &Next true Toggles whether the "Next" button will be displayed Toggles whether the "Next" button will be displayed checkBoxFirst &First true Toggles whether the "First" button will be displayed Toggles whether the "First" button will be displayed checkBoxLast &Last true Toggles whether the "Last" button will be displayed Toggles whether the "Last" button will be displayed checkBoxEdit In&clude Edit Buttons true Activates the edit bar Activates the edit bar GroupBox3 5 7 0 0 &Editing unnamed 11 6 checkBoxInsert &Insert true User can insert new rows User can insert new rows checkBoxUpdate &Update true user can edit existing rows user can edit existing rows checkBoxDelete &Delete true user can delete rows user can delete rows Spacer1_3 Vertical Expanding 20 20 tablePropertiesPage Table Properties unnamed 0 6 TextLabel4_2_2_2_2 0 7 0 0 qtwizards_table_4.png Spacer1_7 Vertical Expanding 20 20 GroupBox5 Editing unnamed 11 6 checkBoxReadOnly &Read-Only Table will be read-only Activate this to prevent editing, deleting and adding of rows GroupBox4 Confirmations unnamed 11 6 checkBoxConfirmInserts Confirm &Inserts Query user on inserting rows User will be asked for confirmation if he inserts a new row checkBoxConfirmUpdates Confirm &Updates Query user on editing rows User will be asked for confirmation if he edits a row checkBoxConfirmCancels Confirm &Cancels Query user on canceling User will be asked for confirmation if he cancels an action checkBoxConfirmDeletes Confirm &Deletes true Query user on deleting rows User will be asked for confirmation if he deletes a row checkBoxSorting Allow column &sorting true User may change sorting User may change sorting of data by clicking on a field in the top row of the table sqlPage SQL unnamed 0 6 TextLabel4_2_2_2 0 7 0 0 qtwizards_table_2.png Layout8 unnamed 0 6 TextLabel3_2_2_2 &Sort: listBoxTable Spacer1_5 Vertical Expanding 20 20 Layout10 unnamed 0 6 TextLabel3_2_2 &Filter: listBoxTable Spacer1_4 Vertical Expanding 20 20 Layout13 unnamed 0 6 TextLabel1_3 (a valid WHERE clause, e.g. id > 100) editFilter Enter a valid SQL WHERE statement, for example: name like "qt%" (name like "q%") and (version > 3) ((version > 3) and (price > 1000)) or (name like "%embed%") Layout10 unnamed 0 6 TextLabel2 Sort By listBoxSortedField Data will be sorted according to the selected fields. Layout11 unnamed 0 6 Spacer2_2 Vertical Expanding 20 20 buttonAddSortField designer_right.png Move field to the right list Klick here to add the currently selected field from the available fields list to the sorting criteria buttonRemoveSortField designer_left.png remove field from the right list Klick here to remove the currently selected field from the sorting criteria Spacer1_6 Vertical Expanding 20 20 buttonUpSortField designer_up.png move field up Move selected field in the sort by list up buttonDownSortField designer_down.png move field down Move selected field in the sort by list down Spacer2_3 Vertical Expanding 20 20 buttonReSortField re-sort.png Change field sort from ASC to DESC and back Changes the field sort order from ascending to descending for the selected field in the sort by list. Layout12 unnamed 0 6 TextLabel1_4 Available Fields listBoxSortField This is the list of all available fields in the selected table layoutPage Layout unnamed 0 6 TextLabel4_2_2_2_3_2 0 7 0 0 qtwizards_table_3.png Spacer1_9 Vertical Expanding 20 20 ButtonGroup1 &Labels unnamed 11 6 radioLabelsLeft true Labels to &left true Create labels to the left of data entry fields. TextLabel3 3 1 0 0 Create labels above data entry fields. TextLabel2_2 3 1 0 0 Create labels to the left of data entry fields. Spacer4 Horizontal Maximum 20 20 Spacer5 Horizontal Maximum 16 20 radioLabelsTop Labels on &top Create labels above data entry fields. checkCreateLayouts &Create layout for all true Create a BoxLayout around the whole widget If you select this a BoxLayout will be created for the whole widget checkCreateButtonLayout Create layout for &buttons true Create a BoxLayout around the buttons If you select this the designer will arrange all buttons inside an BoxLayout checkCreateFieldLayout Create layout for &fields true Create a BoxLayout around the fields If you select this the designer will arrange all fields inside an BoxLayout spinNumberOfColumns 20 2 Enter the number of desired columns Enter the number of desired columns TextLabel1_6 Number of Columns: Spacer3_2 Vertical Expanding 20 20 finishPage Finish unnamed 0 6 TextLabel4_2_2_2_3 0 7 0 0 qtwizards_table_1.png TextLabel1_5 Press Finish to create the widget. Spacer2_4 Vertical Expanding 20 20 Spacer1 Vertical Expanding 20 20 Spacer2 Vertical Expanding 20 20 checkBoxAutoEdit &AutoEditing Discard changes when user klicks into another row This property holds whether the table automatically applies edits. When the user begins an insert or update in the table there are two possible outcomes when they navigate to another record 1.the insert or update is is performed -- this occurs if AutoEditing is on 2.the insert or update is abandoned -- this occurs if AutoEditing is off PushButton5 clicked() SqlFormWizardBase setupDatabaseConnections() checkBoxNavig toggled(bool) GroupBox2 setEnabled(bool) checkBoxEdit toggled(bool) GroupBox3 setEnabled(bool) buttonReSortField clicked() SqlFormWizardBase reSortSortField() buttonRemoveSortField clicked() SqlFormWizardBase removeSortField() buttonAddSortField clicked() SqlFormWizardBase addSortField() buttonUpSortField clicked() SqlFormWizardBase sortFieldUp() buttonDownSortField clicked() SqlFormWizardBase sortFieldDown() listBoxSortField doubleClicked(QListBoxItem*) SqlFormWizardBase addSortField() listBoxSortedField doubleClicked(QListBoxItem*) SqlFormWizardBase removeSortField() listBoxSortedField rightButtonClicked(QListBoxItem*,const QPoint&) SqlFormWizardBase reSortSortField() checkBoxReadOnly toggled(bool) GroupBox4 setDisabled(bool) listBoxConnection highlighted(const QString&) SqlFormWizardBase connectionSelected(const QString&) listBoxTable highlighted(const QString&) SqlFormWizardBase tableSelected(const QString&) buttonAddField_2 released() SqlFormWizardBase addField() buttonRemoveField_2 clicked() SqlFormWizardBase removeField() buttonFieldUp_2 clicked() SqlFormWizardBase fieldUp() buttonFieldDown_2 clicked() SqlFormWizardBase fieldDown() PushButton5 listBoxConnection listBoxTable checkBoxNavig checkBoxPrev checkBoxNext checkBoxFirst checkBoxLast checkBoxEdit checkBoxInsert checkBoxUpdate checkBoxDelete checkBoxReadOnly checkBoxConfirmInserts checkBoxConfirmUpdates checkBoxConfirmDeletes checkBoxConfirmCancels checkBoxSorting editFilter listBoxSortField buttonAddSortField buttonRemoveSortField buttonUpSortField buttonDownSortField buttonReSortField listBoxSortedField spinNumberOfColumns radioLabelsLeft radioLabelsTop checkCreateFieldLayout checkCreateButtonLayout checkCreateLayouts init() destroy() addField() addSortField() fieldDown() fieldUp() reSortSortField() removeField() removeSortField() setupDatabaseConnections() sortFieldDown() sortFieldUp() connectionSelected( const QString & ) tableSelected( const QString & )