jallende
Member
[frown]
Hi list, we have a problem with a JDB_FetchMatchingKey into B4900140 line 2710. We generates a Purchase Order in P4310 with DCTO="6A" and the BSFN generates the next select:
SELECT * FROM CRPDTA.F43008 WHERE ( APDCTO >= '6A' AND APARTG >= 'CAD0201 ' ) ORDER BY APDCTO ASC,APARTG ASC,APALIM ASC,APRPER ASC,APATY ASC
APDCTO APARTG
----------- -----------
XM CAD0201
6A CAD0201
6B CAD04AR
6Z CAD0801
Result is first DCTO="XM" and next DCTO="6A". This is wrong.
I entered the same SQL into "Oracle SQL Plus" and doesn't work correctly. But I tried with the same table exported in Access and it works OK , first "6A" and then "XM".
Is there a problem with my Oracle data base setup, or my Unix? Anyone knows similar problems? Any more information will be highly appreciated.
javier
Hi list, we have a problem with a JDB_FetchMatchingKey into B4900140 line 2710. We generates a Purchase Order in P4310 with DCTO="6A" and the BSFN generates the next select:
SELECT * FROM CRPDTA.F43008 WHERE ( APDCTO >= '6A' AND APARTG >= 'CAD0201 ' ) ORDER BY APDCTO ASC,APARTG ASC,APALIM ASC,APRPER ASC,APATY ASC
APDCTO APARTG
----------- -----------
XM CAD0201
6A CAD0201
6B CAD04AR
6Z CAD0801
Result is first DCTO="XM" and next DCTO="6A". This is wrong.
I entered the same SQL into "Oracle SQL Plus" and doesn't work correctly. But I tried with the same table exported in Access and it works OK , first "6A" and then "XM".
Is there a problem with my Oracle data base setup, or my Unix? Anyone knows similar problems? Any more information will be highly appreciated.
javier
