When I do this, it successfully returns all the records in formula.db...

vFileName = "Z:\Sesame\Data\ICD\Formula.db"
vkey = @XResultSetSearch(vFileName, "Databaseula", SEARCH_MODE_AND, SEARCH_SYNTAX_QA, "!Formula0=..") 

But this code returns no results...

vFormula = Formula
vFileName = "Z:\Sesame\Data\ICD\Formula.db"
vFormulaList = @XLookupSourceListAll(vFileName, "vFormula", vFormula, "Formula0,Description") 

I have tried replacing variables with hard-coded values to no avail. What am I missing?

In addition to what Erika said;

Your second argument is your key value used for matching unless you are searching for the literal value of "vFormula", you do not want quotes around it.

The third argument is the external element name. This either needs to be in quotes or have a variable that evaluates to the element name. Looking at your previous code, you want "Formula0" in this spot.

vFormula = Formula
vFileName = "Z:\Sesame\Data\ICD\Formula.db"
vFormulaList = @XLookupSourceListAll(vFileName, vFormula, "Formula0", "Formula0;Description") 

Also one thing to note is the XLookup family of commands are Form based commands so they use the ELEMENT names where as the XResultSet family of commands are Database based commands so they use the underlying FIELD names. So if the above does not work, make sure you are using the ELEMENT names and not the FIELD names.

-Ray

Rod Weston wrote on Sep 20^th, 2016 at 4:50pm:


Oh, you so do want those problems. As a coder, I pray for my bugs to be stupid syntax issues that can be easily fixed.