cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
%3CLINGO-SUB%20id%3D%22lingo-sub-339784%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ESo%20rufen%20Sie%20die%20Meldung%20%E2%80%9EDatei%20wird%20verwendet%E2%80%9C%20auf%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339784%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EHallo%2C%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3EIch%20erstelle%20gerade%20eine%20JMP-Datei%2C%20die%20als%20Datenbank%20fungiert.%20Daher%20m%C3%B6chte%20ich%20eine%20Meldung%20%E2%80%9EDatei%20wird%20verwendet%E2%80%9C%20anzeigen%20und%20die%20Datei%20f%C3%BCr%20die%20Bearbeitung%20gesperrt%20halten%2C%20wenn%20jemand%20anderes%20die%20Datenbank%20bereits%20ge%C3%B6ffnet%20hat%20und%20%C3%84nderungen%20an%20der%20Datei%20vornimmt.%20Beispielsweise%20dieselbe%20Meldung%2C%20die%20Sie%20erhalten%2C%20wenn%20Sie%20eine%20Excel-Datei%20an%20einem%20Serverspeicherort%20%C3%B6ffnen%2C%20der%20bereits%20von%20jemand%20anderem%20verwendet%20wird%3A%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22file%20in%20use%20message.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22file%20in%20use%20message.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22file%20in%20use%20message.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22file%20in%20use%20message.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F28754i41DD73882C69D926%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22file%20in%20use%20message.png%22%20alt%3D%22file%20in%20use%20message.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3EIch%20glaube%2C%20ich%20habe%20bereits%20einen%20Teil%20der%20Antwort%20in%20folgendem%20Community-Beitrag%20gefunden%3A%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscussions%2FMulti-User-Access%2Fm-p%2F109626%23U109626%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-forum-thread%20lia-fa-icon%20lia-fa-forum%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3EMulti-User%20Access%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3EWenn%20das%20richtig%20ist%2C%20muss%20ich%20noch%20herausfinden%2C%20wie%20ich%20die%20Tabelle%20sperren%20kann%2C%20wenn%20sie%20von%20einem%20anderen%20Benutzer%20ge%C3%B6ffnet%20wird.%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3EK%C3%B6nnte%20jemand%20bitte%20beim%20Erstellen%20eines%20solchen%20Skripts%20helfen%3F%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3EDanke%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-339784%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CLINGO-LABEL%3EDatenzugriff%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-341069%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Wie%20man%20eine%20%E2%80%9EDatei%20wird%20verwendet%E2%80%9C-Meldung%20ausgibt%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-341069%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EEs%20wird%20wahrscheinlich%20in%20JMP%2014%20funktionieren.%20Ich%20habe%20das%20JMP%2015%2F16-Problem%20gemeldet%2C%20das%20ich%20gesehen%20habe.%3C%2FP%3E%3CP%3EWenn%20Sie%20es%20in%2015%20zum%20Laufen%20bringen%20m%C3%BCssen%2C%20k%C3%B6nnen%20Sie%20so%20etwas%20wie%20diese%20Funktion%20tun%2C%20die%20ich%20im%20FileSnapper-Add-In%20verwendet%20habe.%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%20FileSnapper%3AisFileOpenElsewhere%20%3D%20Function(%20%7Bfilepath%7D%2C%20%7Bdt%2C%20savelog%7D%2C%0A%20%20If(%20endswith(filepath%2C%22.jmp%22)%20%26amp%3B%20File%20Exists(%20filepath%20)%2C%0A%20%20%20dt%20%3D%20Open(%20filepath%2C%20private%20)%3B%20%20%0A%20%20%20savelog%20%3D%20Log%20Capture(%20dt%20%26lt%3B%26lt%3B%20save%20)%3B%0A%20%20%20close(dt%2C%22nosave%22)%3B%0A%20%20%20Length(%20savelog%20)%20!%3D%200%3B%20%2F%2F%20error%20message%20means%20another%20JMP%20has%20dt%20open%0A%20%20%2C%20%2F%2F%20else%0A%20%20%200%20%2F%2F%20not%20open%20if%20not%20exists%20%0A%20%20)%0A%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EEs%20funktioniert%2C%20indem%20versucht%20wird%2C%20die%20Datei%20zu%20speichern%2C%20sobald%20sie%20ge%C3%B6ffnet%20wird%2C%20und%20die%20Protokollnachricht%20abgefangen%20wird.%20Wenn%20es%20keine%20Log-Meldung%20gibt%2C%20hat%20das%20Speichern%20funktioniert.%20Sie%20m%C3%B6chten%20das%20ein%20wenig%20neu%20anordnen%2C%20den%20Tisch%20wahrscheinlich%20nicht%20schlie%C3%9Fen%2C%20wenn%20das%20Speichern%20erfolgreich%20war%2C%20und%20nicht%20verwenden%3CEM%3E%20Privatgel%C3%A4nde%3C%2FEM%3E%20.%20Der%20Nachteil%20ist%2C%20wenn%20die%20Datei%20sehr%20gro%C3%9F%20ist%2C%20kann%20das%20zus%C3%A4tzliche%20Speichern%20einige%20Zeit%20dauern%20und%20es%20verdoppelt%20sich%20die%20Wahrscheinlichkeit%2C%20dass%20w%C3%A4hrend%20des%20Speicherns%20ein%20Stromausfall%20auftritt%20und%20die%20Daten%20besch%C3%A4digt%20werden.%20(F%C3%BCr%20FileSnapper%20ist%20die%20Datei%20ein%20W%C3%A4chter%2C%20klein%2C%20kurz%20davor%2C%20gel%C3%B6scht%20und%20jedes%20Mal%20neu%20erstellt%20zu%20werden%2C%20also%20funktioniert%20es%20gut.)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-341045%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Wie%20man%20eine%20%E2%80%9EDatei%20wird%20verwendet%E2%80%9C-Meldung%20ausgibt%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-341045%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EOk%2C%20danke%2C%20dass%20Sie%20sich%20diesen%20Craig%20angesehen%20haben.%3C%2FP%3E%3CP%3EIch%20werde%20versuchen%2C%20das%20Skript%20von%20David%20in%20meiner%20JMP-Datei%20einzurichten.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-339926%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Wie%20man%20eine%20%E2%80%9EDatei%20wird%20verwendet%E2%80%9C-Meldung%20ausgibt%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339926%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHmm.%20Ich%20kann%20sehen%2C%20dass%20es%20in%20JMP%2014%20funktioniert%2C%20aber%20vielleicht%20nicht%20in%2015.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-339904%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Wie%20man%20eine%20%E2%80%9EDatei%20wird%20verwendet%E2%80%9C-Meldung%20ausgibt%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339904%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EDavids%20Skript%20enth%C3%A4lt%20den%20Code%2C%20der%20nach%20sichtbaren%20Hinweisen%20sucht%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Several%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%22%20style%3D%22width%3A%20493px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Several%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%22%20style%3D%22width%3A%20493px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Several%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%22%20style%3D%22width%3A%20493px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Several%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%22%20style%3D%22width%3A%20493px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Several%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%22%20style%3D%22width%3A%20493px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Several%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%22%20style%3D%22width%3A%20493px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Several%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%22%20style%3D%22width%3A%20493px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Several%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%22%20style%3D%22width%3A%20493px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Several%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%22%20style%3D%22width%3A%20493px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Several%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%22%20style%3D%22width%3A%20493px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Several%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%22%20style%3D%22width%3A%20493px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Several%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%22%20style%3D%22width%3A%20493px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Several%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%22%20style%3D%22width%3A%20493px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F28764iB52CA662BB094D01%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22LockedFile.PNG%22%20alt%3D%22Several%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%22%20%2F%3E%3Cspan%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESeveral%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%3C%2Fspan%3E%3C%2Fspan%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESeveral%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESeveral%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESeveral%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESeveral%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESeveral%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESeveral%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESeveral%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESeveral%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESeveral%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESeveral%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESeveral%20copies%20of%20JMP%20open%2C%20same%20table%20in%20two%20copies%2C%20one%20of%20them%20is%20locked%20out%20by%20the%20other.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EMehrere%20Kopien%20von%20JMP%20ge%C3%B6ffnet%2C%20dieselbe%20Tabelle%20in%20zwei%20Kopien%2C%20eine%20davon%20wird%20durch%20die%20andere%20gesperrt.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-339902%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Wie%20man%20eine%20%E2%80%9EDatei%20wird%20verwendet%E2%80%9C-Meldung%20ausgibt%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339902%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EDanke%20f%C3%BCr%20die%20Antworten%20Craige.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EW%C3%A4re%20es%20m%C3%B6glich%2C%20eine%20Meldung%2FWarnung%20anzuzeigen%2C%20dass%20die%20Datei%20bereits%20von%20jemand%20anderem%20verwendet%20wird%3F%20Derzeit%20k%C3%B6nnte%20der%20zweite%20Benutzer%20nicht%20wissen%2C%20dass%20die%20Datei%20bereits%20von%20einem%20anderen%20Benutzer%20ge%C3%B6ffnet%20wurde.%20Wenn%20also%20der%20zweite%20Benutzer%20%C3%84nderungen%20an%20der%20Datei%20vornimmt%2C%20k%C3%B6nnen%20diese%20%C3%84nderungen%20nicht%20in%20der%20Originaldatei%20gespeichert%20werden.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-339880%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Wie%20man%20eine%20%E2%80%9EDatei%20wird%20verwendet%E2%80%9C-Meldung%20ausgibt%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339880%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EEine%20JMP-Tabelle%20ist%20f%C3%BCr%20das%20Schreiben%20durch%20den%20ersten%20Benutzer%20gesperrt%2C%20der%20sie%20%C3%B6ffnet.%20Nachfolgende%20Benutzer%20erhalten%20schreibgesch%C3%BCtzten%20Zugriff%20(sie%20k%C3%B6nnen%20ihre%20%C3%84nderungen%20nicht%20speichern).%20Das%20Drehbuch%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F4536%22%20target%3D%22_blank%22%3E%20%40David_Burnham%3C%2FA%3E%20wrote%20geht%20davon%20aus%2C%20dass%20der%20Benutzer%20mit%20der%20Sperre%20die%20Tabelle%20ziemlich%20bald%20schlie%C3%9Fen%20wird%20(200%20Versuche)%20und%20%C3%B6ffnet%20dann%20die%20Tabelle%20f%C3%BCr%20den%20neuen%20Benutzer%2C%20der%20die%20Sperre%20f%C3%BCr%20den%20neuen%20Benutzer%20erhalten%20sollte.%20Es%20k%C3%B6nnte%20f%C3%BCr%202%20oder%203%20Benutzer%20ziemlich%20gut%20funktionieren%2C%20die%20ein%20sorgf%C3%A4ltig%20geschriebenes%20Programm%20verwenden%2C%20um%20die%20Tabelle%20zu%20aktualisieren.%20Es%20ist%20nicht%20f%C3%BCr%20einen%20Benutzer%2C%20der%20den%20Tisch%20%C3%B6ffnet%20und%20dann%20zum%20Mittagessen%20geht%2C%20ohne%20ihn%20zu%20schlie%C3%9Fen.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-743872%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBetreff%3A%20So%20zeigen%20Sie%20die%20Meldung%20%E2%80%9EDatei%20wird%20verwendet%E2%80%9C%20an%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743872%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EK%C3%B6nnen%20Sie%20den%20Test%20posten%3F%20Und%20ist%20die%20Datei%20eine%20Netzwerkdatei%20oder%20eine%20lokale%20Datei%3F%20Ich%20bin%20mir%20nicht%20sicher%2C%20was%20JMP%20oder%20das%20Betriebssystem%20anders%20machen%20k%C3%B6nnten%2C%20aber%20ich%20glaube%20zumindest%20manchmal%2C%20dass%20JMP%20in%20einer%20anderen%20Datei%20speichert%20und%20dann%20l%C3%B6scht%2Fumbenennt%2Faustauscht%2C%20um%20das%20Zeitfenster%20f%C3%BCr%20einen%20Stromausfall%20so%20klein%20wie%20m%C3%B6glich%20zu%20halten.%20Es%20k%C3%B6nnte%20sein%2C%20dass%20dieser%20Prozess%20im%20Weg%20steht.%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F3022%22%20target%3D%22_blank%22%3E%40briancorcoran%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-744192%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBetreff%3A%20So%20zeigen%20Sie%20die%20Meldung%20%E2%80%9EDatei%20wird%20verwendet%E2%80%9C%20an%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744192%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EDie%20Probleme%20sind%20schlimmer%20mit%20einem%20Netzlaufwerk%20(in%20meinem%20Fall)%20mit%20einer%20Datei%20auf%20OneDrive.%20Aber%20meine%20Tests%20wurden%20mit%20einer%20lokalen%20Datei%20durchgef%C3%BChrt.%20Windows%2010%2C%20JMP%2017.%3C%2FP%3E%0A%3CP%3EDie%20Skripte%20%E2%80%9Elocktest1%E2%80%9C%20und%20%E2%80%9Elocktest2%E2%80%9C%20sind%20identisch%2C%20au%C3%9Fer%20dass%20das%20erste%20Skript%20Spalte%201%20der%20Ergebnistabelle%20aktualisiert%2C%20w%C3%A4hrend%20das%20zweite%20Skript%20Spalte%202%20aktualisiert.%3C%2FP%3E%0A%3CP%3EDurch%20die%20gleichzeitige%20Ausf%C3%BChrung%20jedes%20Skripts%20in%20separaten%20JMP-Instanzen%20ist%20es%20m%C3%B6glich%2C%20die%20Logik%20f%C3%BCr%20die%20Handhabung%20von%20Dateisperren%20einem%20Stresstest%20zu%20unterziehen.%3C%2FP%3E%0A%3CP%3EZeile%2075%20des%20Skripts%20enth%C3%A4lt%20den%20Pfad%20zur%20Ergebnistabelle.%20Platzieren%20Sie%20die%20Ergebnistabelle%20an%20einem%20geeigneten%20Ort%20und%20aktualisieren%20Sie%20die%20Pfadvariable%2C%20sodass%20sie%20auf%20diesen%20Ort%20verweist.%3C%2FP%3E%0A%3CP%3E%C3%96ffnen%20Sie%20eine%20JMP-Sitzung%20und%20%C3%B6ffnen%20Sie%20locktest1.%20Zeigen%20Sie%20das%20eingebettete%20Protokoll%20an.%3C%2FP%3E%0A%3CP%3E%C3%96ffnen%20Sie%20eine%20zweite%20JMP-Sitzung%20und%20%C3%B6ffnen%20Sie%20loctest2%20mit%20einem%20eingebetteten%20Protokoll.%3C%2FP%3E%0A%3CP%3EF%C3%BChren%20Sie%20die%20beiden%20Skripte%20aus%20(ich%20f%C3%BChre%20das%20erste%20aus%2C%20warte%2C%20bis%20das%20Protokoll%20i%3D5%20anzeigt%2C%20und%20f%C3%BChre%20dann%20das%20zweite%20aus%2C%20aber%20das%20ist%20blo%C3%9Fer%20Aberglaube).%3C%2FP%3E%0A%3CP%3EDie%20in%20Zeile%2079%20definierte%20Schleife%20f%C3%BChrt%2050%20Iterationen%20durch.%20Wenn%20die%20beiden%20Skripte%20erfolgreich%20abgeschlossen%20werden%2C%20sollte%20das%20Ergebnis%20sein%2C%20dass%20die%20Ergebnistabelle%20in%20jeder%20der%20beiden%20Spalten%20die%20Zahlen%201%20bis%2050%20enth%C3%A4lt.%3C%2FP%3E%0A%3CP%3EEs%20gibt%20ein%20Tabellenskript%2C%20mit%20dem%20Sie%20den%20Tabelleninhalt%20zur%C3%BCcksetzen%20k%C3%B6nnen.%3C%2FP%3E%0A%3CP%3EIn%20der%20Praxis%20gibt%20es%20drei%20m%C3%B6gliche%20Fehlermodi%3A%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3EEine%20oder%20mehrere%20Meldungen%20%E2%80%9EEnde%20der%20Dateimarkierung%20konnte%20nicht%20abgerufen%20werden%E2%80%9C%20werden%20angezeigt.%20Dieser%20Fehler%20tritt%20beim%20Speichern%20auf%20und%20es%20ist%20nicht%20m%C3%B6glich%2C%20die%20Ergebnisse%20zu%20speichern.%20Daher%20fehlen%20in%20der%20Ergebnistabelle%20einige%20Werte.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLI%3E%0A%3CLI%3EIrgendwann%20verschwindet%20die%20Ergebnistabelle.%20Wenn%20die%20Datei%20nicht%20gefunden%20werden%20kann%2C%20brechen%20die%20Skripte%20die%20Ausf%C3%BChrung%20mit%20der%20Meldung%20%E2%80%9EDatei%20nicht%20gefunden%E2%80%9C%20ab.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLI%3E%0A%3CLI%3EGelegentlich%20gelingt%20es%20beiden%20Skripten%20nicht%2C%20die%20Tabelle%20zu%20sperren.%20Dies%20wird%20dadurch%20angezeigt%2C%20dass%20beide%20Skripte%20500%20Versuche%20unternehmen%2C%20eine%20Sperre%20zu%20erhalten.%20Wenn%20Sie%20die%20Skripts%20abbrechen%20und%20dann%20versuchen%2C%20die%20Ergebnistabelle%20zu%20%C3%B6ffnen%2C%20wird%20diese%20eine%20Tabellenvariable%20%3CEM%3E%E2%80%9Efile_lock%E2%80%9C%3C%2FEM%3E%20enthalten.%20Bei%20beiden%20JMP-Instanzen%20ist%20die%20Tabelle%20gesperrt.%20Die%20einzige%20M%C3%B6glichkeit%2C%20es%20zu%20entsperren%2C%20besteht%20darin%2C%20beide%20JMP-Sitzungen%20zu%20schlie%C3%9Fen.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E50%20Iterationen%20reichen%20normalerweise%20aus%2C%20um%20(1)%20und%20(2)%20zu%20beobachten%2C%20aber%20gelegentlich%20m%C3%BCssen%20Sie%20die%20Anzahl%20der%20Iterationen%20erh%C3%B6hen%2C%20um%20(2)%20zu%20sehen.%20Szenario%20(3)%20ist%20wahrscheinlicher%2C%20wenn%20Hunderte%20von%20Iterationen%20durchgef%C3%BChrt%20werden%20und%20die%20Wartezeit%20in%20Zeile%20100%20entfernt%20wird.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-743739%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBetreff%3A%20So%20zeigen%20Sie%20die%20Meldung%20%E2%80%9EDatei%20wird%20verwendet%E2%80%9C%20an%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743739%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EBeim%20Testen%20sto%C3%9Fe%20ich%20auf%20ein%20Szenario%2C%20in%20dem%20ich%20die%20Tabelle%20%C3%B6ffnen%20kann%2C%20ohne%20dass%20eine%20Meldung%20im%20%3CSTRONG%3ESavelog%3C%2FSTRONG%3E%20erscheint%2C%20aber%20beim%20Speichern%20erhalte%20ich%20die%20Fehlermeldung%20%E2%80%9EEnde-Markierung%20konnte%20nicht%20abgerufen%20werden%E2%80%9C.%20Dadurch%20werden%20nicht%20nur%20die%20neuesten%20Daten%20nicht%20gespeichert%2C%20sondern%20die%20gesamte%20Datei%20verschwindet%20und%20alle%20Daten%20gehen%20verloren.%3C%2FP%3E%0A%3CP%3EIn%20der%20Testumgebung%20habe%20ich%20zwei%20identische%20Skripte%2C%20au%C3%9Fer%20dass%20ein%20Skript%20die%20erste%20Spalte%20der%20Tabelle%20aktualisiert%20und%20das%20zweite%20Skript%20die%20zweite%20Spalte.%20Jedes%20Skript%20versucht%20100%20Mal%2C%20die%20Tabelle%20zu%20aktualisieren.%20Wenn%20beim%20%C3%96ffnen%20(%C3%BCber%20%3CEM%3ESavelog%3C%2FEM%3E%20)%20gemeldet%20wird%2C%20dass%20die%20Tabelle%20gesperrt%20ist%2C%20wartet%20es%20und%20versucht%20es%20erneut%20(entsprechend%20meinem%20urspr%C3%BCnglichen%20Skript).%20Allerdings%20tritt%20vielleicht%20ein-%20oder%20zweimal%20in%20den%20100%20Versuchen%20ein%20Fehler%20mit%20der%20Markierung%20des%20Dateiendes%20auf.%20Dies%20kann%20beim%20%C3%96ffnen%20der%20Datei%20(mit%20dem%20%3CEM%3ESavelog-%3C%2FEM%3E%20Test)%20oder%20beim%20Speichern%20der%20Ergebnisse%20(Schlie%C3%9Fen%20und%20Speichern%20unter%20der%20Annahme%2C%20dass%20Schreibzugriff%20besteht)%20auftreten.%20Ich%20habe%20beim%20Schlie%C3%9Fen%20einen%20%C3%A4hnlichen%20%3CEM%3ESavelog-%3C%2FEM%3E%20Test%20implementiert%2C%20aber%20dann%20ist%20es%20zu%20sp%C3%A4t%2C%20der%20Schaden%20ist%20angerichtet.%3C%2FP%3E%0A%3CP%3EMeine%20Erfahrung%20mit%20diesem%20Fehler%20ist%2C%20dass%20Sie%20gro%C3%9Fe%20Probleme%20haben%20und%20riskieren%2C%20die%20Tabelle%20vollst%C3%A4ndig%20zu%20verlieren%2C%20wenn%20er%20beim%20Versuch%20auftritt%2C%20Ergebnisse%20zu%20speichern.%20Ich%20versuche%20daher%2C%20den%20Fehler%20von%20vornherein%20zu%20vermeiden%2C%20indem%20ich%20versuche%2C%20beim%20%C3%96ffnen%20der%20Tabelle%20zuverl%C3%A4ssig%20Lese-%20und%20Schreibzugriff%20zu%20erhalten.%20In%2099%20%25%20der%20F%C3%A4lle%20gelingt%20mir%20das%2C%20aber%20irgendwann%20kann%20der%20Fehler%20immer%20auftreten.%20Ich%20vermute%2C%20dass%20es%20eine%20geringe%20Chance%20gibt%2C%20dass%20beide%20Skripte%20Lese-%20und%20Schreibzugriff%20auf%20die%20Datei%20erhalten%20(zumindest%20laut%20Savelog)%2C%20aber%20irgendwann%20beh%C3%A4lt%20ein%20Skript%20den%20Lese-%20und%20Schreibzugriff%20und%20das%20andere%20Skript%20erh%C3%A4lt%20einen%20Dateiende-Markierungsfehler%20%E2%80%93%20wahrscheinlich%2C%20wenn%20das%20andere%20Skript%20eine%20Aktualisierung%20durchgef%C3%BChrt%20hat).%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-749493%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBetreff%3A%20So%20zeigen%20Sie%20die%20Meldung%20%E2%80%9EDatei%20wird%20verwendet%E2%80%9C%20an%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-749493%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EEntschuldigung%2C%20ich%20habe%20den%20%C3%9Cberblick%20verloren.%20Ich%20habe%20ein%20Video%20davon%20gemacht%2C%20wie%20die%20Datentabelle%20vom%20Desktop%20verschwindet%2C%20und%20es%20an%20das%20Entwicklungsteam%20geschickt.%20Danke!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
RobRobeyns
Level III

How to prompt a " File in Use" message

Hi,

 

I'm currently creating a JMP file which acts as a database. Therefore I would like to prompt a "File in use" message and keep the file locked for editing when someone else already opened the database and is making changes to the file. For example, the same message you get when you open an Excel file on a server location that is already in use by someone else:

 

file in use message.png

 

 

 

 

I think I already found a part of the answer in the following Community post: Multi-User Access 

 

If I'm correct I would still need to figure out how to lock the table if it is opened by another user.

 

Could someone please help with creating such a script?

 

Thanks

 

10 REPLIES 10
Craige_Hales
Super User

Re: How to prompt a " File in Use" message

Sorry, lost track of this. I made a video of the data table vanishing off the desktop and sent it to the development team. Thanks!

Craige