solved - changed "!PriceOrMargin<>" + vQ to "!PriceOrMargin=/Q" and it worked swimmingly.
If I preview this in designer, it works perfectly - excluding the Q pricing records for that client. But when I reconcile and run, it doesn't exclude the "Q" Pricing records for that client, pulling up all pricing records for the client. Where is my code off?
If @Mode() = 0 and @IsBlank(ItemNum) { vClientID = @FormFieldValue("Orders", "ClientID", 0) vClientID = @Left(vClientID,4) vQ = "Q" vRS8 = @XResultSetSearch(@FN, "Pricing", SEARCH_MODE_AND, SEARCH_SYNTAX_QA, "!ClientID=" + vClientID, "!PriceOrMargin<>" + vQ) XResultSetSort(vRS8, "ItemDesc") If vRS8 > -1 { vCount = @XResultSetTotal(vRS8) If vCount > 0 { vList = "" For vLoop = 1 To vCount XResultSetCurrentPosition(vRS8, vLoop) vLine = @XResultSetValue(vRS8, "ItemDesc") + " ~ " + @XResultSetValue(vRS8, "ItemNum") vList = vList + vLine + ";" Next vList = @ReplLas(vList, ";", "") vList = @SortStringArray(vList, 0) PopupSelectPosition(4, @Xpos(ItemDesc)+60, @Ypos(ItemDesc)-60) vChoice = @PopupChoiceList(vList, "SELECT A Price Record for this client___________________") If vChoice <> "" { vChoice = @Mid(vChoice, @Instr(vChoice, "~") + 1, 500) ItemNum = vChoice ThrowFocus(ItemNum) } } } XResultSetClose(vRS8) vList = "" }
|