Subject Re: Data module with a complex index From Robbie Nott <robnott@mweb.co.za> Date Fri, 6 Dec 2019 22:30:47 +0200 Newsgroups dbase.getting-started Hi Akshat Many thanks for your help Show Cat Ring It's the query on the Ring table that has me confused... I'm hoping to use the cool "params" that you so kindly taught me in the data module. Just not sure how to get these into the query because they come from the other 2 tables FormRef.qRing.Sql = "Select * from Ring where ShowNo = :nShowNo and CatNo = :nCatNo order by RingNo" FormRef.qRing.Params["nShowNo"] = FormRef.qShow.Fields["ShowNo"].Value FormRef.qRing.Params["nCatNo"] = FormRef.qCat.Fields["CatNo"].Value Thanks for your assistance :-) > > This is just a thought in addition ot Mervyn's reply. > > A simple question, Will the index order be changed during execution of > the form, or you will be using the same index. > > If you are using the same index throughout then I will suggest use of > ORDER BY clause of SQL. > > This has the advantage of not requiring an .mdx file so fewer chances of > corruption / out of date indexes etc. > > but also suffers from certain drawbacks like rowset could be readonly > and you will not be able to change the index order without changing the > sql statement. > > So plan well before proceeding in this direction. > Regards > Akshat