Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Invalid Seek Offset - reproducible
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01137918
Message ID:
01138223
Vues:
20
I copied data from production backup to my local drive. Every time I'm trying to do either ProcessNewTrans or LoadNewTrans on a big file I get this error when I run the process the second time. I'm using private datasession (session class), Delete ON, tablevalidate = 7

>>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.
>
>Naomi - I had that a long time ago - I forget what I did, but, try this,
>
>1) open your DBF
>2) delete all the tags (delete tag (mytagname))
>3) SORT on the primary or most used look up field or fields to a temp dbf (set dele on so deleted records will be ignored) - make your physical order your primary order.
>4) ZAP your "permant" DBF
>5) APpend your tmp dbf to it
>6) index each tag
>
>Is it a local DBF - or on a server someplace?
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform