Script Issue

#1

I am trying to figure out why a script that wrote work for all but one. I have a database that has problems that happen on the production line and we input the department manager and a check box when it is fixed.

The script i wrote is to pop up a search window which it does and after selecting the managers name it is to search the db and return only those that do not have the check box checked.

It works for all but one managers name and we cannot figure out why.

The script is a follows, I have some things disabled so it works just not for the one name.

Quote:

Set Field [Nonconformance notification::Manager Incomplete Search]
Go to Layout["Manager Search" (Nonconformance)]
Freeze Window
New Window [Name: "Manager Search"; Height: 300; Width: 600; Top:100; Left: 150]
Show/Hide Status Area [Hide]
Pause/Resume Script [Indefinitely]
Close Window [Current Window]
If ["LastMessageChoice =1"]
Enter Find Mode []
Go to Layout ["Manager incomplete" (Nonconformance Notification)]
Set Field [Nonconformance Notification:: Dept. manager responsiblity to review info:; nonconformance Notification::Manager Incomplete Search]
Preform Find[]
If [Nonconformance Notification::${RCA Cause and resolution complete checkbox} = "yes"]
Constrain Found Set [Restore]
// Omit Record
End if
// Preform Find [Restore]
Sort Records [Restore; No dialog]
// Else If ["LastMessageChoice= 2"]
// Exit Script []
End If
Go to layout ["Manager Incomplete" (Nonconformance Notification)]
Show/Hide Status Area [Show]

Thanks for any incite into this issue.
Doug

#2

In article <4pKdnZm_QuA2ebnQnZ2dnUVZ_hGdnZ2d (AT) giganews (DOT) com>,
dweidman <user (AT) compgroups (DOT) net/> wrote:

Quote:

I am trying to figure out why a script that wrote work for all but one. I
have a database that has problems that happen on the production line and we
input the department manager and a check box when it is fixed.

The script i wrote is to pop up a search window which it does and after
selecting the managers name it is to search the db and return only those that
do not have the check box checked.

It works for all but one managers name and we cannot figure out why.

Perhaps it's something to do with the manager's name? Does it have
accented characters or hyphenation in it? Do the users have to type
it in, or are they using a menu derived from a value list of the
managers names in the database?

Just a thought...

Quote:

The script is a follows, I have some things disabled so it works just not for
the one name.

Set Field [Nonconformance notification::Manager Incomplete Search]
Go to Layout["Manager Search" (Nonconformance)]
Freeze Window
New Window [Name: "Manager Search"; Height: 300; Width: 600; Top:100; Left:
150]
Show/Hide Status Area [Hide]
Pause/Resume Script [Indefinitely]
Close Window [Current Window]
If ["LastMessageChoice =1"]
Enter Find Mode []
Go to Layout ["Manager incomplete" (Nonconformance Notification)]
Set Field [Nonconformance Notification:: Dept. manager responsiblity to
review info:; nonconformance Notification::Manager Incomplete Search]
Preform Find[]
If [Nonconformance Notification::${RCA Cause and resolution complete
checkbox} = "yes"]
Constrain Found Set [Restore]
// Omit Record
End if
// Preform Find [Restore]
Sort Records [Restore; No dialog]
// Else If ["LastMessageChoice= 2"]
// Exit Script []
End If
Go to layout ["Manager Incomplete" (Nonconformance Notification)]
Show/Hide Status Area [Show]

Thanks for any incite into this issue.
Doug

#3

In article <no.email-C3B171.17220905012011 (AT) mx02 (DOT) eternal-september.org>,
David Stone <no.email (AT) domain (DOT) invalid> wrote:

Quote:

In article <4pKdnZm_QuA2ebnQnZ2dnUVZ_hGdnZ2d (AT) giganews (DOT) com>,
dweidman <user (AT) compgroups (DOT) net/> wrote:

I am trying to figure out why a script that wrote work for all but one. I
have a database that has problems that happen on the production line and we
input the department manager and a check box when it is fixed.

The script i wrote is to pop up a search window which it does and after
selecting the managers name it is to search the db and return only
those that do not have the check box checked.

It works for all but one managers name and we cannot figure out why.

Perhaps it's something to do with the manager's name? Does it have
accented characters or hyphenation in it? Do the users have to type
it in, or are they using a menu derived from a value list of the
managers names in the database?

Just a thought...

Another possible cause can be when one name is a subset of another. For
example performing a Find for "John" will also pick up "Johnson",
"Johnny", etc. You may be able to get around this by using the Exact match
operator ("=") or Field Content Match operator ("==").
e.g

Set Field [Nonconformance Notification:: Dept. manager responsiblity
to review info:; "=" & nonconformance Notification::Manager
Incomplete Search]

Helpful Harry

)

#4

The Manager's Name is John Edgington and is a member of a value list and the users can not freely enter names.

#5

Well I would go for that but he is the only one with anything close to his name and all other manager names work with this script. His is the only one that when run displays all his records not just the one unchecked.

Thanks,
Doug

#6

On Thu, 06 Jan 2011 08:43:01 -0600, dweidman <user (AT) compgroups (DOT) net/>
wrote:

Quote:

The Manager's Name is John Edgington and is a member of a value list and the users can not freely enter names.

Are the manager names hard-coded in the script itself? If so, was
there a spelling mistake there or perhaps an unnecessary space at the
beginning or end of his name?

#7

I am not sure what you mean there but the user has a button that pops up and window with the value list to pick from and a search button.

#8

On Thu, 06 Jan 2011 09:29:25 -0600, dweidman <user (AT) compgroups (DOT) net/>
wrote:

Quote:

I am not sure what you mean there but the user has a button that pops up and window with the value list to pick from and a search button.

I just looked at the script and that's not it. The name in the value
list must be different somehow. Is it a custom value list or is it
generated by a table in the database?

#9

I will say that his records in the db are being displayed but it is returning both the checked records and unchecked records. Other manager's return their own records but with only their unchecked items.

#10

On Thu, 06 Jan 2011 11:13:17 -0600, dweidman <user (AT) compgroups (DOT) net/>
wrote:

Quote:

I will say that his records in the db are being displayed but it is returning both the checked records and unchecked records. Other manager's return their own records but with only their unchecked items.

Just his records?