dbTalk Databases Forums  

Help wanted: If - Else - End If // search solution

comp.databases.filemaker comp.databases.filemaker


Discuss Help wanted: If - Else - End If // search solution in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
leon.obers@iae.nl
 
Posts: n/a

Default Help wanted: If - Else - End If // search solution - 06-10-2005 , 04:07 PM







FM 7v3 - Windows


Just an easy solution for the FM goeroes I think,
but I am not. Can somebody give the right script steps
in the FM language.

I want to make a script that does the following:

=============================
Set Error Capture [on]
Find Records table::Field-A [!]
If
a search brings no valid records,
go to layout A
Else
go to layout B
Endif
=============================

The difficult part for me is if there is a function that do give the
number of found records (I can not find). If found records = 0
than the above trick can be made easy.


Regards, Leon Obers


Reply With Quote
  #2  
Old   
42
 
Posts: n/a

Default Re: Help wanted: If - Else - End If // search solution - 06-10-2005 , 04:19 PM






In article <1118437653.274487.257720 (AT) z14g2000cwz (DOT) googlegroups.com>,
leon.obers (AT) iae (DOT) nl says...
Quote:
FM 7v3 - Windows


Just an easy solution for the FM goeroes I think,
but I am not. Can somebody give the right script steps
in the FM language.

I want to make a script that does the following:

=============================
Set Error Capture [on]
Find Records table::Field-A [!]
If
a search brings no valid records,
go to layout A
Else
go to layout B
Endif
=============================

The difficult part for me is if there is a function that do give the
number of found records (I can not find). If found records = 0
than the above trick can be made easy.


Regards, Leon Obers


Status(CurrentFoundCount)



Reply With Quote
  #3  
Old   
Lynn allen
 
Posts: n/a

Default Re: Help wanted: If - Else - End If // search solution - 06-10-2005 , 04:24 PM



<leon.obers (AT) iae (DOT) nl> wrote:

Quote:
FM 7v3 - Windows


Just an easy solution for the FM goeroes I think,
but I am not. Can somebody give the right script steps
in the FM language.

I want to make a script that does the following:

=============================
Set Error Capture [on]
Find Records table::Field-A [!]
If
a search brings no valid records,
go to layout A
Else
go to layout B
Endif
=============================

The difficult part for me is if there is a function that do give the
number of found records (I can not find). If found records = 0
than the above trick can be made easy.
You need to search in the Help under Status functions (for FM6) or Get
functions for FM 7.

Status(CurrentFoundCount)

or

Get(FoundCount)

The lists of those functions in the Help index are extremely useful. I
refer to them all the time.

Lynn Allen
--
Allen & Allen Semiotics www.semiotics.com
FSA Associate Filemaker Design & Consulting


Reply With Quote
  #4  
Old   
Helpful Harry
 
Posts: n/a

Default Re: Help wanted: If - Else - End If // search solution - 06-10-2005 , 05:48 PM



In article <1gxy2cz.1lnqiqh51py8N%lynn (AT) NOT-semiotics (DOT) com>,
lynn (AT) NOT-semiotics (DOT) com (Lynn allen) wrote:

Quote:
leon.obers (AT) iae (DOT) nl> wrote:

FM 7v3 - Windows


Just an easy solution for the FM goeroes I think,
but I am not. Can somebody give the right script steps
in the FM language.

I want to make a script that does the following:

=============================
Set Error Capture [on]
Find Records table::Field-A [!]
If
a search brings no valid records,
go to layout A
Else
go to layout B
Endif
=============================

The difficult part for me is if there is a function that do give the
number of found records (I can not find). If found records = 0
than the above trick can be made easy.

You need to search in the Help under Status functions (for FM6) or Get
functions for FM 7.

Status(CurrentFoundCount)

or

Get(FoundCount)

The lists of those functions in the Help index are extremely useful. I
refer to them all the time.
Another set of functions that are often overlooked (although less
useful) are the "Design Functions" that allow you to fdo things like
obtain a list of fields on a particular layout, or the values from a
value list, etc.



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)


Reply With Quote
  #5  
Old   
Léon Obers
 
Posts: n/a

Default Re: Help wanted: If - Else - End If // search solution - 06-11-2005 , 08:21 AM



Thanks to you, 42 and Harry,


Works great. Have made an extensive user GUI with many automatic look-up
functions.


Lynn allen wrote:
Quote:
Status(CurrentFoundCount)

or

Get(FoundCount)

The lists of those functions in the Help index are extremely useful. I
refer to them all the time.
I am using a different base language (Dutch). Sometimes translation of
functions within the typical FM script basics, I am not as familiar with
it (yet), and you can overlook functions very easily. Also I have to get
used to the way of the FM script method of approach. The more you work
in it, the more familiar. It brings many possibities and that makes fun.

Well, till the next time (I guess working on further and developing a
database shall bring more questions).




--
Vr.groet - regards, Léon Obers

Reacties per mail, vervang "invalid" door "cc" in het adres.
Reactions by mail, exchange "invalid" by "cc" within address.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.