« Return to Thread: Re: method to assign values to a field

Re: method to assign values to a field

by Gilliam Johnston :: Rate this Message:

Reply to Author | View in Thread


I continue to try to teach myself 4D. The following project method selects the records I want and puts them in order, but it does not do the next step: loop through the selection and assign "True" to the boolean field "LastVisit." Any suggestions would be appreciated.

ALL RECORDS([ProgNotes])
QUERY([ProgNotes];[ProgNotes]DOS>Current date-90)
ORDER BY([ProgNotes];[Patients]NameLast;[Patients]NameFirst;[ProgNotes]DOS;<)
For ($vlRecord;1;Records in selection([ProgNotes]))
MODIFY RECORD([ProgNotes];*)LastVisit:=True
ACCEPT
NEXT RECORD([ProgNotes])
End for


**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

An all-new List box. More features, more power.
Headers, footers, cell formatting and other goodies.
See it here first! <http://www.4d.com/livedemos>

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************


 « Return to Thread: Re: method to assign values to a field