Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Codes modification
Message
From
13/04/2007 05:58:41
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Codes modification
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01215417
Message ID:
01215417
Views:
65
Dear Experts

I have a dbf named Bank. Following codes work fine when dbf is opend exclusively.
How will these codes work when dbf is not open exclusively. In other words please modify these codes to work in multiuser environmnet.
	SELECT * FROM bank ORDER BY bankname INTO table bbank

	SELECT banks
	ZAP
	APPEND FROM DBF("bbnks") && this will change natural sort order

	select banks
	set order to
	go top
	aa=1
	do while !eof()
		replace code with aa  && code is changed according to bank alphabetic sort order
		skip
		aa=aa+1
		loop
	ENDDO
Next
Reply
Map
View

Click here to load this message in the networking platform