Home » Forums » DBManager General
 
Error in 'Order By' processing (1722 previews)
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
Error in 'Order By' processing (1722 previews)
Legends

Topic has Replies
Topic With no Replies
 
Home » Forums » DBManager General