||Re: Data module with a complex index
Robbie Nott <firstname.lastname@example.org>
||Fri, 6 Dec 2019 22:30:47 +0200
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
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.