>>I got it again even with SET EXCLUSIVE OFF on replace mNotes with m.lcString in Load_Trans command.
>>
>>I'll get new copy of data and will resume my tests.
>
>Either you have corrupted data/indexes or it's a network problem. Does it happens on particular PC only?
I loaded a file with 4K records in 41 min. Then I tried another file with ~8K records and got Invalid Seek Offset on SEEK(PK,'Load_Doctors',"Index") command. I'm inserting records into lots of tables including Doctors.
I also found, that though this error is caught by try/catch, it reproduces itself again.
I may put some special handling for this error, say, tablerevert of everything. Still, what may cause it and how can I avoid it?
Thanks.
If it's not broken, fix it until it is.
My Blog