Subject Re: MDX tags and sql builder From Mervyn Bick <invalid@invalid.invalid> Date Sun, 8 Dec 2024 11:47:32 +0200 Newsgroups dbase.getting-started On 2024/12/08 10:01, Rouke Bakker wrote: > 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. Setting a unique index in XDML creates a rowset which includes all the fields in the rowset from the table but it includes only the first record where the key expression finds a match. I've been using dBASE for over 40 years and I've never needed to access any field in a table with a unique index set except for the field in the key expression.  All the other fields in the table are redundant. If you're not  going to use any of the other fields in a rowset then there is no point in going to a LOT of trouble to include them when using SQL. This means that a rowset created by    select distinct surname from whatever would give exactly the same functionality as the rowset created by setting the following index   index on surname tag surname1 unique Mervyn.