Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Per kg rate
Message
From
14/11/2016 04:55:20
Tariq Mehmood
Bahawalpur, Pakistan
 
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:
39
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

Click here to load this message in the networking platform