lost of records

[Michel BRICQ]

i have an application who runs on server with 20 PC, some PC use old programs in dbase 4 and others in DABASE PLUS.
we were under WINDOWS 98 and have no problems
The PCs have been changed and now run under WINDOWS XP
When a record is created on a PC XP, instead of add a record to the base, the system use an recent record, blank every field and put values of the new record in this old record

Has anyone already seen this problem and can help
with thanks

[Mervyn Bick]

On Mon, 13 Oct 2008 15:23:56 +0200, Michel BRICQ

Post by Michel BRICQ
i have an application who runs on server with 20 PC, some PC use old
programs in dbase 4 and others in DABASE PLUS.
we were under WINDOWS 98 and have no problems
The PCs have been changed and now run under WINDOWS XP
When a record is created on a PC XP, instead of add a record to the
base, the system use an recent record, blank every field and put values
of the new record in this old record
Has anyone already seen this problem and can help
with thanks

Sounds most disconcerting and, of course, it shouldn't happen.

Do all the programs corrupt your data or is it only the dBase IV or only
the dBase Plus programs?

When a record gets reused, is it the last record that the operator had
looked at or is a random record?

Does this happen every time or only some times?

Does it happen on all the PCs or only on some?

Is the coding in the dBase Plus programs done in OODML or is it still in
the old DML like the dBase IV programs?

Do the dBase IV programs have the same functionality as the dBase Plus
programs or are there different programs doing different things? For
instance, some dealing with debtors, some with creditors and some with
stock control but with all accessing the same database.

Do problems only arise when new records are added but all other functions
such as reporting still work properly?

Mervyn.

[Mervyn Bick]

My dBase Plus programs are used only for query, so it is my dBase IV
programs who corrupt the date
It isn\\\'t at each time
It is difficult to determine exactly when this happen because 20 PCs are
connected and more than one hundred of records are created daily
I try with only dBase IV programs used
technician A create record on PC WindowsXP : no problem
technician B create record on PC Windows98 : the record is saved, the
technician print a paper with information on this record, so we know the
record exist
technician A create a new record : this record use the place of the
record creat by technician B
we can\\\'t retrieve the record of the technician B
I put in the add file a copy of the list of record in natural order (on
the left) and order on tag NUINT (right column), you see that in the
indexed file record numbers 136641 to 136645 are duplicated (if I
reindex the file, this problem disappear but the records of technician B
are still lost
Thanks for your help

Firstly, I've never used dBase IV so I'm really just guessing here but not
knowing what I'm talking about has never stopped me in the past. <g>

The fact that records are shown twice in the indexed display although they
are not physically duplicated in the table and reindexing clears the
double display suggests to me that the problem is with the BDE. Check the
BDE settings and make quite sure that LOCAL SHARE is set to true on all
the machines.

Mervyn.

[Geoff Wass [dBVIPS]]

In article <***@news-server>, ***@libertysurf.fr
says...

My dBase Plus programs are used only for query, so it is my dBase IV programs who corrupt the date
It isn\\\'t at each time
It is difficult to determine exactly when this happen because 20 PCs are connected and more than one hundred of records are created daily
I try with only dBase IV programs used
technician A create record on PC WindowsXP : no problem
technician B create record on PC Windows98 : the record is saved, the technician print a paper with information on this record, so we know the record exist
technician A create a new record : this record use the place of the record creat by technician B
we can\\\'t retrieve the record of the technician B
I put in the add file a copy of the list of record in natural order (on the left) and order on tag NUINT (right column), you see that in the indexed file record numbers 136641 to 136645 are duplicated (if I reindex the file, this

problem disappear but the records of technician B are still lost

Thanks for your help

Michel,

How large are these tables? What is the index formula for the index that
is experiencing the problem? Are technician A and B using new computers
(fast CPUs)?

[Michel Bricq]

the table has 137000 records
with a mdx (7 index) index on one field

the computers are new (buy this year)

thanks for your help
i try today (after teh departure of the technicians) and i have the same problem when two PC using Windows XP create records simultaneously

Post by Geoff Wass [dBVIPS]
says...

My dBase Plus programs are used only for query, so it is my dBase IV programs who corrupt the date
It isn\\\'t at each time
It is difficult to determine exactly when this happen because 20 PCs are connected and more than one hundred of records are created daily
I try with only dBase IV programs used
technician A create record on PC WindowsXP : no problem
technician B create record on PC Windows98 : the record is saved, the technician print a paper with information on this record, so we know the record exist
technician A create a new record : this record use the place of the record creat by technician B
we can\\\'t retrieve the record of the technician B
I put in the add file a copy of the list of record in natural order (on the left) and order on tag NUINT (right column), you see that in the indexed file record numbers 136641 to 136645 are duplicated (if I reindex the file, this

problem disappear but the records of technician B are still lost

Thanks for your help

Michel,
How large are these tables? What is the index formula for the index that
is experiencing the problem? Are technician A and B using new computers
(fast CPUs)?
--
Geoff Wass [dBVIPS]
Montréal, Québec, Canada
.|.|.| dBASE info at http://geocities.com/geoff_wass |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.
.|.|.| IT Consultant http://Geoff_Wass.com |.|.|.

[Geoff Wass [dBVIPS]]

In article <***@news-server>, ***@libertysurf.fr
says...

Post by Michel Bricq
the table has 137000 records
with a mdx (7 index) index on one field
the computers are new (buy this year)
thanks for your help
i try today (after teh departure of the technicians) and i have the same problem when two PC using Windows XP create records simultaneously

Michel,

Which PCs have Windows 98 and which have Windows XP? Which PCs have the
dBASE DOS IV and which have dBASE PLUS? Now, which PCs are experiencing
the problem?

If you visit my site and click the "Gary White" button and then click
"DOS Stuff", read the description for IDXFIX.ZIP. Do you think it
applies to your version of dBASE IV?

[Bruce Beacham]

Post by Michel BRICQ
i have an application who runs on server with 20 PC, some PC use old
programs in dbase 4 and others in DABASE PLUS. we were under WINDOWS
98 and have no problems The PCs have been changed and now run under
WINDOWS XP When a record is created on a PC XP, instead of add a
record to the base, the system use an recent record, blank every
field and put values of the new record in this old record

What table level is used in the BDE on the XP machine? That may
affect how the DOS version sees the table.


Bruce Beacham

[BRICQ]

Level 4 but as I describe in the reply to Mervyn Bick the problem exist when only dBASE IV programs are used so I don't think the BDE is used in thes cases
The problem happens when records are created from PC using different Operating Systems : 98 and XP
Thanks for your help

Post by Bruce Beacham

Post by Michel BRICQ
i have an application who runs on server with 20 PC, some PC use old
programs in dbase 4 and others in DABASE PLUS. we were under WINDOWS
98 and have no problems The PCs have been changed and now run under
WINDOWS XP When a record is created on a PC XP, instead of add a
record to the base, the system use an recent record, blank every
field and put values of the new record in this old record

What table level is used in the BDE on the XP machine? That may
affect how the DOS version sees the table.
Bruce Beacham

[Bruce Beacham]

Post by BRICQ
Level 4 but as I describe in the reply to Mervyn Bick the problem
exist when only dBASE IV programs are used so I don't think the BDE
is used in thes cases The problem happens when records are created
from PC using different Operating Systems : 98 and XP

OK. In part my reply was driven by the damage that can be done when a
table is written or amended by a high version of dBASE. IIRC dBASE III
files are damaged by a write by a higher level. But I'd expect a
level 4 BDE not to damage dBASE IV files.

Pity you can't drive your client base with dBASE 5 for DOS - that was a
fine program.


Bruce