Subject Re: Data module with a complex index
From Robbie Nott <>
Date Fri, 6 Dec 2019 22:30:47 +0200
Newsgroups dbase.getting-started

Hi Akshat
Many thanks for your help


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