MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-749394822-1228847815=:78166"
--0-749394822-1228847815=:78166
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
this is the 2nd=A0Posting, the first one was unclear..=0A=0AWe have=A0 prob=
lems with one of VFP TABLE , it give an intermittent error message like thi=
s=0A=0AIndex file "\\lrd1fil2\vfpprod\mw\mwdata\profile.cdx" is corrupted. =
Please rebuild it.=A0=A0 =0A=A0=0Awe are rebuilding the PROIFLE.DBF often ;=
sometimes every 2 days=A0 by using these commands:=0A=A0=0Afor example: =
=0A=A0=0AUSE=A0 R:\MWDATA\PROFILE=A0 in 0 =0Aselect profile=0Acopy to c:\da=
ta\PROFILE.dbf=0A=A0USE C:\DATA\PROFILE IN 0 EXCL=0A=A0=0Ahere we rebuild t=
he indexes like=A0 this:=0A=A0=0AINDEX ON=A0 CASE_ID TAG CASE_ID=0AINDEX ON=
=A0 CUST_ID TAG CUST_ID=0Aetc..=0A=A0=0APROIFLE has about 29 index tags and=
profile.dbf is about=A0 1.1 gig in size=0A=A0=0Awe are able to=A0 add and=
=A0update records=A0most of the time but sometime we are=A0getting the erro=
r message above =0Afrom different processes:=0A=A0=0A1) =A0 A batch process=
trying to update the DBF=A0 with an update statement like=A0 this:=0A=0A=
=A0=A0=A0=A0 UPDATE=A0=A0(lcUpdateTable) ;=0A=A0=A0=A0 SET &lcUpdate WHERE=
=0A=A0=A0=A0 case_id =3D &lcCurRecord..case_id=0A=A0=0A=A0=A0=A0=A0Error ge=
t generated=A0like 7 times between mid November to first December=0A=A0=0A2=
)=A0A=A0form Querying the table ( Select statement include Profile and othe=
r table)=0A=A0=A0=A0=A0 Error generated like=A0 4 times=A0 between mid Nove=
mber to first December=0A=A0=0AAny ideas?=0A=A0=0AThanks,=0AJean=0Ajhhaidar=
@sbcglobal.net=0A
--0-749394822-1228847815=:78166
Content-Type: text/html; charset=us-ascii
<html><head><style type="text/css"><!-- DIV {margin:0px;}
--></style></head><body><div style="font-family:times new roman, new york,
times, serif;font-size:12pt"><DIV>this is the 2nd Posting, the first one
was unclear..</DIV>
<DIV> </DIV>
<DIV>We have problems with one of VFP TABLE , it give an intermittent
error message like this<BR><BR>Index file
"\\lrd1fil2\vfpprod\mw\mwdata\profile.cdx" is corrupted. Please rebuild
it. <BR> <BR>we are rebuilding the PROIFLE.DBF often ;
sometimes every 2 days by using these commands:<BR> <BR>for example:
<BR> <BR>USE R:\MWDATA\PROFILE in 0 <BR>select profile<BR>copy
to c:\data\PROFILE.dbf<BR> USE C:\DATA\PROFILE IN 0 EXCL<BR> <BR>here
we rebuild the indexes like this:<BR> <BR>INDEX ON CASE_ID TAG
CASE_ID<BR>INDEX ON CUST_ID TAG CUST_ID<BR>etc..<BR> <BR>PROIFLE has
about 29 index tags and profile.dbf is about 1.1 gig in
size<BR> <BR>we are able to add and update records most of
the time but sometime we are getting the error message above <BR>from
different processes:<BR> <BR><STRONG>1) A batch process trying to
update the
DBF with an update statement like this:</STRONG></DIV>
<DIV><BR> <STRONG> UPDATE (lcUpdateTable)
;</STRONG></DIV>
<DIV><STRONG> SET &lcUpdate WHERE<BR>
case_id =
&lcCurRecord..case_id<BR></STRONG> <BR> <STRONG>
Error get generated like 7 times between mid November to first
December<BR></STRONG> <BR>2) <STRONG>A form Querying the table (
Select statement include Profile and other table)<BR>
Error generated like 4 times between mid November to first
December</STRONG><BR> <BR>Any ideas?<BR> <BR>Thanks,<BR>Jean<BR><A
href="mailto:[EMAIL PROTECTED]" ymailto="mailto:[EMAIL PROTECTED]"><SPAN
class=yshortcuts id=lw_1228847205_0>[EMAIL
PROTECTED]</SPAN></A><BR></DIV></div></body></html>
--0-749394822-1228847815=:78166--
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** 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.
