+6Hi there,
I want to create a Read Only Custom Field which refers to another Custom Field.
Only problem is that I keep getting Errors.
Does anyone have a clue on how to resolve this?
This is tee Select Statement I used:
This is the Error that appears:
I've already looked at another topic on the community where a similar issue was presented. This however was an issue unresolved for APS9. (see link below)
Best answer by bnzKarin
Found the solution myself.
I came to the conclusion that the query was not right and I had another trial custom field in the same list. I believe that other one was generating the errors…
+24hi,
try “from customer_order_cfv”
+8hi
try from customer_order_cfv and Arguments v.Identity
+14Are you sure you typed everything correctly?
This should work fine:
However when I define the Select Statement like this:
SELECT OBJECT FROM CUSTOMER_ORDER_CFV WHERE CUSTOMER_NO = :IDENTITY
(omitting the CF$_ prefix) then it will yield the exact same error as you reported.
By the way, I personally think it's nicer to create a public method for the original custom field on CustomerOrder
and then use that method as an Expression on the CustomerOrderInvHead
+6Thank you for the clear explanation ToBeNL, but I tried both suggestions and still get the same Error.
Could it be something else in the application?
+6Found the solution myself.
I came to the conclusion that the query was not right and I had another trial custom field in the same list. I believe that other one was generating the errors…
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
