on 03-27-2009 10:11 AM
Dear all,
I wanted to write a formatted search which will change my Total Lc to as Unitprice * Factor1, where factor1 is my quantity. I have written the below formatted search but it seems not to work the way i want it to work
SELECT $[$38.14.number] *t0.Factor1 From DLN1 t0
please someone to assist me on this.
Regards,
Hi Antony,
i do not know what table DLN1 is, but re u sure that u do not need a where clause ?
You try to select every T0.Factor from DLN1. I think there are a lot values in Factor.
Also you need brackets afaik :
SELECT ($[$38.14.number]*t0.Factor1) From DLN1 t0
If you need the where your query should look like :
SELECT ($[$38.14.number]*t0.Factor1) From DLN1 t0 where t0.XXXX = $[$XXXX]
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.