V4RB 1 - Win corrupt table not corrupt in Mac

[Ruslan Zasukhin]

On 6/6/05 6:06 AM, "Tim James" <tjames1 at bigpond.net.au> wrote:

Hi Tim,
 
> I have a DB that was causing a hard crash of a Win XP application when
> I tried to insert records into one particular table.
> 
> The db table used to accept insert - application is running on Win XP
> (at 40+ sites also)
> 
> After much debugging by copying the folder containing the .vdb, .ind,
> .dat files to a mac I could find nothing
> 
> I then discovered that when I tried the insert on the XP machine (after
> a 2 hour car journey) - I could replicate the crash, but doing the same
> insert on a mac version using the copied DB no crash would occur?
> 
> I then deleted all records from that table and the problem was solved.
> 
> Previously I had reindexed (by command and dumping .ind file), diagnose
> - no errors found, Select * from the table all to no avail.
> 
> 
> Does this make sense to anyone (or Ruslan?).

Well, if db was created on MAC, then windows work in different way, it needs
swap bytes.
 
> What is the best procedure for such a case
> 
> XMLDump table and reload

Yes, because you get totally fresh database.
 
> delete table and redefine in ADD Table command?

This can fix only one table,
Also you can do this only if this table do not have links to other tables.
 
> insert into [backup duplicate table] with select from clause   ?



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]