Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Mass updating of server database
Message
 
À
16/11/1998 13:32:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00157908
Message ID:
00157917
Vues:
18
>Hiya Ed ---
>
>Always bombs out on the same relative record. So if I delete that record, it'll still bomb on the "n-th" record....
>
>
>>>Hi All ---
>>>
>>>Have an interesting problem.....trying to update a SQL Server table via a remote view. The view is built using INSERT INTO within a SCAN of a local table of about 28,000 records. At about record 27,000 VFP generates an Invalid Page Fault in VFP.EXE and dies. Now this happens regardless of buffer mode and the record it dies out is perfectly valid.
>>>
>>>Any ideas?
>>
>>Does it always bomb on the same record? If so, I would try to delete it and run again.

Is the local table indexed? It could be something with index in that case. I remember that once I had similar thing, and re-creating index helped.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform