V4RB 1 - Win corrupt table not corrupt in Mac

[Tim James]

does this mean that it is better to create db on win rather than mac if 
win is target platform??
On 06/06/2005, at 3:22 PM, Ruslan Zasukhin wrote:

> 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]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>