Appreciate the help, thanks for the link to the documentation.
While the documentation was somewhat useful - I found the applicable section of "Rules for a particular field" to be too case specific and too cryptic to be an answer in itself.
Providing an example would have clarified what the documentation was trying to say, would have helped resolve my issue and saved some frustration.
I finally figured it by hunting through the forum for users having similar issues.
Here'e the solution in case anyone else runs into similar issues.
In the code example below Contact
is the name of my concatenated field.
Code: Select all
LiteQuery1.SQL.Text := sSQLtextString;