Normal Topic Search in the Subform (Read 1171 times)
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Search in the Subform
Jun 23rd, 2011 at 8:06pm
Print Post Print Post  
Hello!

i want to use {FormFieldValue("Leistungen", "Kode", 1, "/=")} as retrieve in the main Form.
is that correct?

"Leistungen" is the subform.

Danke.
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Search in the Subform
Reply #1 - Jun 23rd, 2011 at 8:38pm
Print Post Print Post  
Hello Amor,

The problem that you are running into is that a programmed retrieve spec can not use FormFieldValue() cause it runs on the engine there there is no form. Programmed retrieve specs are against the database.

If you explain some more on what you are trying to accomplish I may be able to present a route that will work. Is there a reason that /= can't just be entered in the Kode element on the Leistungen form?

-Ray
  

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


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: Search in the Subform
Reply #2 - Jun 23rd, 2011 at 9:14pm
Print Post Print Post  
Hello Ray-

Yes , /= canīt be entered in the Kode element on the Leistungen Subform because  the Kode element is formatted invisible.


I want to set up by a stored Search all Records in the Main Form with no Subrecords in "Leistungen" Subform.



Thanks.
« Last Edit: Jun 24th, 2011 at 9:18am by Amor »  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Search in the Subform
Reply #3 - Jun 24th, 2011 at 2:39pm
Print Post Print Post  
Hello Amor,

You can accomplish that by doing the following.

Make the Kode element on the subform visible in Sesame Designer
Reconcile to the DB file
Open Search/Update on the main form
Click in the subform and type /= in the Kode element
Save the Retrieve Spec
Close Sesame
Make the Kode element on the subform invisible in Sesame Designer
Reconcile the DB file

Even though the Kode element is now invisible whenever the Retrieve Spec is loaded it will be filled in with /=. Now since it is invisible it could pose a problem where the user returns to search, Since they can't see the Kode element to know it has retrieve criteria in it. Pressing F3 will clear out the retrieve criteria.

-Ray
  

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


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: Search in the Subform
Reply #4 - Jun 24th, 2011 at 6:40pm
Print Post Print Post  
Thank you Ray.
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged