Message
From
14/11/2016 04:55:20
Tariq Mehmood
Bahawalpur
,
Pakistan
To
14/11/2016 03:54:51
Naomi Nosonovsky
Wisconsin
,
United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re:
Per kg rate
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 7
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01643341
Message ID:
01643347
Views:
41
Thanks Naomi,
At this line
round
(
sum
(amount)/
iif
(
sum
(weight)=
0
,
null
,
sum
(weight)),
2
)
as
kgrt
it says:
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '='.
Msg 156, Level 15, State 1, Line 9
Incorrect syntax near the keyword 'as'.
Previous
Next
Reply
Map
View the map of this thread
View the map of this thread starting from this message only
View
View all messages of this thread
View all messages of this thread starting from this message only