Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select error
Message
From
06/07/2006 15:46:21
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Select error
Miscellaneous
Thread ID:
01134260
Message ID:
01134260
Views:
56
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
Next
Reply
Map
View

Click here to load this message in the networking platform