Forum Discussion
AlexKaras
Champion Level 3
Hi,
> Field 'CLAIM_PAY_DATE' not found
I assume that:
-- This is the SQL been executed:
Qry.SQL =' select count(distinct STORE_CODE) from aud_campaign_claims where CLAIM_PAY_DATE = "2021-02-16"';
-- And this line of code throws the error:
Log.Message(Qry.FieldByName(fieldName).Value);
If the above is correct then this is correct behavior because the result of your query does not contain CLAIM_PAY_DATE field but a count of records with distinct value for the STORE_CODE field.
You need to check (using some MySQL or another tool or using the code) how this field is named in the returned recordset and use this name to get the value.
Related Content
Recent Discussions
- 20 minutes agoSvetaG