on 05-28-2015 4:41 AM
Declare @a as NVARCHAR(50)
Declare @b as FLOAT
Declare @c as FLOAT
Declare @d as FLOAT
SET @a=(SELECT U_WOType FROM WTR1 WHERE ITEMCODE=$[$23.1.0])
SET @b=(SELECT $[$23.10.0])
IF @a='Zinc Yellow Plating'
BEGIN
SELECT(16)
END
ELSE IF @a ='Powder Coating'
BEGIN
SELECT(14)
END
ELSE IF @a='Sand Blasting'
BEGIN
SELECT(((($[$23.U_OD.number] * $[$23.U_OD.number]) - ($[$23.U_ID.number] * $[$23.U_ID.number])) * $[$23.10.0] * 3.142 * 3 * 2 * 0.000007))
END
Hi Eric,
ok Sir,
Any Solution to correct this problem
Regards
Karthick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Karthick,
AT least convert this value to a number. Different options, depending on the kind of the field (you even didn't say on which form this query is used...):
Regards,
Eric
HI ALL,
now I have changed some modification in query, now it showing "INCORRECT SYNTAX NEAR KEYWORD END". What problem???
Declare @a as NVARCHAR(50)
SET @a=(SELECT U_WOType FROM WTR1 WHERE ITEMCODE=$[$23.1.0])
IF @a='Sand Blasting'
BEGIN
SELECT (((ABS((CAST($[$23.U_OD.number] as FLOAT) * CAST($[$23.U_OD.number] as FLOAT)) - (CAST($[$23.U_ID.number] as FLOAT) * CAST($[$23.U_ID.number] as FLOAT)))) * (CAST($[$23.10.number] as FLOAT) * 3.142 * 2 * 0.000007))
END
Hi Karthick,
$[$23.10.0] at before than last line is a text: your doing math between text and numbers.
Regards,
Eric
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.