Subject Re: MDX tags and sql builder From Mervyn Bick <invalid@invalid.invalid> Date Tue, 3 Dec 2024 12:47:22 +0200 Newsgroups dbase.getting-started On 2024/12/03 11:56, Mervyn Bick wrote:   > For the second .sql file do exactly the same.  After you have saved > the .sql file open it in the Sourcecode editor and add DISTINCT > immediately after SELECT. The rowset produced by the first .sql will be editable provided there is only one field in the ORDER BY clause and there is a simple index in the MDX file on that one field. Do NOT set the indexName property of a query where an ORDER BY clause is active.  The BDE will find the simple index and make the query's rowset editable. The rowset produced by the .sql file with DISTINCT in the select statement is not editable. Mervyn.