Re: replace field contents - record locking

On Mar 21, 4:39 am, "Tim" <tswal...@xxxxxxxxx> wrote:
hi all
(windows, server 8, clients 8.5)

I have just upgraded from v4 to v8, and the replace command now has
problems.
If a user is in a record, then it is locked, and the replace command
says "3 records were locked and were not updated".


1. the records are not really in use, they are not being edited by the
user. It is just by chance that for some reason the cursor is being
left in fields on certain forms. This is often not due to a user
action but due to a copy or paste script step.

Change your scripts so this doesn't happen.



Q.can we force the user out of the record?

Only with a plug in.


Q.can a record automatically be 'committed' when the form loses focus?
(coming from v3 originally, this solution has 50 files rather than 1
file with 50 tables)

You may want to look at your db structure. Do you really need 50
tables?

You can script navigation to force a record commit.



2.if we can't force the cursor out of a record, can the replace
command let me know which records couldn't be updated? - it must know.

No. You can script the replace with a Loop and Set Field and capture
the errors though.


finally - startup time on server4 was 1 minute. startup time on
server8 it 2.5 minutes. what gives?


successive editions of Filemaker have been successively slower.

cheers

Tim

DJ

.

Relevant Pages

  • Re: FTP delete problem
    ... But i have wrote that manually the delete command it's OK!!! ... Dim strLocalFolderName, strFTPServerName, strLoginID ... In my script I use the options -s for the file. ... If i am in session in the server the scheduled script result OK. ...
    (microsoft.public.inetserver.iis.ftp)
  • Re: FTP in ASP.NET C#
    ... It has native .NET classes that will allow you to use the FTP protocol. ... >I would like to have my application FTP a file to a server after a user ... > ' This script assumes the file to be FTP'ed is in the same directory as ... > ' If there are multiple files to put, we need to use the command ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Perl and IIS - script runs but The page cannot be displayed
    ... > one with the variables passed to the script hard coded (although there ... > with absolute paths rather the relative ones the server doesnt mind. ... When executed from a command line, ... CGI programs do not use this function, ...
    (comp.lang.perl.misc)
  • Re: DNS Management tools for Large hosting environment
    ... like things simple without having to script something (seeing as I have never ... nowhere do I see a command to SEARCH for a host record and REPLACE ... Server in multiple domains. ... >> manualy, thus my need for a global search and replace, which it appears, ...
    (microsoft.public.windows.server.active_directory)
  • Re: dcdiag - advertising errors on newley promoted domain controller
    ... Can you do the following on uksccmads01 ... The problem may actually have nothing to do with the new server but the ... From a command prompt try and see if you get any additional info ... Skipping site UK-CCM, this site is outside the scope ...
    (microsoft.public.windows.server.active_directory)