Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with sorted table
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Problem with sorted table
Miscellaneous
Thread ID:
00546949
Message ID:
00546949
Views:
35
Hi everybody,

I have a table, which is sorted by upper(State+OwnerCity+OwnerStrt+...). I have a button on my form called Manual Match, which allows to overwrite data with data from Streets lookups. This is a code fragment from this button:
	if m.llPerform
		replace OZipped with "M", ModiType with "C", ;
			OwnerCity with proper(Streets.City), ;
			OwnerState with Streets.State, ;
			OwnerZip5 with Streets.zip_code, ;
			OwnerPlus4 with Streets.zip4, ;
			OwnerCr_rt with Streets.carrier_rt, ;
			OwnerStrt with proper(Streets.street) in BldMstr
		if !eof()
		   skip
		else
		   if !bof()
		      skip -1   
		   endif   
		endif   
		this.parent.parent.refresh()
		.freshen()
		.nManualProcessed=.nManualProcessed+1
		.nProcessed = .nProcessed + 1
	endif
I found, that if I change data in Street with the Street, which would be next in sequence, I move to the same record. E.g. I have Wescott Rd, I change it to West St. and I'm sitting on West St. again after skip. I want to move to the following record instead. How can I simply achieve the desired behavior?
If it's not broken, fix it until it is.


My Blog
Next
Reply
Map
View

Click here to load this message in the networking platform