Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Set fields problem
Message
De
13/04/2007 19:15:28
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Set fields problem
Divers
Thread ID:
01215867
Message ID:
01215867
Vues:
66
I have the following code sequence:
select tblRawData
	
set filter to PermID == lcPermID and ((LoDrive + HiDrive)/2 + (LoCpool + HiCpool)/2 + ;
	(LoBike + HiBike)/2 + (LoBus + HiBus)/2 + (LoWalk + HiWalk)/2 + ;
	(LoAtHome + HiAtHome)/2 + (LoField + HiField)/2 + (LoOther + HiOther)/2) > 7

go top
if ! eof()
	messagebox("The following records need to be checked for Mode Use over 7.")
	set fields to permid,Sequence, Company, LinkField, ;
	LoDrive, HiDrive, ;
	LoCpool, HiCpool, ;
	LoBike, HiBike, ;
	LoBus, HiBus, ;
	LoWalk, HiWalk, ;
	LoAtHome, HiAtHome, ;
	LoField, HiField, ;
	LoOther, HiOther, ;
	InDrive, LoDrive, HiDrive, ;
	InBike, LoBike, HiBike, ;
	InWalk, LoWalk, HiWalk, ;
	SpOther, InOther, LoOther, HiOther, ;
	InCpool, LoCpool, HiCpool, ;
	InBus, LoBus, HiBus, ;
	InAtHome, LoAtHome, HiAtHome, ;
	InField, LoField, HiField 
	browse
	set fields to all
endif
This produces an error on the browse to the effect that "variable permid is not found".
Any ideas as to what is causing this? The sequence works fine if I delete the set fields statement. permid is a character field and does exist in the table.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform