FM 7 Mac OS X
In my customer database I'm trying to set up a script that either use
the name enterered in a global text field to make a new record or do a
find for similar records. The first works well, but I'm not able to get
the global value into the find request. I've tried Go to field, Set
field, Insert text and calculated result, Copy and Paste, Perform
another script, but it seems that the value in the global field not is
present before after Perform find.
I would be very pleased to come further with this one.
--
Rgds Helge Hafstad
helge.hafstad@mac.com
Bergen - Norway
|
|
0
|
|
|
|
Reply
|
helgehd (2)
|
3/3/2005 11:03:49 PM |
|
Helge Hafstad <helgehd@start.no> wrote:
> FM 7 Mac OS X
>
> In my customer database I'm trying to set up a script that either use
> the name enterered in a global text field to make a new record or do a
> find for similar records. The first works well, but I'm not able to get
> the global value into the find request. I've tried Go to field, Set
> field, Insert text and calculated result, Copy and Paste, Perform
> another script, but it seems that the value in the global field not is
> present before after Perform find.
>
> I would be very pleased to come further with this one.
A quick idea:
Maybe you can use the Let function in your script before entering find
mode.
|
|
0
|
|
|
|
Reply
|
no
|
3/4/2005 10:15:18 AM
|
|
Jens Rasmussen <no@way.dk> wrote:
> > FM 7 Mac OS X
> >
> > In my customer database I'm trying to set up a script that either use
> > the name enterered in a global text field to make a new record or do a
> > find for similar records. The first works well, but I'm not able to get
> > the global value into the find request. I've tried Go to field, Set
> > field, Insert text and calculated result, Copy and Paste, Perform
> > another script, but it seems that the value in the global field not is
> > present before after Perform find.
> >
> > I would be very pleased to come further with this one.
> >
> A quick idea:
> Maybe you can use the Let function in your script before entering find
> mode.
Thanks, Jens, but the global field is filled in before entering Find
mode, so I can't see the difference. Anyway, I'm not familiar with the
Let function so anyone could eventually give me some help here...;-)
--
Rgds Helge Hafstad
helge.hafstad@mac.com
Bergen - Norway
|
|
0
|
|
|
|
Reply
|
helgehd
|
3/4/2005 1:40:50 PM
|
|
you have entered the value in the global field
in the script
goto search
set <mySearchField> to <myGlobalfield>
perform find
should do the trick
Ursus
"Helge Hafstad" <helgehd@start.no> schreef in bericht
news:1gstk1g.1p936oy1hnkaz4N%helgehd@start.no...
> FM 7 Mac OS X
>
> In my customer database I'm trying to set up a script that either use
> the name enterered in a global text field to make a new record or do a
> find for similar records. The first works well, but I'm not able to get
> the global value into the find request. I've tried Go to field, Set
> field, Insert text and calculated result, Copy and Paste, Perform
> another script, but it seems that the value in the global field not is
> present before after Perform find.
>
> I would be very pleased to come further with this one.
> --
> Rgds Helge Hafstad
> helge.hafstad@mac.com
> Bergen - Norway
|
|
0
|
|
|
|
Reply
|
ursus
|
3/4/2005 2:13:20 PM
|
|
"Helge Hafstad" wrote:
> FM 7 Mac OS X
>
> In my customer database I'm trying to set up a script that either use
> the name enterered in a global text field to make a new record or do a
> find for similar records. The first works well, but I'm not able to get
> the global value into the find request. I've tried Go to field, Set
> field, Insert text and calculated result, Copy and Paste, Perform
> another script, but it seems that the value in the global field not is
> present before after Perform find.
>
> I would be very pleased to come further with this one.
I'm not sure I understand what exactly you are trying to do but this may
help. The global field value is the same for every record.
Global field named global1
Text filed named field1
The text is entered manually into global1
To perform a find in field1 using the contents of global1:
Enter find mode
Set field (table:field1; table:global1)
Perform find
What error are you getting exactly?
Geoff
|
|
0
|
|
|
|
Reply
|
G
|
3/4/2005 3:19:44 PM
|
|
|
4 Replies
296 Views
(page loaded in 0.07 seconds)
|