Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBC Event Insufficient Stack Space?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00646636
Message ID:
00646654
Views:
19
I don't know why that was "crashing", but this works better. Can anyone recommend how I can make it tighter or chop off the bottom rows instead of the top ones?

Thanks.
Procedure dbc_BeforeCloseTable(cTableName)
If Upper(cTableName) = "CATLV"
	Select Count(iID) from (cTableName) where iDel=0 Into Array arCatLvCnt
	If arCatLvCnt[1] > 950
		iTop = ( arCatLvCnt[1] - 950)  
		Select iID from (cTableName) Where iDel=0 Order by iID Top (iTop) Into Array arOverCat
		For iCnt = 1 to Alen(arOverCat)
			? Alen(arOverCat)
			Update (cTableName) ;
				Set iDel=1 , cDelU = "SysCatTruncate" ;
				Where iID=( arOverCat[iCnt] )
		Next
		oDM.TUpdate(cTableName)
	EndIf
EndIf
EndProc
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform