Bug? on insert into previously deleted recid
Tim James
tjames1 at bigpond.net.au
Tue May 4 19:33:00 CDT 2004
Well I tried this and no luck- some pointers appear to get confused or
at least I had some finger trouble
However I still have the field in the table defined as string(40)
indexed where if I insert into a previously deleted recid it does not
alter the fields value but keeps the value of the previously deleted
field
However if I update the record after this the field is changed and is
accessible, indexed etc
Doesn't this look like a bug rather than a db corruption ?
I am still facing an overnight stay at my client for a dumpxml/loaddump
if I can't find a solution quickly (I am currently remotely fixing any
errors that occurred during the day each night !!)
TIA
On 29/04/2004, at 5:05 PM, Ruslan Zasukhin wrote:
> On 4/29/04 6:32 AM, "Tim James" <tjames1 at bigpond.net.au> wrote:
>
>> I started to loaddump and it appears it will take 24 hours to complete
>>
>> Would it be possible to
>>
>> 1.export all tables to files
>>
>> 2.delete all records from all tables
>>
>> 3.dump db via dumpxml
>>
>> 4.reload dump.xml to create a clean new empty DB
>>
>> 5. import all tables back into the new DB
>>
>>
>> (I presume (hope) that import doesn't look at OBjptrs or changes
>> recids)
>>
>> Is this a safe way to proceed ??
>
> Yes!
>
> --
> Best regards,
> Ruslan Zasukhin [ I feel the need...the need for speed ]
> -------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
>
> To subscribe to the Valentina mail list go to:
> http://lists.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
More information about the Valentina
mailing list