Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Mass updating of server database
Message
 
To
16/11/1998 13:32:53
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00157908
Message ID:
00157917
Views:
19
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform