Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Mass updating of server database
Message
From
16/11/1998 23:07:43
 
 
To
16/11/1998 13:20:21
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00157908
Message ID:
00158124
Views:
14
>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 your local table contains a memo field ?
if yes, make sure that the field in the SQL is TEXT type.
System Analyst
Nabil B. Ghrayyeb
nabilg@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform