Solved

Object reference Error Because of Null value passing in Dataview

  • 2 March 2023
  • 3 replies
  • 156 views

Userlevel 4
Badge +1

Hi,
I am getting Object reference error While Opening a screen.
The Issue Which I found was “Inside the Data View declaration Field Value is going null”;
Ex:
        public PXSelect<Table1,
          Where<Table1.Field1,
          Equal<Current<Table2.Field1>>,
            And<Table1.Field2,
                Equal<Current<Table2.Field2>>>
            >> DataView; 

In the Above Sample Query I am getting Table1.Field2 is Null value..Because of that Object reference issue is throwing while opening screen.

How can I solve this type of issue. Can any one suggest on this??

Thanks,
Giri.

icon

Best answer by Giri K 13 March 2023, 07:18

View original

3 replies

Userlevel 7
Badge +17

Hi @girik06  I don’t see any issues with the VIEW but do you have any unbound fields in the table and not fetching the data on page loading and causing this issue?

Userlevel 4
Badge +1

Hi @Naveen Boga. We modified the Second where Condition inside View Delegate.

Thanks,
Giri.

Userlevel 7
Badge +17

Yes, most of the cases we can see this issue when Table1 and Table2 is not tied properly. However, I'm glad that issue is cleared now.

 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved