(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › XResultSetSearch and Blank Text-Field
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic XResultSetSearch and Blank Text-Field (Read 900 times)
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
XResultSetSearch and Blank Text-Field
May 14th, 2013 at 1:24pm
Print Post Print Post  
Hello!
I would like to search for records with empty completed-Textfield. Unfortunately this didn't work
Here is my code:
vRSID = @XResultSetSearch( @FN, "Patient", 1, 2, "!completed==" )

thank you for the help.
  
Dr. med. Amor Belhareth&&Medizin Labor &&Germany
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: XResultSetSearch and Blank Text-Field
Reply #1 - May 14th, 2013 at 8:12pm
Print Post Print Post  
Hello Amor,

That should work for you, although you may want to use the Search Mode of 0 which is And instead of 1 which is Or. but either one works for me in test cases.

What is the value of vRSID?
What is the value of @XResultSetTotal(vRSID)?

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: XResultSetSearch and Blank Text-Field
Reply #2 - May 14th, 2013 at 8:16pm
Print Post Print Post  
I tried it with both AND and OR, and both worked fine using a blank field in Customers.db.

Amor, are you sure you have the field name, not the element name?
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: XResultSetSearch and Blank Text-Field
Reply #3 - May 29th, 2013 at 11:13am
Print Post Print Post  
Hallo Ray,
i´m sorry my Code is:
vRSID = @XResultSetSearch( @FN, "Patient", 1, 2, "!Betrag=/=","!completed==" )

Using the 0 (and) it works fine.

thank you for the help.
  
Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
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