cancel
Showing results for 
Search instead for 
Did you mean: 

Query Error from MyMenu

ivan_leonardo
Participant
0 Kudos

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,

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

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

ivan_leonardo
Participant
0 Kudos

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

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Sorry. It will not work from my menu.

No need to enter number. just leave it as number.

Thanks & Regards,

Nagarajan

Answers (2)

Answers (2)

Former Member
0 Kudos

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

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Did you check above reply? If you got answer, please close this thread by marking correct answer.

Thanks & Regards,

Nagarajan