Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table Auto Fill
Message
From
04/01/2006 06:44:48
 
 
To
04/01/2006 05:29:12
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01083029
Message ID:
01083050
Views:
14
Try this:
LOCAL i,lnMaxValue,lnAppend,lnRec

lnRec = 12 			&& 0,6,12,37

FOR i = 1 TO 10
	lnMaxValue = i*10
	IF m.lnRec < lnMaxValue
		EXIT
	endif
ENDFOR

lnAppend = m.lnMaxValue - m.lnRec

FOR i = 1 TO m.lnAppend
	APPEND BLANK 
endfor
>Dear Experts
>
>I want to fill table with blank records, with 10 records division, such as
>
>If Table has 0 records then 10 blank recods should automatically appended
>If Table has 6 records then 4 blank recods should automatically appended
>If Table has 12 records then 8 blank recods should automatically appended
>If Table has 37 records then 3 blank recods should automatically appended
>And so on…….
>
>Please help
Manoj Karki
manoj0karki@yahoo.com
Nepal
Previous
Reply
Map
View

Click here to load this message in the networking platform