VFP9SP2 app/Win10 Pro workstation/Win2012 Server
Got a bug report from a client today that threw a 108 "File is in use by another user" on an INSERT INTO statement (all VFP9 dbc tables). Found it interesting that the VFP Help file says that's on a USE, DELETE, or RENAME command (but not INSERT INTO).
INSERT INTO has to be doing an implicit USE, don't you think?
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of mbsoftwaresolutions@mbsoftwaresolutions.com Sent: Thursday, March 15, 2018 8:32 PM To: profoxtech@leafe.com Subject: Error 108 on an INSERT INTO MyVFPTable
VFP9SP2 app/Win10 Pro workstation/Win2012 Server
Got a bug report from a client today that threw a 108 "File is in use by another user" on an INSERT INTO statement (all VFP9 dbc tables). Found it interesting that the VFP Help file says that's on a USE, DELETE, or RENAME command (but not INSERT INTO).
[excessive quoting removed by server]
I didn't test it and didn't use it in many years, but could be possible that the table had a file lock (not record lock) by this another user?
Don't know if the message is the same or something more like "table header is locked by another user"
El vie., 16 mar. 2018 4:30, mbsoftwaresolutions@mbsoftwaresolutions.com escribió:
On 2018-03-15 21:15, Richard Kaye wrote:
INSERT INTO has to be doing an implicit USE, don't you think?
I can't tell if the table was open, and if not, your logic is reasonable, but if it WAS already open, ????
[excessive quoting removed by server]
On 16/03/2018 06:34, Fernando D. Bozzo wrote:
I didn't test it and didn't use it in many years, but could be possible that the table had a file lock (not record lock) by this another user?
Don't know if the message is the same or something more like "table header is locked by another user"
I have been using insert into <mytable> from memvar for years with our accounts package Pegasus Opera and all worked fine until we upgraded to Opera 3. We occasionally get the same error trying to insert a stock transaction say. All tables are open by lots of people but we think it is Opera locking the table doing some sort of update that is stopping the command working.
Peter
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715
London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
I don't know why this happens, but I can say our customers will sometimes get it. We open our tables Shared with Table Buffering in the Dataesssion of the form. We have had standalone installs have this error. (local machine, data is not shared) I suspect it has something to do with an anti-virus or on demand backup software that causes the behavior. After we exclude the DBF, CDX and FPT files, and remove the backup software that doesn't really stop temporarily locking the files, we don't hear from them with that particular issue again.
Good luck finding the culprit.
Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of mbsoftwaresolutions@mbsoftwaresolutions.com Sent: Thursday, March 15, 2018 8:32 PM To: profoxtech@leafe.com Subject: Error 108 on an INSERT INTO MyVFPTable
VFP9SP2 app/Win10 Pro workstation/Win2012 Server
Got a bug report from a client today that threw a 108 "File is in use by another user" on an INSERT INTO statement (all VFP9 dbc tables). Found it interesting that the VFP Help file says that's on a USE, DELETE, or RENAME command (but not INSERT INTO).
... I always forget the antivirus thing. Yes! nothing more intrusive like that!
El vie., 16 mar. 2018 14:53, Tracy Pearson tracy@powerchurch.com escribió:
I don't know why this happens, but I can say our customers will sometimes get it. We open our tables Shared with Table Buffering in the Dataesssion of the form. We have had standalone installs have this error. (local machine, data is not shared) I suspect it has something to do with an anti-virus or on demand backup software that causes the behavior. After we exclude the DBF, CDX and FPT files, and remove the backup software that doesn't really stop temporarily locking the files, we don't hear from them with that particular issue again.
Good luck finding the culprit.
Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of mbsoftwaresolutions@mbsoftwaresolutions.com Sent: Thursday, March 15, 2018 8:32 PM To: profoxtech@leafe.com Subject: Error 108 on an INSERT INTO MyVFPTable
VFP9SP2 app/Win10 Pro workstation/Win2012 Server
Got a bug report from a client today that threw a 108 "File is in use by another user" on an INSERT INTO statement (all VFP9 dbc tables). Found it interesting that the VFP Help file says that's on a USE, DELETE, or RENAME command (but not INSERT INTO).
[excessive quoting removed by server]
Tablevalidate() ???? Cant find this in VFP help, how to use? Regards, Koen
2018-03-16 15:11 GMT+01:00 Fernando D. Bozzo fdbozzo@gmail.com:
... I always forget the antivirus thing. Yes! nothing more intrusive like that!
El vie., 16 mar. 2018 14:53, Tracy Pearson tracy@powerchurch.com escribió:
I don't know why this happens, but I can say our customers will sometimes get it. We open our tables Shared with Table Buffering in the Dataesssion of the form. We have had standalone installs have this error. (local machine, data is not shared) I suspect it has something to do with an anti-virus or on demand backup software that causes the behavior. After we exclude the DBF, CDX and FPT files, and remove the backup
software
that doesn't really stop temporarily locking the files, we don't hear
from
them with that particular issue again.
Good luck finding the culprit.
Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of mbsoftwaresolutions@mbsoftwaresolutions.com Sent: Thursday, March 15, 2018 8:32 PM To: profoxtech@leafe.com Subject: Error 108 on an INSERT INTO MyVFPTable
VFP9SP2 app/Win10 Pro workstation/Win2012 Server
Got a bug report from a client today that threw a 108 "File is in use by another user" on an INSERT INTO statement (all VFP9 dbc tables). Found it interesting that the VFP Help file says that's on a USE, DELETE, or RENAME command (but not INSERT INTO).
[excessive quoting removed by server]
It's a SET function. You should be able to find that in the help.
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Koen Piller Sent: Friday, March 16, 2018 12:16 PM To: profoxtech@leafe.com Subject: Re: Error 108 on an INSERT INTO MyVFPTable
Tablevalidate() ???? Cant find this in VFP help, how to use? Regards, Koen
2018-03-16 15:11 GMT+01:00 Fernando D. Bozzo fdbozzo@gmail.com:
... I always forget the antivirus thing. Yes! nothing more intrusive like that!
El vie., 16 mar. 2018 14:53, Tracy Pearson tracy@powerchurch.com escribió:
I don't know why this happens, but I can say our customers will sometimes get it. We open our tables Shared with Table Buffering in the Dataesssion of the form. We have had standalone installs have this error. (local machine, data is not shared) I suspect it has something to do with an anti-virus or on demand backup software that causes the behavior. After we exclude the DBF, CDX and FPT files, and remove the backup
software
that doesn't really stop temporarily locking the files, we don't hear
from
them with that particular issue again.
Good luck finding the culprit.
Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of mbsoftwaresolutions@mbsoftwaresolutions.com Sent: Thursday, March 15, 2018 8:32 PM To: profoxtech@leafe.com Subject: Error 108 on an INSERT INTO MyVFPTable
VFP9SP2 app/Win10 Pro workstation/Win2012 Server
Got a bug report from a client today that threw a 108 "File is in use by another user" on an INSERT INTO statement (all VFP9 dbc tables). Found it interesting that the VFP Help file says that's on a USE, DELETE, or RENAME command (but not INSERT INTO).
[excessive quoting removed by server]
_______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACUu1StR0ujQNzomWLfu8dcovVexEGz-xOr5... ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious. Report [OT] Abuse: http://leafe.com/reportAbuse/CACUu1StR0ujQNzomWLfu8dcovVexEGz-xOr5sv6m-HF0Jd...
What's your setting of TABLEVALIDATE? I have seen reports of this error on APPEND BLANK when SET TABLEVALIDATE is not 0.
Frank.
Frank Cazabon
On 15/03/2018 08:32 PM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
VFP9SP2 app/Win10 Pro workstation/Win2012 Server
Got a bug report from a client today that threw a 108 "File is in use by another user" on an INSERT INTO statement (all VFP9 dbc tables). Found it interesting that the VFP Help file says that's on a USE, DELETE, or RENAME command (but not INSERT INTO).
[excessive quoting removed by server]
Mike,
did you ever solve this?
Frank.
Frank Cazabon
On 15/03/2018 08:32 PM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
VFP9SP2 app/Win10 Pro workstation/Win2012 Server
Got a bug report from a client today that threw a 108 "File is in use by another user" on an INSERT INTO statement (all VFP9 dbc tables). Found it interesting that the VFP Help file says that's on a USE, DELETE, or RENAME command (but not INSERT INTO).
[excessive quoting removed by server]
Hi Frank,
Nope. Still a mystery. Rarely happens so not on the "urgent" list.
--Mike
On 2018-03-20 07:57, Frank Cazabon wrote:
Mike,
did you ever solve this?
Frank.
Frank Cazabon
On 15/03/2018 08:32 PM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
VFP9SP2 app/Win10 Pro workstation/Win2012 Server
Got a bug report from a client today that threw a 108 "File is in use by another user" on an INSERT INTO statement (all VFP9 dbc tables). Found it interesting that the VFP Help file says that's on a USE, DELETE, or RENAME command (but not INSERT INTO).
-
Fernando D. Bozzo -
Frank Cazabon -
Koen Piller -
mbsoftwaresolutions＠mbsoftwaresolutions.com -
Peter Cushing -
Richard Kaye -
Tracy Pearson