Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select error
Message
De
06/07/2006 15:46:21
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Select error
Divers
Thread ID:
01134260
Message ID:
01134260
Vues:
57
The following command works fine:
select linkfile.*, aNodes.x as x1, aNodes.y as y1,;
	bNodes.x as x2, bNodes.y as y2,;
	abs(aNodes.x-bNodes.x) as dx, abs(aNodes.y-bNodes.y) as dy,;
	'  ' as stddir, ;
	'  ' as lh_node,;
	.f. as _used ;
	from linkfile ;
	left join (lcNodefile) aNodes on linkfile.A == aNodes.n ;
	left join (lcNodefile) bNodes on linkfile.B == bNodes.n ;
	where st_name <> ' ' ;
	order by st_name ;
	into cursor crsOriginalLinks readwrite
but when I change the 5th line to
select linkfile.*, aNodes.x as x1, aNodes.y as y1,;
	bNodes.x as x2, bNodes.y as y2,;
	abs(aNodes.x-bNodes.x) as dx, abs(aNodes.y-bNodes.y) as dy,;
	'  ' as stddir, ;
	min(linkfile.A,linkfile.B) as lh_node,;
	.f. as _used ;
	from linkfile ;
	left join (lcNodefile) aNodes on linkfile.A == aNodes.n ;
	left join (lcNodefile) bNodes on linkfile.B == bNodes.n ;
	where st_name <> ' ' ;
	order by st_name ;
	into cursor crsOriginalLinks readwrite
I get an error on the changed line that says "Function name is missing ')'." Any suggestions as to what is happening and how to fix it?

Thanks
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform