Home Original page

Add support for strict tables in the UI · sqlitebrowser/sqlitebrowser@da28fdc

@@ -86,14 +86,14 @@

8686

</property>

8787

</widget>

8888

</item>

89-

<item row="2" column="0">

89+

<item row="3" column="0">

9090

<widget class="QLabel" name="label_2">

9191

<property name="text">

9292

<string>On Conflict</string>

9393

</property>

9494

</widget>

9595

</item>

96-

<item row="2" column="1">

96+

<item row="3" column="1">

9797

<widget class="QComboBox" name="comboOnConflict">

9898

<item>

9999

<property name="text">

127127

</item>

128128

</widget>

129129

</item>

130+

<item row="2" column="0">

131+

<widget class="QLabel" name="label_3">

132+

<property name="text">

133+

<string>Strict</string>

134+

</property>

135+

<property name="buddy">

136+

<cstring>checkStrict</cstring>

137+

</property>

138+

</widget>

139+

</item>

140+

<item row="2" column="1">

141+

<widget class="QCheckBox" name="checkStrict">

142+

<property name="toolTip">

143+

<string>When the strict option is enabled SQLite enforces the data types of each column when updating or inserting data.</string>

144+

</property>

145+

</widget>

146+

</item>

130147

</layout>

131148

</widget>

132149

</item>

562579

<tabstop>buttonMore</tabstop>

563580

<tabstop>comboSchema</tabstop>

564581

<tabstop>checkWithoutRowid</tabstop>

582+

<tabstop>checkStrict</tabstop>

583+

<tabstop>comboOnConflict</tabstop>

565584

<tabstop>groupDefinition</tabstop>

566585

<tabstop>addFieldButton</tabstop>

567586

<tabstop>removeFieldButton</tabstop>

@@ -570,7 +589,6 @@

570589

<tabstop>buttonMoveDown</tabstop>

571590

<tabstop>buttonMoveBottom</tabstop>

572591

<tabstop>treeWidget</tabstop>

573-

<tabstop>sqlTextEdit</tabstop>

574592

<tabstop>buttonAddConstraint</tabstop>

575593

<tabstop>buttonRemoveConstraint</tabstop>

576594

<tabstop>tableConstraints</tabstop>

634652

<slot>addField()</slot>

635653

<hints>

636654

<hint type="sourcelabel">

637-

<x>82</x>

638-

<y>248</y>

655+

<x>79</x>

656+

<y>311</y>

639657

</hint>

640658

<hint type="destinationlabel">

641659

<x>79</x>

@@ -650,8 +668,8 @@

650668

<slot>removeField()</slot>

651669

<hints>

652670

<hint type="sourcelabel">

653-

<x>178</x>

654-

<y>248</y>

671+

<x>169</x>

672+

<y>311</y>

655673

</hint>

656674

<hint type="destinationlabel">

657675

<x>249</x>

682700

<slot>moveUp()</slot>

683701

<hints>

684702

<hint type="sourcelabel">

685-

<x>400</x>

686-

<y>248</y>

703+

<x>376</x>

704+

<y>311</y>

687705

</hint>

688706

<hint type="destinationlabel">

689707

<x>308</x>

@@ -698,8 +716,8 @@

698716

<slot>moveDown()</slot>

699717

<hints>

700718

<hint type="sourcelabel">

701-

<x>519</x>

702-

<y>248</y>

719+

<x>487</x>

720+

<y>311</y>

703721

</hint>

704722

<hint type="destinationlabel">

705723

<x>308</x>

746764

<slot>fieldSelectionChanged()</slot>

747765

<hints>

748766

<hint type="sourcelabel">

749-

<x>324</x>

750-

<y>294</y>

767+

<x>335</x>

768+

<y>475</y>

751769

</hint>

752770

<hint type="destinationlabel">

753771

<x>324</x>

779797

<hints>

780798

<hint type="sourcelabel">

781799

<x>119</x>

782-

<y>253</y>

800+

<y>315</y>

783801

</hint>

784802

<hint type="destinationlabel">

785803

<x>647</x>

@@ -794,8 +812,8 @@

794812

<slot>moveTop()</slot>

795813

<hints>

796814

<hint type="sourcelabel">

797-

<x>207</x>

798-

<y>240</y>

815+

<x>283</x>

816+

<y>311</y>

799817

</hint>

800818

<hint type="destinationlabel">

801819

<x>202</x>

@@ -810,8 +828,8 @@

810828

<slot>moveBottom()</slot>

811829

<hints>

812830

<hint type="sourcelabel">

813-

<x>530</x>

814-

<y>246</y>

831+

<x>625</x>

832+

<y>311</y>

815833

</hint>

816834

<hint type="destinationlabel">

817835

<x>400</x>

@@ -826,15 +844,31 @@

826844

<slot>setOnConflict(QString)</slot>

827845

<hints>

828846

<hint type="sourcelabel">

829-

<x>371</x>

830-

<y>168</y>

847+

<x>516</x>

848+

<y>219</y>

831849

</hint>

832850

<hint type="destinationlabel">

833851

<x>490</x>

834852

<y>211</y>

835853

</hint>

836854

</hints>

837855

</connection>

856+

<connection>

857+

<sender>checkStrict</sender>

858+

<signal>toggled(bool)</signal>

859+

<receiver>EditTableDialog</receiver>

860+

<slot>setStrict(bool)</slot>

861+

<hints>

862+

<hint type="sourcelabel">

863+

<x>457</x>

864+

<y>177</y>

865+

</hint>

866+

<hint type="destinationlabel">

867+

<x>399</x>

868+

<y>299</y>

869+

</hint>

870+

</hints>

871+

</connection>

838872

</connections>

839873

<slots>

840874

<slot>fieldSelectionChanged()</slot>

@@ -851,5 +885,6 @@

851885

<slot>moveTop()</slot>

852886

<slot>moveBottom()</slot>

853887

<slot>setOnConflict(QString)</slot>

888+

<slot>setStrict(bool)</slot>

854889

</slots>

855890

</ui>