|
Error in 'Order By' processing |
Posted in 30th, 12/2005 03:36 by chill  |
Using Version 3.2.1 DBManagerPRO Enterprise Ed.(Registered)
Database SQLite(2.8)
SELECT
[tbl_cost_modelid],SUM([cost])
FROM
[tbl_cost_model_expense_category]
GROUP BY
[tbl_cost_model_expense_category].[tbl_cost_modelid]
Executing Query. Wait ...
Query 'Untitled' Statistics (Time: 00:00:00, Records: 1, Fields: 2)
Query Successfull. Returned 1 records.
SQLite Error:
near "GROUP": syntax error
QUERY:
GROUP BY
[tbl_cost_model_expense_category].[tbl_cost_modelid]
This works perfectly fine in everything other than this tool.
Bug?
Cameron / |
Re: Error in |
Posted in 30th, 12/2005 08:59 by support  |
Hi,
Query Designer mount sql statement with blank line before GROUP BY clause. We fix it soon.
Best Regards
Support / DBTools Software |
Re: Error in |
Posted in 06th, 01/2006 02:00 by chill  |
support wrote:
Hi,
Query Designer mount sql statement with blank line before GROUP BY clause. We fix it soon.
Best Regards
Support / DBTools Software
Any idea of the timeframe on this? Cameron / |
Re: Error in |
Posted in 06th, 01/2006 03:14 by support  |
Hi,
Probably in the next month, since we are planning to add a few new features. Also we are working on the existent code in order to make it simpler, more stable and faster.
As this is not a serious bug we won't release a bug fix just for this case, but the fix will be present in the next release, definitelly.
best Regards,
Support / DBTools Software |
Legends
Topic has Replies
Topic With no Replies
|
|
|