Hi,
I'm aware that you can use a macro substitution in a select statement when you don't know some value until runtime (like a fieldname). If there a similar function that can be used in a Locate?
I am developing a 'Search' on an accounts program where the user first selects a fieldname in which he looks for a value, maybe a 'Payee' fieldname or an 'Account' fieldname or a 'Deposit' fieldname. So the field on which to conduct the locate isn't known until runtime.
A usual locate might look like this:
if fdqA.Locate('Payee', cPayee ), []) then
ShowMessage('Located!')
else
ShowMessage('Failed!');
But the user might want to search on 'Account' or 'Deposit'.