I use now if qryTransactions.Locate('fldyear', 2012, []) then to locate a record and making it the active one.
But I now would like to use 2 fields and 2 values like fldyear = 2012 and fldmonth = 43
Is that possible?
I have been spending a couple of hours with no result
.Locate using 2 fields and 2 values
Re: .Locate using 2 fields and 2 values
Hallo,
Like for any TDataSet you will need to use:
qryTransactions.Locate('fldyear;fldmonth', VarArrayOf([2012, 43]), [])
Best Regards,
Cristian Peta
Like for any TDataSet you will need to use:
qryTransactions.Locate('fldyear;fldmonth', VarArrayOf([2012, 43]), [])
Best Regards,
Cristian Peta
Re: .Locate using 2 fields and 2 values
Thanks - that was what I was looking for.