Subject Re: MDX tags and sql builder From Rouke Bakker <moc.liamg@rekkabrg> Date Sun, 08 Dec 2024 03:01:15 -0500 Newsgroups dbase.getting-started Thanks Mervyn, It looks like a complex process for something that was once so simple. But I guess it adds functionality that we didn't have with the mdx tags. Mervyn Bick Wrote: > 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.