>There is an index on TableFormProperties.TableName, but the date is in mixed case, so I can't do a SEEK (or can I?). I'm doing this in a LOCATE, but that seems a bit wrong somehow. Is this the right way to do it, or is there a better way.
>
>lcTableName = "MyTableName"
>SELECT TableFormProperties
>LOCATE FOR ALLTRIM(UPPER(TableName) = ALLTRIM(UPPER(lcTableName))
>
It's correct except for the typo.
LOCATE FOR ALLTRIM(UPPER(TableName)
) = ALLTRIM(UPPER(lcTableName))
Either this or
LOCATE FOR UPPER(TableName) = PADR(ALLTRIM(UPPER(lcTableName)),LEN(TableName))
If it's not broken, fix it until it is.
My Blog