I want to GENERATE a composite key in code as I search through my files in code.
I'm not BUILDING the contents of a composite key, that's simple. I want a brand new one, on the fly, based on two values in the same table that I select. In essence, I want to HReadSeek() on two values without making a composite key in the HFSQL analysis. That way, I can modify the members of a composite key willy-nilly, without creating 2^n additional fields in my tables. That would be ridiculous.
Is this possible? Thanks!
HReadSeek(TableName, NewComposKeyName, ["FirstName", "LastName"])