Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query Causing Fatal Exception
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01062055
Message ID:
01062192
Views:
15
This message has been marked as a message which has helped to the initial question of the thread.
Chad,

If they're SPT cursor than it's unlikely that indexes got corrupted. I would try to rewrite UPDATE statement this way
UPDATE c_Store SET ;
		c_Store.nMin = c_MinMax.nMin ;
	FROM c_Store ;
		JOIN c_MinMax WITH (Buffering = .t.) ;
			ON c_Store.cGroup = c_MinMax.cGroup ;
	WHERE ;	
		c_Store.lLock = .f. ;
		AND c_MinMax.nMin > -1
>
>I guess that's technically possible, but it seems highly unlikely as c_Store and c_MinMax are both cursors created from SPT. But, there are indeed indexes placed on them after creation, so I'll look into that.
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform