Question
· Jul 22, 2017

select sql error

hi

  I execute sql  like this:  select * from DHC_PatBillDetails where PBD_PBO_ParRef>='2046121'

 

error message:

but   the sql:   select * from DHC_PatBillDetails where PBD_PBO_ParRef='2046121'   can be executed successfully

 

why?

Discussion (5)1
Log in or sign up to continue

His,

It looks like the record you are trying to access does not conform to the global mapping of the class.

Make a comparison with the global data of a record that is returned in the query and with this one that is giving problem, so maybe you can see if there is any piece of record that returns error is in disagreement with the global mapping of the class.

 

Regards.