(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › @SpecCommand question
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic @SpecCommand question (Read 682 times)
BOBSCOTT
Senior Member
Members
*****
Offline


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
@SpecCommand question
Feb 18th, 2016 at 7:21pm
Print Post Print Post  
Is there an @error type command that shows when nothing is returned when using
@SpecCommand(SPEC_OPERATION_RUN, SPEC_TYPE_RETRIEVE, "")

or is just checking @ResultSetTotal()  before and after the way to do that?

Thanks
     
  
Team – Together Everyone Achieves More
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2487
Joined: Aug 20th, 2003
Re: @SpecCommand question
Reply #1 - Feb 19th, 2016 at 3:53pm
Print Post Print Post  
Hello Robert,

@Error is not set as the @SpecCommand() executed correctly, the spec just didn't return records.

You can also check @Mode(). If you are still in search mode(2) after the @SpecCommand() runs, you know there was either a syntax error with the retrieve or no records matched the retrieve criteria.

-Ray
« Last Edit: Feb 19th, 2016 at 5:52pm by Ray the Reaper »  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
BOBSCOTT
Senior Member
Members
*****
Offline


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
Re: @SpecCommand question
Reply #2 - Feb 19th, 2016 at 6:14pm
Print Post Print Post  
Thanks Ray, that was the simple solution I was overlooking.

I was using @ResultSetTotal() to compare before and after making for a bit of a convoluted method.

Thanks Again
  
Team – Together Everyone Achieves More
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