🚀 go-pugleaf

the Current method for converting a Lookup result into an AnsiString is to
use the following code

(Long Version:)
Variant Result = tblADOTable->Lookup("Field1", iValue, "ReturnField");
if(Result.Type() != varNull && Result.Type() != varEmpty)
  AnsiString asString = Result.AsType(varString);
else
  AnsiStirng asString = "";


This is somewhat tedious especially if you are performing lookups on
multiple tables.
I have in the past used a TKADaoTable which was able to perform exactly the
same result but using the following single line:

(Short Version:)
AnsiString Result = tblKADOTable->Lookup("Field1", iValue,
"ReturnField").VOleStr;

This would return with either a blank ("") Result if the record's
ResultField was blank or it would return the value held within the
ResultField.


if I use the same code (ShortVersion) on a TADOTable, if the ResultField was
empty, the Lookup result would return random crap.  Is there a way of
ensuring the return value of a Lookup will return valid information or NO
information at all if the field is empty WITHOUT having to resort to using
the Long Version.

Thanks