(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › SEARCH_MODE_AND,SEARCH_SYNTAX_QA
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic SEARCH_MODE_AND,SEARCH_SYNTAX_QA (Read 10748 times)
NHUser
Full Member
***
Offline



Posts: 320
Location: Amherst, NH
Joined: Aug 2nd, 2010
SEARCH_MODE_AND,SEARCH_SYNTAX_QA
Jan 27th, 2020 at 9:05pm
Print Post Print Post  
I have some programming that I'm using successfully in one area.

The programming is below:

     vHandle=@xResultSetSearch(@FN,"ProSam", SEARCH_MODE_AND,SEARCH_SYNTAX_QA, "!DC#="+vDCNo+"..")

This looks for any match to my DC#, which is fine for now but my new goal is to search for any match to the DC# AND to select only those orders where another element "DateShipped" is empty.

How do i add that requirement?

Thanks for your help!

NH User
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: SEARCH_MODE_AND,SEARCH_SYNTAX_QA
Reply #1 - Jan 27th, 2020 at 9:11pm
Print Post Print Post  
Hello,

Code
Select All
 vHandle=@xResultSetSearch(@FN,"ProSam", SEARCH_MODE_AND,SEARCH_SYNTAX_QA, "!DC#="+vDCNo+"..", "!DateShipped==")


=Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge