Lantica User Forum - Empty date fields in retrieve spec

(UTC)

Lantica User Forum › Archived Topics › Archived Topics › Empty date fields in retrieve spec

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Pages: 1

Empty date fields in retrieve spec (Read 6771 times)

addison1 Member Offline No personal text Posts: 43 Joined: Aug 1^st, 2004	Empty date fields in retrieve spec Jan 25^th, 2005 at 1:51am	Print Post
	I want to find the records for those customers who haven't paid. This happens from a command button and I want to pre program the on retrieve spec event I can accomplish this if I make the Paydate element text type and program the retrieve spec; Paydate = "=". I'd like to leave the element a date type but I can't figure out how to program the retrieve spec. Any Ideas out there?


	IP Logged

BOBSCOTT Senior Member Members Offline That Darn Computer #$X# {curse words} Posts: 1195 Joined: Nov 22^nd, 2002	Re: Empty date fields in retrieve spec Reply #1 - Jan 25^th, 2005 at 2:37pm	Print Post
	I would leave your element a date and use @Isblank See page 22 of supplement 1.1

	Team � Together Everyone Achieves More
	IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2480 Joined: Aug 20^th, 2003	Re: Empty date fields in retrieve spec Reply #2 - Jan 25^th, 2005 at 2:45pm	Print Post
	You can also use FormFieldValue in the Retrieve spec open event. FormFieldValue("Main Form", "Date_entered", 1, "=") Pg. 151 of the Programming manual. -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

addison1 Member Offline No personal text Posts: 43 Joined: Aug 1^st, 2004	Re: Empty date fields in retrieve spec Reply #3 - Jan 26^th, 2005 at 10:43pm	Print Post
	Ray wins!!! Thanks Bob, I just can't figure out the @isblank syntax. I'm sure it's just me. Thanks


	IP Logged

Carl Underwood Senior Member Members Offline Posts: 1350 Location: New Hampshire Joined: Mar 11^th, 2003	Re: Empty date fields in retrieve spec Reply #4 - Jan 28^th, 2005 at 3:31am	Print Post
	Quote: You can also use FormFieldValue in the Retrieve spec open event. FormFieldValue("Main Form", "Date_entered", 1, "=") In light of the following excerpt from the 1.1 supplement, would it make any difference if a "0" was used for the instance value? "A change to @FormFieldValue: When used with a record instance of 0 this function now returns the value from whatever record in the subform happens to be the current record." EDIT: BTW, didn't it work that way before 1.1? If not, what did zero do before?

	Carl Underwood CDU Computer Consulting LLC Epsom, New Hampshire
	WWW IP Logged

addison1 Member Offline No personal text Posts: 43 Joined: Aug 1^st, 2004	Re: Empty date fields in retrieve spec Reply #5 - Jan 29^th, 2005 at 5:55pm	Print Post
	I'm using 0, I don't have any sub forms, it runs fine.


	IP Logged

Pages: 1

‹ Previous Topic | Next Topic ›