Normal Topic @XresultSetSearch parameter (solved) (Read 293 times)
lksseven
Full Member
***
Offline



Posts: 416
Location: Southwest
Joined: Jan 26th, 2009
@XresultSetSearch parameter (solved)
Jun 13th, 2009 at 12:14am
Print Post Print Post  
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 = ""
   }
« Last Edit: Jun 13th, 2009 at 3:05pm by lksseven »  

Larry
Back to top
IP Logged