Per kg rate - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Per kg rate

Message

14/11/2016 04:55:20

14/11/2016 03:54:51

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Versions des environnements

Visual FoxPro:

VFP 9

OS:

Windows 7

Network:

Windows XP

Database:

MS SQL Server

Application:

Desktop

Divers

Thread ID:

01643341

Message ID:

01643347

Vues:

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'.