on 04-24-2014 9:09 AM
Hi,
I have a query that related to a Form,
SELECT T0."DocRate" FROM "OPDN" T0
WHERE "DocNum" = $[$51.28.0]
If I run the query through FMS or Tools-Query-UserQuery it is success return Docrate. BUT when I put the Query on MyMenu at the MainMenu on the left. The query having error message.
Is it normal that query have a different behavior if running from MyMenu?
I am using B1 9.0 PL4
Rgds,
Hi,
1. There is small change in above query to get correct result:
SELECT T0."DocRate" FROM "OPDN" T0
WHERE "DocNum" = $[$51.28.number]
2. The above query is FMS, you have open GRPO form to run and get query result whether from Tools---query or from my menu.
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes I have open the GRPO Form and run the query, it still error if I run it from MyMenu, but Success if I run as FMS or Tools-Query
SELECT T0."DocRate" FROM "OPDN" T0
WHERE "DocNum" = $[$51.28.number]
Is it just type a word number or insert a number 0,1,.....
I have Try using "number" no success
Hi,
This query cant run from MyMenu or from query manager. You must open GRPO window first to run it in order to return the correct value.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Did you check above reply? If you got answer, please close this thread by marking correct answer.
Thanks & Regards,
Nagarajan
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.