Hi All,
I am trying to fetch data from a table using table file method and it is giving me correct data when I am executing it in webfocus 7.7.03 but it is giving a 1/4 of data when I am running it in webfocu 8.1.05. I am running the same piece of code in both the version but getting different count of data.

Any help will be appreciated.

here is my simple code :
TABLE FILE WCCLM
PRINT DISPLAY_CLM_CD
CLM_CREATE_DT
CLM_STATUS_CD
ADDL_INFO_5
CLM_CLS_CD
CLM_SUBMIT_MODE_CD
CLM_TTLORGNLAMT AS DEALERPROCESSED
CLM_TTLREQAMT AS EXPECTED
CLM_TTLADJAMT AS NEGOTIATED
NRCVRD_TTLAMT AS SUPPLIER_PAID
CHRGBK_AMT AS CHARGE_BACK
CLM_ID
BY CLM_ID NOPRINT
WHERE CLM_SUBMIT_MODE_CD NE 'LEGACY'
AND CLM_CLS_CD EQ 'SupplierClaim'
AND CLM_STATUS_CD NE 'OBSOLETE'
AND CLM_CREATE_DT GT DT('2016-05-28 00:00:00.000')
AND CLM_CREATE_DT LT DT('2016-06-05 00:00:00.000')
ON TABLE SET ASNAMES ON
-* ON TABLE HOLD AS CLMDATA
ON TABLE PCHOLD FORMAT EXL2K
END
-RUN
-EXIT

This message has been edited. Last edited by: <Emily McAllister>,

Are you pointing to the same WCCLM table?

If this is a DBMS table, did you refresh the metadata in the new environment?

Comment ON TABLE PCHOLD, then add -SET &ECHO=ALL; at the very top. Then add SQL tracing. Then rerun and view the HTML source to see if there are any messages.

I'd bet it's a source data issue... Just saying...

quote:

metadata in the new environment

Thanks Francis.

it may be the case with the refresh of meta data. Now I am getting the correct data.

Thanks again for your help. :-)