Normal Topic sBasic to remove duplicate from Resultset (Read 571 times)
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
sBasic to remove duplicate from Resultset
Apr 19th, 2013 at 7:08pm
Print Post Print Post  
I am currently doing this ( removing duplicate from Resultset  ) by opening up the command tree and selecting the Element in the Spec Window and then use Remove Duplicate from the resultset command. Is there an easy way to do that, such as putting sBasic routine and commands in the command button?
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: sBasic to remove duplicate from Resultset
Reply #1 - Apr 19th, 2013 at 8:58pm
Print Post Print Post  
Hello Bharat,

Is it always the same element? If it is, you can set it up as a saved duplicate spec and then use the SBasic commands @LoadDuplicateSpec() and RunDuplicateSpec().

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: sBasic to remove duplicate from Resultset
Reply #2 - Apr 19th, 2013 at 10:09pm
Print Post Print Post  
Hi Ray,
Yes, it is the same element always. So, I will try the method you suggested. Thanks.
  
Back to top
 
IP Logged