Go to related records then find a subset

Hi,

First at all, to all of you that live in UK, I would like to express
my deepest condolences for what it is happening today in London. It is
terrible and makes no favour to human kind. I live in Spain and as you
know we suffered a similar not so far ago.

Please excuse me if I introduce a question now.

I am using FM Server 5.5 and FM Pro 5.5, multiuser solution.

I have scripted a Go to related records (one to many). It works fine.
Then I need to carry out a Find within this records. I have found no
easy way to do it. The best option I have tried so far it is to create
a script in the related file that flags the found records, then adds a
Find script step that includes all the desired parameters + the flag
field.

However, this option is not practical. The database consist of
+200.000 records and growing fast. This means that the Replace step
can take several minutes to complete. Besides, after finding and
showing the records, I need to reset the flag field, so that it is
ready for a future find.

I have also tried a loop, that includes or excludes records based on
the find criteria. However, this is also a very slow solution.

Is there any optimal way to do this in a networked solution with so
many records? From what I have read in the newsgroups, there is no way
to Constrain the Found set if the Found set comes from a Go to related
records (this would be a good option, if it worked).

Thanks,

Carlos
.

Relevant Pages

  • Re: changing existing local user flag "never expires"
    ... set the flag "password never expires". ... A non-zero result means that the flag is ... which means that the script results in the flag not being ... If (lngFlags And ADS_UF_DONT_EXPIRE_PASSWD) = 0 Then ...
    (microsoft.public.scripting.vbscript)
  • Re: VBscript to set the inherit permissions in registry
    ... propogate to this object" on a workstation from a script. ... Dim objUser, objNtSecurityDescriptor, intNtSecurityDescriptorControl ... ' Save control settings in the security descriptor object. ... As with all flag settings, you "And" the property with the appropriate bit ...
    (microsoft.public.scripting.vbscript)
  • Re: how to call a function when somebody click a link?
    ... and the php script call the function only if the flag is set:) ... //we want user to go on this page and to add a flag which cause PHP to ... data's been sent to client's browser. ...
    (comp.lang.php)
  • Re: run once
    ... The logon script checked for a "flag" file. ... you can monitor and even push out modifications. ...
    (microsoft.public.windows.server.scripting)
  • RE: Update SQL Error
    ... Both the flgFieldNo and the txtFlgField are text that are input by the user. ... I am doing it this way because I have 9 flag fields and I don't want to have ... Trying to code a "clear" flag field button on a form using Update SQL ...
    (microsoft.public.access.formscoding)