Quantity fields

[Former Member]

How can i declare quantity fields initial value (0.000) in the select query where condition.if i declare with in the quotes it shows some error.

Pl any one let me know. urgent

[Former Member]

hi try this one,

Select * from mara......

where Qty = 0.

Reward Points If Helpful.....

Regards,

Imran

[Former Member]

Hi Ramesh,

Declare a variable and then check in the where condition.

Regards

Arun

[Former Member]

Hi Ramesh,.

Try like this:

SELECT * FROM MARA ...

where qty IS INITIAL.

Reward Points for helpful answers.

Regards,

Hari krishna.

[Former Member]

Hi,

As the quantity field u are checking is Null.

u can check in select statement as INITIAL.

OR else

declare a constant variable with value as '0.00'

and compare the value with variable in select statement.

but it is better if u try with INITIAL as it is right approach.

Thanks,

Srinivas