select sum (field) gives "the query is incorrect"

Board index

Page 1 of 1 (6 posts)

Tags:

ptijoz Registered Member Posts 43 Karma 0 OS	select sum (field) gives "the query is incorrect" Mon Jan 28, 2019 9:24 pm select sum (field) from table the sum function does not seem to work. Is this normal? if so, is it planned to implement it? Regards Lubuntu 18.10 - 64 bit Kexi 3.1.0
jstaniek Moderator Posts 1027 Karma 2 OS	Re: select sum (field) gives "the query is incorrect" Mon Jan 28, 2019 10:01 pm Yes ptijoz, The wish is reported here: https://bugs.kde.org/show_bug.cgi?id=195360 Long ago but depending on support it's possible Best regards, Jarosław Staniek • Qt Certified Specialist • KEXI - Open Source Visual DB Apps Builder • Request a feature or fix for KEXI here • May I help you? Please mention your app's version and OS when asking for help
ptijoz Registered Member Posts 43 Karma 0 OS	Re: select sum (field) gives "the query is incorrect" Tue Jan 29, 2019 8:41 am jstaniek wrote:Yes ptijoz, The wish is reported here: https://bugs.kde.org/show_bug.cgi?id=195360 Long ago but depending on support it's possible Yes it is too very long... and it' s an essential implementation for SQL programming
jstaniek Moderator Posts 1027 Karma 2 OS	Re: select sum (field) gives "the query is incorrect" Wed Jan 30, 2019 1:28 pm That's true, it looks like the next change for our SQL support. Best regards, Jarosław Staniek • Qt Certified Specialist • KEXI - Open Source Visual DB Apps Builder • Request a feature or fix for KEXI here • May I help you? Please mention your app's version and OS when asking for help
ptijoz Registered Member Posts 43 Karma 0 OS	Re: select sum (field) gives "the query is incorrect" Thu Mar 24, 2022 2:40 pm still no news for this? it's really disheartening...
jstaniek Moderator Posts 1027 Karma 2 OS	Re: select sum (field) gives "the query is incorrect" Thu Mar 24, 2022 3:06 pm Unfortunately. Not only sums but also some grouping would be needed. We have it all implemented but currently only for reports. Best regards, Jarosław Staniek • Qt Certified Specialist • KEXI - Open Source Visual DB Apps Builder • Request a feature or fix for KEXI here • May I help you? Please mention your app's version and OS when asking for help