[KEXI] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 Jarosław Staniek changed: What|Removed |Added Target Milestone|3.2 |3.2.1 -- You are receiving this mail

[KEXI] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 Jarosław Staniek changed: What|Removed |Added Attachment #105422|0 |1 is obsolete|

[KEXI] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 Jarosław Staniek changed: What|Removed |Added Ever confirmed|0 |1 Status|REPORTED

[KEXI] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 Jarosław Staniek changed: What|Removed |Added Target Milestone|3.1 |3.2 -- You are receiving this mail

[KEXI] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 --- Comment #18 from Jarosław Staniek --- Thanks Andrew and Ian. As you know 15 or 30 days is very small period. Many distributions refuse to update even in 2 years... Most users are unable to build the software themselves. Here I think we know a

[KEXI] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 Andrew Crouthamel changed: What|Removed |Added CC||andrew.crouthamel@kdemail.n

[KEXI] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 Andrew Crouthamel changed: What|Removed |Added Keywords||triaged --- Comment #16 from Andrew

[KEXI] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 Jarosław Staniek changed: What|Removed |Added Depends on||394914 Referenced Bugs:

[kexi] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 Jarosław Staniek changed: What|Removed |Added Target Milestone|3.0.2 |3.1 -- You are receiving

[kexi] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 --- Comment #15 from Ian Whitfield --- Created attachment 105558 --> https://bugs.kde.org/attachment.cgi?id=105558=edit No Zeros in Report -- You are receiving this mail because: You are watching all bug changes.

[kexi] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 --- Comment #14 from Ian Whitfield --- Created attachment 105557 --> https://bugs.kde.org/attachment.cgi?id=105557=edit No Zero shows in Table and Query -- You are receiving this mail because: You are watching all bug

[kexi] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 --- Comment #13 from Jarosław Staniek --- @Ian please post the questions on the Forum because these are not related to this bug. -- You are receiving this mail because: You are watching all bug changes.

[kexi] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 --- Comment #12 from Jarosław Staniek --- Ian, correct. Integers have the same behavior that I explained above. Some or all of your fields have default values set to NULL even if you see 0 in the table designer. You can use workaround

[kexi] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 --- Comment #11 from Ian Whitfield --- Created attachment 105422 --> https://bugs.kde.org/attachment.cgi?id=105422=edit FS Sig.png -- You are receiving this mail because: You are watching all bug changes.

[kexi] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 --- Comment #10 from Ian Whitfield --- Hi Jaroslaw On 05/09/2017 02:57 AM, Jarosław Staniek wrote: > https://bugs.kde.org/show_bug.cgi?id=379306 > > Jarosław Staniek changed: > > What|Removed

[kexi] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 --- Comment #9 from Ian Whitfield --- Have tried this - All 6 Table fields are set as "Integer Number" All Fields in the Report are set with default value '0' NO CHANGE - No '0' values show in Queries or Report. Entering a '0'

[kexi] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 Jarosław Staniek changed: What|Removed |Added Severity|major |normal Target

[kexi] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 Jarosław Staniek changed: What|Removed |Added Status|UNCONFIRMED |NEEDSINFO

[kexi] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 --- Comment #6 from Jarosław Staniek --- Created attachment 105403 --> https://bugs.kde.org/attachment.cgi?id=105403=edit Fix Apparent issue users may have is different then: by default the default value is 0.0. It is displayed as 0

[kexi] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 --- Comment #5 from Jarosław Staniek --- Created attachment 105402 --> https://bugs.kde.org/attachment.cgi?id=105402=edit Report Create report based on the table. Two first records are NULL so the value is not displayed. Then there

[kexi] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 --- Comment #4 from Jarosław Staniek --- Created attachment 105401 --> https://bugs.kde.org/attachment.cgi?id=105401=edit Data Enter data: 1, NULL 2, NULL 3, 1 4, 0 -- You are receiving this mail because: You are watching all bug

[kexi] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 --- Comment #3 from Jarosław Staniek --- Created attachment 105400 --> https://bugs.kde.org/attachment.cgi?id=105400=edit Table design Table design: insert one field with floating point type, don't change the 'Default value'

[kexi] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 Simon Andric changed: What|Removed |Added CC||simonandr...@gmail.com

[kexi] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 --- Comment #2 from Adam Pigg --- I just tested this on the usda database, which has a table nut_data with several floating point fields. It worked fine, no blanks were shown where the values were 0. A small test case would be

[kexi] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 --- Comment #1 from Adam Pigg --- Can you attach an example? -- You are receiving this mail because: You are watching all bug changes.

[kexi] [Bug 379306] Zero values not showing up

https://bugs.kde.org/show_bug.cgi?id=379306 Jarosław Staniek changed: What|Removed |Added Summary|ZERO VALUES NOT SHOWING UP |Zero values not showing up