topic Re: Quantity fields in Application Development and Automation Discussions

Quantity fields

Former Member — Mon, 23 Jul 2007 06:12:14 GMT

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 — Mon, 23 Jul 2007 06:17:26 GMT

hi try this one,

Select * from mara......

where Qty = 0.

Reward Points If Helpful.....

Regards,

Imran

Former Member — Mon, 23 Jul 2007 06:47:23 GMT

Hi Ramesh,

Declare a variable and then check in the where condition.

Regards

Arun

Former Member — Mon, 23 Jul 2007 06:50:44 GMT

Hi Ramesh,.

Try like this:

SELECT * FROM MARA ...

where qty IS INITIAL.

Reward Points for helpful answers.

Regards,

Hari krishna.

Former Member — Mon, 23 Jul 2007 07:05:51 GMT

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