ink2005 Posted October 5, 2016 Share Posted October 5, 2016 I'm trying to run a query in TJDBCInput component (v.5.2.) connected to the DBF by driver http://www.hxtt.com/dbf.html (v.4.2), but i get incorrect data: 120 1900-01-01 0 The request look like: select PERSTYPE.PERS_CODE, nvl(water.DASPWATER2,'1900-01-01') as DASPWATER2, nvl(water.pers_code,0) as water_id from PERSTYPE inner join PERSONAL p on PERSTYPE.PERS_CODE=p.code left outer join (select pers_code,DSERT as DASPWATER2, ORG_CODE, o.NAME, DENDSERT from EXTLIST left outer join org o on o.code=ORG_CODE where EXT_CODE=8 and NOENDSERT=0 ) water on PERSTYPE.PERS_CODE=water.PERS_CODEwhere p.tmp_str=10015634[/code]When I'm executing the same query with the same driver and same DB in a Java, the data is correct: 120 2016-03-15 120Can you help me? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now