Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Record is out of range
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01173246
Message ID:
01173320
Vues:
9
Hi again, Naomi.

>Thanks a lot for your reply.

You're welcome :^).

>This is actually not my code, I'm just trying to make it work.

Okay. Let's see if we can make that happen :^).

>Basically, originally the table is in particular order and it's scanned
>while code = lcCode FOR some criteria.

Gotcha.

>In the middle of the scan loop there is another procedure called that sums
>records from the same table using different order.

Okay. As I'm sure we're both well aware, this is going to change the record
pointer, and this is why you save it, of course :^)

>Then I restore the order and the record pointer.
>
>However, I found, that my table doesn't have an order set at the moment of this error,
>which is strange, since I have SET ORDER TO 1 in the loop...

Hmmm. Are you setting the INDEX before you call SCAN? Also, I'm
starting to wonder if the SCAN call doesn't like the ORDER being
changed on the fly.

Just out of curiosity (and if this is possible without a big rewrite),
set the NOOPTIMIZE flag in the SCAN call and turn off all indexing <g> and
tell us if it works.

I'm starting to wonder if it's a corrupt index....

Regards,

Randall
--
Randall Jouett
Amateur/Ham Radio: AB5NI
I eat spaghetti code out of a bit bucket while sitting at a hash table! Someone
asked me if I needed salt, and I said, "I'm not into encryption." :^)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform