(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › [Solved] Filters records from a set
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic [Solved] Filters records from a set (Read 4201 times)
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
[Solved] Filters records from a set
Dec 27th, 2007 at 9:33pm
Print Post Print Post  
Hello, 
I have read the documentation on @XResultSetForm but i m not sure how to use it.

..
I use
vRSHandle = @XResultSetSearch(@FN, "Kultur", SEARCH_MODE_AND, SEARCH_SYNTAX_QA, "!Kode=" + vTemp1 )
..
I would like, only few records from vRSHandle with other criterions filter. Does this go at all and can i use hier the
@XResultSetForm oder ?

Thanks for the  help.
« Last Edit: Jan 4th, 2008 at 2:43am by Hammer »  
Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re:  Filters records from a set using @XResul
Reply #1 - Dec 27th, 2007 at 9:41pm
Print Post Print Post  
Amor,

Your @XResultSetSearch as shown should get you only the records where Kode = vTemp1. What else did you need to do?
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re:  Filters records from a set using @XResul
Reply #2 - Dec 27th, 2007 at 11:27pm
Print Post Print Post  
Erika,
Using The  @XResultSetSearch i have a populated a Combobox Field: Combobox1 with the vTemp1.
when I select an article from this Combobox1 say: vTemp2.
i want to populate from that same  selection another Combobox2 with the (Kode = vTemp1 and Kode2 = vTemp2).
Also the content of the Combobax2 is dependent on the Selection from the combobox1..

Thanks.
  
Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re:  Filters records from a set using @XResul
Reply #3 - Dec 28th, 2007 at 1:53pm
Print Post Print Post  
You can use multiple criteria as shown below. Does that do it for you?

Code
Select All
vRSHandle = @XResultSetSearch(@FN, "Kultur", SEARCH_MODE_AND, SEARCH_SYNTAX_QA, "!Kode=" + vTemp1, "!Kode2=" + vTemp2)
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1350
Location: New Hampshire
Joined: Mar 11th, 2003
Re:  Filters records from a set using @XResul
Reply #4 - Dec 28th, 2007 at 2:15pm
Print Post Print Post  
It sounds like you want to make a selection in ComboBox1, then use that as criteria for the list in ComboBox2.

Building on Erika's suggestion, you might try something like this:
Code
Select All
vRSHandle = @XResultSetSearch(@FN, "Kultur", SEARCH_MODE_AND, SEARCH_SYNTAX_QA, "!Kode=" + ComboBox1, "!Kode2=" + vTemp2)
  

Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
WWW WWW  
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re:  Filters records from a set using @XResul
Reply #5 - Dec 29th, 2007 at 6:09pm
Print Post Print Post  
Erika and Carl,

I have done some programming changes and got it done.

Thank you so much 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