Hi
I am trying to index a calculated field but to no success.
To be exact. I am returning a Day [Day(log:DOB] from a (DOB) ‘Date of birth’ field..
How can I create an index using this “day” field?
Thanking You in advance
Hi
I am trying to index a calculated field but to no success.
To be exact. I am returning a Day [Day(log:DOB] from a (DOB) ‘Date of birth’ field..
How can I create an index using this “day” field?
Thanking You in advance
Is this a Clarion question or a database question? And if it is a database question, which database?
if I am understanding you properly you will have a Day field in your table and a trigger in the dct on add and change to calculate it “Day(log:DOB)”
then just have your key on the day field.
If you are using a database, as Jon asks, presumably it would be different and you wouldn’t need the client-side trigger.
cheers
Geoff R