(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Programming Retrieval Specs
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Programming Retrieval Specs (Read 488 times)
NICEBERG
Full Member
Members
***
Offline


I came, I saw, I'm still
trying to figure it out!

Posts: 208
Location: Green Bay, WI
Joined: Dec 17th, 2003
Programming Retrieval Specs
Jul 7th, 2006 at 5:37pm
Print Post Print Post  
I have a command button that is supposed to automatically fill in two fileds with retrieve criteria and @SelectTreeItem to F10 results. The fields are Skills and Closed (date formatted).

Retrieve criteria in programming statement:
Skills = "mech;both"
Closed = "=" (all records that have this field blank)

The Skills field returns the desired results. The Closed field returns: 0000/00/00.
If I reprogram Closed = ""="" it returns: 0001/01/01

I think I remember something about slashes being needed in this situation, but I can't seem to find in in the backlog of topics.

Thanks for any help,
Fred
  
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: Programming Retrieval Specs
Reply #1 - Jul 7th, 2006 at 5:46pm
Print Post Print Post  
Hello Fred,

You have to use FormFieldValue to fill in the Closed element on the retrieve spec.

Ex:
Code
Select All
FormFieldValue("FormName", "Closed", -1, "=")


Replace FormName with the name of your form.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
NICEBERG
Full Member
Members
***
Offline


I came, I saw, I'm still
trying to figure it out!

Posts: 208
Location: Green Bay, WI
Joined: Dec 17th, 2003
Re: Programming Retrieval Specs
Reply #2 - Jul 7th, 2006 at 6:08pm
Print Post Print Post  
Sweeeet...

Thanks Ray - again!!
  
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: Programming Retrieval Specs
Reply #3 - Jul 7th, 2006 at 6:17pm
Print Post Print Post  
You are welcome Fred.

-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