Error 108 on an INSERT INTO MyVFPTable

Discussion:

m***@mbsoftwaresolutions.com

2018-03-16 00:32:08 UTC

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).

_______________________________________________
Post Messages to: ***@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/***@mbsoftwaresolutions.com
** 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.

Richard Kaye

2018-03-16 01:15:11 UTC

Permalink

INSERT INTO has to be doing an implicit USE, don't you think?

--

rk

-----Original Message-----
From: ProfoxTech <profoxtech-***@leafe.com> On Behalf Of ***@mbsoftwaresolutions.com
Sent: Thursday, March 15, 2018 8:32 PM
To: ***@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: ***@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/***@DM5PR10MB1244.namprd10.prod.outlook.com
** 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.

m***@mbsoftwaresolutions.com

2018-03-16 03:30:48 UTC

Permalink

Post by Richard Kaye
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, ????

_______________________________________________
Post Messages to: ***@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/***@mbsoftwaresolutions.com
** 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.

Fernando D. Bozzo

2018-03-16 06:34:24 UTC

Permalink

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"

Post by m***@mbsoftwaresolutions.com

Post by Richard Kaye
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, ????

Peter Cushing

2018-03-16 10:18:28 UTC

Permalink

Post by Fernando D. Bozzo
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

_______________________________________________
Post Messages to: ***@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/810aa7b4-b769-ac54-4913-***@whisperingsmith.com
** 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 t

Tracy Pearson

2018-03-16 13:53:02 UTC

Permalink

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-***@leafe.com] On Behalf Of
***@mbsoftwaresolutions.com
Sent: Thursday, March 15, 2018 8:32 PM
To: ***@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).

_______________________________________________
Post Messages to: ***@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/000001d3bd2e$1a465ac0$4ed31040$@powerchurch.com
** 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.

Fernando D. Bozzo

2018-03-16 14:11:38 UTC

Permalink

... I always forget the antivirus thing. Yes! nothing more intrusive like
that!

Post by Tracy Pearson
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-----
Sent: Thursday, March 15, 2018 8:32 PM
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).

Koen Piller

2018-03-16 16:16:26 UTC

Permalink

Tablevalidate() ????
Cant find this in VFP help, how to use?
Regards,
Koen

Post by Fernando D. Bozzo
... I always forget the antivirus thing. Yes! nothing more intrusive like
that!

software

Post by Tracy Pearson
that doesn't really stop temporarily locking the files, we don't hear

from

Post by Tracy Pearson
them with that particular issue again.
Good luck finding the culprit.
Tracy
-----Original Message-----
Sent: Thursday, March 15, 2018 8:32 PM
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).

Richard Kaye

2018-03-16 16:21:53 UTC

Permalink

It's a SET function. You should be able to find that in the help.
--
rk

-----Original Message-----
From: ProfoxTech <profoxtech-***@leafe.com> On Behalf Of Koen Piller
Sent: Friday, March 16, 2018 12:16 PM
To: ***@leafe.com
Subject: Re: Error 108 on an INSERT INTO MyVFPTable

Tablevalidate() ????
Cant find this in VFP help, how to use?
Regards,
Koen

Post by Fernando D. Bozzo
... I always forget the antivirus thing. Yes! nothing more intrusive like
that!

software

Post by Tracy Pearson
that doesn't really stop temporarily locking the files, we don't hear

from

[excessive quoting removed by server]

_______________________________________________
Post Messages to: ***@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-xOr5sv6m-***@mail.gmail.com
** 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-***@mail.gmail.com
_______________________________________________
Post Messages to: ***@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/***@DM5PR10MB1244.namprd10.prod.outlook.com
** 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 lawye

Frank Cazabon

2018-03-16 14:08:47 UTC

Permalink

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

Post by m***@mbsoftwaresolutions.com
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).

Frank Cazabon

2018-03-20 11:57:39 UTC

Permalink

Mike,

did you ever solve this?

Frank.

Frank Cazabon

m***@mbsoftwaresolutions.com

2018-03-22 19:03:06 UTC

Permalink

Hi Frank,

Nope. Still a mystery. Rarely happens so not on the "urgent" list.

--Mike

Post by Frank Cazabon
Mike,
did you ever solve this?
Frank.
Frank Cazabon

_______________________________________________
Post Messages to: ***@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/***@mbsoftwaresolutions.com
** 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 t