Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Database keep geting corrupted, why ?
Message
 
To
03/12/1998 23:22:14
Larry Long
ProgRes (Programming Resources)
Georgia, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00163399
Message ID:
00164023
Views:
28
>>Luis,
>>What is being returned by your TableUpdate() command? If it is FALSE then there may be a problem with network access or with the primary key (as JohnK suggested).
>>
>>HTH
>>Barbara
>>
>>>Hello everybody,
>>>I have a table that keep on geting corrupted from time
>>>to time, this is weird, it looks fine, but I know is
>>>corrupted because I can't use BEGIN TRANS/END TRANS.
>>>It just doesn't save the information ,
>>>If I do something like this from the command line :
>>>
>>>USE MyTable
>>>=cursorsetprop("BUFFERING",5)
>>>
>>>BEGIN TRANS
>>> APPEND BLANK
>>> =TABLEUPDATE()
>>>END TRANS
>>>
>>>As soon as I do the END TRANSACTION the appended record
>>>is lost and the pointer moves to EOF. I have recreated from
>>>scratch both the container and the table, it works fine
>>>for a couple days and then it crash again. Any Ideas ?
>>>
>>>=this.thanks('in advance')
>1) You should be using a "INSERT INTO..." with at least the primary key field assigned. This will prevent possible errors from coming up if you happen to have another blank record in the table, which is often "deleted".
>2) After the END TRANSCATION try issuing...
>=RLOCK()
>UNLOCK

I think I got it, I found two containers, each one with tables
of the same name in the same directory, of course, one of it only
had the definition of the table but not the physical file.
So far it is working properly.

Thanks for all your help.
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform