cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-339784%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ECome%20visualizzare%20il%20messaggio%20%22File%20in%20uso%22.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339784%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3ECIAO%2C%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3EAttualmente%20sto%20creando%20un%20file%20JMP%20che%20funge%20da%20database.%20Pertanto%20vorrei%20visualizzare%20un%20messaggio%20%22File%20in%20uso%22%20e%20mantenere%20il%20file%20bloccato%20per%20la%20modifica%20quando%20qualcun%20altro%20ha%20gi%C3%A0%20aperto%20il%20database%20e%20sta%20apportando%20modifiche%20al%20file.%20Ad%20esempio%2C%20lo%20stesso%20messaggio%20che%20ricevi%20quando%20apri%20un%20file%20Excel%20su%20una%20posizione%20del%20server%20gi%C3%A0%20utilizzata%20da%20qualcun%20altro%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%3EPenso%20di%20aver%20gi%C3%A0%20trovato%20parte%20della%20risposta%20nel%20seguente%20post%20della%20community%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%3EAccesso%20multiutente%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3ESe%20ho%20ragione%2C%20avrei%20ancora%20bisogno%20di%20capire%20come%20bloccare%20il%20tavolo%20se%20viene%20aperto%20da%20un%20altro%20utente.%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3EQualcuno%20potrebbe%20aiutarmi%20con%20la%20creazione%20di%20uno%20script%20del%20genere%3F%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3EGrazie%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%3EAccesso%20ai%20dati%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%3ERi%3A%20Come%20visualizzare%20un%20messaggio%20%22File%20in%20uso%22.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-341069%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EProbabilmente%20funzioner%C3%A0%20in%20JMP%2014.%20Ho%20segnalato%20il%20problema%20di%20JMP%2015%2F16%20che%20stavo%20riscontrando.%3C%2FP%3E%3CP%3ESe%20devi%20farlo%20funzionare%20in%2015%2C%20puoi%20fare%20qualcosa%20di%20simile%20a%20questa%20funzione%20che%20ho%20usato%20nel%20componente%20aggiuntivo%20FileSnapper.%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%3EFunziona%20cercando%20di%20salvare%20il%20file%20non%20appena%20viene%20aperto%20e%20catturando%20il%20messaggio%20di%20registro.%20Se%20non%20ci%20sono%20messaggi%20di%20registro%2C%20il%20salvataggio%20ha%20funzionato.%20Vorresti%20riorganizzarlo%20un%20po%20'%2C%20probabilmente%20non%20chiudendo%20la%20tabella%20se%20il%20salvataggio%20ha%20avuto%20successo%20e%20non%20usando%3CEM%3E%20privato%3C%2FEM%3E%20.%20Lo%20svantaggio%20%C3%A8%20che%20se%20il%20file%20%C3%A8%20molto%20grande%2C%20il%20salvataggio%20extra%20potrebbe%20richiedere%20del%20tempo%20e%20raddoppia%20la%20possibilit%C3%A0%20di%20avere%20un'interruzione%20di%20corrente%20durante%20un%20salvataggio%2C%20danneggiando%20i%20dati.%20(Per%20FileSnapper%2C%20il%20file%20%C3%A8%20una%20sentinella%2C%20piccola%2C%20che%20sta%20per%20essere%20cancellata%20e%20ricreata%20ogni%20volta%2C%20quindi%20funziona%20bene.)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-341045%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERi%3A%20Come%20visualizzare%20un%20messaggio%20%22File%20in%20uso%22.%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%20grazie%20per%20aver%20esaminato%20questo%20Craig.%3C%2FP%3E%3CP%3EProver%C3%B2%20a%20configurare%20lo%20script%20di%20David%20nel%20mio%20file%20JMP.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-339926%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERi%3A%20Come%20visualizzare%20un%20messaggio%20%22File%20in%20uso%22.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339926%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHmm.%20Posso%20vedere%20che%20funziona%20in%20JMP%2014%2C%20ma%20forse%20non%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%3ERi%3A%20Come%20visualizzare%20un%20messaggio%20%22File%20in%20uso%22.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339904%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3ELo%20script%20di%20David%20ha%20il%20codice%20che%20controlla%20l'indicazione%20visibile%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%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%3EDiverse%20copie%20di%20JMP%20aperte%2C%20stessa%20tabella%20in%20due%20copie%2C%20una%20delle%20quali%20%C3%A8%20bloccata%20dall'altra.%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%3ERi%3A%20Come%20visualizzare%20un%20messaggio%20%22File%20in%20uso%22.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339902%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EGrazie%20per%20le%20risposte%20Craig.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESarebbe%20possibile%20richiedere%20un%20messaggio%2Favviso%20che%20il%20file%20%C3%A8%20gi%C3%A0%20in%20uso%20da%20qualcun%20altro%3F%20Attualmente%2C%20il%20secondo%20utente%20potrebbe%20non%20sapere%20che%20il%20file%20%C3%A8%20gi%C3%A0%20aperto%20da%20un%20altro%20utente.%20Pertanto%2C%20se%20il%20secondo%20utente%20apporta%20modifiche%20al%20file%2C%20queste%20modifiche%20non%20possono%20essere%20salvate%20nel%20file%20originale.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-339880%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERi%3A%20Come%20visualizzare%20un%20messaggio%20%22File%20in%20uso%22.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339880%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EUna%20tabella%20JMP%20%C3%A8%20bloccata%20per%20la%20scrittura%20dal%20primo%20utente%20che%20la%20apre.%20Gli%20utenti%20successivi%20ottengono%20l'accesso%20in%20sola%20lettura%20(non%20possono%20salvare%20le%20modifiche).%20Il%20copione%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%20write%20presuppone%20che%20l'utente%20con%20il%20blocco%20chiuder%C3%A0%20la%20tabella%20abbastanza%20presto%20(200%20tentativi)%20e%20quindi%20aprir%C3%A0%20la%20tabella%20per%20il%20nuovo%20utente%2C%20che%20dovrebbe%20ottenere%20il%20blocco%20per%20il%20nuovo%20utente.%20Potrebbe%20funzionare%20abbastanza%20bene%20per%202%20o%203%20utenti%20che%20utilizzano%20un%20programma%20scritto%20con%20cura%20per%20aggiornare%20la%20tabella.%20Non%20%C3%A8%20per%20un%20utente%20che%20potrebbe%20aprire%20il%20tavolo%20e%20poi%20andare%20a%20pranzo%20senza%20chiuderlo.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-743872%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Come%20visualizzare%20il%20messaggio%20%22File%20in%20uso%22.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743872%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EPuoi%20postare%20il%20test%3F%20E%20il%20file%20%C3%A8%20un%20file%20di%20rete%20o%20un%20file%20locale%3F%20Non%20sono%20sicuro%20di%20cosa%20potrebbero%20fare%20diversamente%20JMP%20o%20il%20sistema%20operativo%2C%20ma%20almeno%20a%20volte%20penso%20che%20JMP%20salvi%20in%20%E2%80%8B%E2%80%8Bun%20file%20alternativo%2C%20quindi%20elimini%2Frinomini%2Fscambia%20per%20ridurre%20al%20minimo%20la%20finestra%20relativa%20a%20un'interruzione%20di%20corrente.%20Potrebbe%20essere%20che%20il%20processo%20si%20stia%20intromettendo.%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%3ERe%3A%20Come%20visualizzare%20il%20messaggio%20%22File%20in%20uso%22.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744192%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EI%20problemi%20sono%20peggiori%20con%20un'unit%C3%A0%20di%20rete%20(attiva%20nel%20mio%20caso)%20con%20un%20file%20su%20OneDrive.%20Ma%20i%20miei%20test%20sono%20stati%20con%20un%20file%20locale.%20Windows%2010%2C%20JMP%2017.%3C%2FP%3E%0A%3CP%3EGli%20script%20%22locktest1%22%20e%20%22locktest2%22%20sono%20identici%2C%20tranne%20per%20il%20fatto%20che%20il%20primo%20script%20aggiorna%20la%20colonna%201%20della%20tabella%20dei%20risultati%20mentre%20il%20secondo%20script%20aggiorna%20la%20colonna%202.%3C%2FP%3E%0A%3CP%3EEseguendo%20ciascuno%20script%20simultaneamente%20in%20istanze%20JMP%20separate%20%C3%A8%20possibile%20sottoporre%20a%20stress%20test%20la%20logica%20per%20la%20gestione%20dei%20blocchi%20dei%20file.%3C%2FP%3E%0A%3CP%3ELa%20riga%2075%20degli%20script%20contiene%20il%20percorso%20per%20la%20tabella%20dei%20risultati.%20Posiziona%20la%20tabella%20dei%20risultati%20in%20una%20posizione%20adatta%20e%20aggiorna%20la%20variabile%20del%20percorso%20in%20modo%20che%20punti%20a%20questa%20posizione.%3C%2FP%3E%0A%3CP%3EAprire%20una%20sessione%20JMP%20e%20aprire%20locktest1.%20Mostra%20il%20registro%20incorporato.%3C%2FP%3E%0A%3CP%3EApri%20una%20seconda%20sessione%20JMP%20e%20apri%20loctest2%2C%20con%20un%20registro%20incorporato.%3C%2FP%3E%0A%3CP%3EEsegui%20i%20due%20script%20(eseguo%20il%20primo%2C%20aspetto%20finch%C3%A9%20il%20log%20non%20mostra%20i%3D5%20e%20poi%20eseguo%20il%20secondo%2C%20ma%20%C3%A8%20solo%20superstizione).%3C%2FP%3E%0A%3CP%3EIl%20ciclo%20definito%20alla%20riga%2079%20esegue%2050%20iterazioni.%20Se%20i%20due%20script%20vengono%20completati%20con%20successo%2C%20il%20risultato%20dovrebbe%20essere%20che%20la%20tabella%20dei%20risultati%20conterr%C3%A0%20i%20numeri%20da%201%20a%2050%20in%20ciascuna%20delle%20due%20colonne.%3C%2FP%3E%0A%3CP%3EEsiste%20uno%20script%20di%20tabella%20che%20ti%20consentir%C3%A0%20di%20reimpostare%20il%20contenuto%20della%20tabella.%3C%2FP%3E%0A%3CP%3EIn%20pratica%20esistono%203%20possibili%20modalit%C3%A0%20di%20guasto%3A%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3EVengono%20visualizzati%20uno%20o%20pi%C3%B9%20messaggi%20%22impossibile%20ottenere%20l'indicatore%20di%20fine%20file%22.%20Questo%20errore%20si%20verifica%20durante%20il%20salvataggio%20e%20non%20%C3%A8%20possibile%20salvare%20i%20risultati.%20Pertanto%20ci%20saranno%20alcuni%20valori%20mancanti%20nella%20tabella%20dei%20risultati.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLI%3E%0A%3CLI%3EAd%20un%20certo%20punto%2C%20la%20tabella%20dei%20risultati%20svanir%C3%A0.%20Se%20il%20file%20non%20viene%20trovato%2C%20gli%20script%20interrompono%20l'esecuzione%20con%20il%20messaggio%20%22file%20non%20trovato%22.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLI%3E%0A%3CLI%3EOccasionalmente%2C%20entrambi%20gli%20script%20non%20riescono%20a%20ottenere%20un%20blocco%20sulla%20tabella.%20Ci%C3%B2%20%C3%A8%20indicato%20da%20entrambi%20gli%20script%20che%20effettuano%20500%20tentativi%20per%20ottenere%20un%20blocco.%20Se%20interrompi%20gli%20script%20e%20poi%20provi%20ad%20aprire%20la%20tabella%20dei%20risultati%2C%20avr%C3%A0%20una%20variabile%20di%20tabella%20%3CEM%3Efile_lock%3C%2FEM%3E%20.%20Entrambe%20le%20istanze%20di%20JMP%20avranno%20la%20tabella%20bloccata.%20L'unico%20modo%20per%20sbloccarlo%20%C3%A8%20chiudere%20entrambe%20le%20sessioni%20di%20JMP.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E50%20iterazioni%20sono%20generalmente%20sufficienti%20per%20osservare%20(1)%20e%20(2)%2C%20ma%20occasionalmente%20%C3%A8%20necessario%20aumentare%20il%20numero%20di%20iterazioni%20per%20vedere%20(2).%20Lo%20scenario%20(3)%20%C3%A8%20pi%C3%B9%20probabile%20con%20centinaia%20di%20iterazioni%20e%20con%20l'attesa%20sulla%20linea%20100%20rimossa.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-743739%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Come%20visualizzare%20il%20messaggio%20%22File%20in%20uso%22.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743739%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EDurante%20i%20test%20trovo%20uno%20scenario%20in%20cui%20posso%20aprire%20la%20tabella%20senza%20alcun%20messaggio%20in%20%3CSTRONG%3Esavelog%3C%2FSTRONG%3E%20%2C%20ma%20quando%20arrivo%20al%20salvataggio%20ricevo%20un%20errore%20%22Impossibile%20ottenere%20l'indicatore%20di%20fine%20file%22.%20Ci%C3%B2%20non%20solo%20impedisce%20il%20salvataggio%20dei%20dati%20pi%C3%B9%20recenti%2C%20ma%20l'intero%20file%20scompare%20e%20tutti%20i%20dati%20vengono%20persi.%3C%2FP%3E%0A%3CP%3ENell'ambiente%20di%20test%20ho%202%20script%2C%20identici%20tranne%20che%20uno%20script%20aggiorna%20la%20prima%20colonna%20della%20tabella%20e%20il%20secondo%20script%20aggiorna%20la%20seconda%20colonna.%20Ogni%20script%20tenta%20di%20aggiornare%20la%20tabella%20100%20volte.%20Se%20open%20segnala%20(tramite%20%3CEM%3Esavelog%3C%2FEM%3E%20)%20che%20la%20tabella%20%C3%A8%20bloccata%2C%20attende%20e%20riprova%20(sulla%20falsariga%20del%20mio%20script%20originale).%20Tuttavia%2C%20forse%20una%20o%20due%20volte%20su%20100%20tentativi%20si%20verificher%C3%A0%20un%20errore%20di%20marcatura%20della%20fine%20del%20file.%20Ci%C3%B2%20potrebbe%20verificarsi%20all'apertura%20del%20file%20(con%20il%20test%20%3CEM%3Edel%20registro%20di%20salvataggio%3C%2FEM%3E%20)%20o%20al%20salvataggio%20dei%20risultati%20(chiusura%20e%20salvataggio%20presupponendo%20che%20sia%20disponibile%20l'accesso%20in%20scrittura).%20Ho%20implementato%20un%20test%20%3CEM%3Edi%20salvataggio%3C%2FEM%3E%20simile%20alla%20chiusura%2C%20ma%20a%20quel%20punto%20%C3%A8%20troppo%20tardi%2C%20il%20danno%20%C3%A8%20fatto.%3C%2FP%3E%0A%3CP%3ELa%20mia%20esperienza%20con%20questo%20errore%20%C3%A8%20che%20se%20lo%20ottieni%20mentre%20provi%20a%20salvare%20i%20risultati%20sei%20in%20grossi%20guai%20e%20rischi%20di%20perdere%20completamente%20la%20tabella.%20Quindi%20provo%20a%20concentrarmi%20sull'eliminazione%20dell'errore%20che%20si%20verifica%20in%20prima%20istanza%20cercando%20di%20ottenere%20in%20modo%20affidabile%20l'accesso%20in%20lettura%20e%20scrittura%20all'apertura%20della%20tabella.%20Il%2099%25%20delle%20volte%20ci%20riesco%2C%20ma%20alla%20fine%20riesco%20sempre%20a%20ottenere%20l'errore.%20Sospetto%20che%20ci%C3%B2%20che%20accade%20sia%20che%20ci%20sia%20una%20minima%20possibilit%C3%A0%20che%20entrambi%20gli%20script%20ottengano%20l'accesso%20in%20lettura%20e%20scrittura%20al%20file%20(almeno%2C%20come%20riportato%20da%20savelog)%20ma%20a%20un%20certo%20punto%20uno%20script%20mantiene%20l'accesso%20in%20lettura%20e%20scrittura%20e%20l'altro%20script%20ottiene%20la%20fine%20del%20file%20errore%20marcatore%20-%20probabilmente%20quando%20l'altro%20script%20ha%20effettuato%20un%20aggiornamento).%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%3ERe%3A%20Come%20visualizzare%20il%20messaggio%20%22File%20in%20uso%22.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-749493%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EScusa%2C%20ne%20ho%20perso%20traccia.%20Ho%20realizzato%20un%20video%20della%20tabella%20dati%20che%20scompare%20dal%20desktop%20e%20l'ho%20inviato%20al%20team%20di%20sviluppo.%20Grazie!%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