Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with sorted table
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Problem with sorted table
Divers
Thread ID:
00546949
Message ID:
00546949
Vues:
39
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform