select * from luxproject.v1_read_acct_positions
where trunc(calen_dt) = '08 feb 2005'
and trim(ssb_fund_num) = 'SDEC'
When I run it on my PC - either using DB Artisan or through an application which uses BDE to connect to the database I get 18, but when I run the SQL on the application server I only get 1 record.
This was happening on my PC and I amended my BDE settings and the problem was resolved. However the server BDE settings match mine now and still the SQL does not work. In addition even when the SQL is run through SQL PLUS (which does not use BDE) only 1 record is returned.
Has anyone seen this behaviour before... is there anything that causes an incomplete record set to be returned without any error message. The recordset is consistently wrong when the SQL is run on the server where as it is always right on my PC
Thanks - I checked this but the problem is that some but not all of the data is being returned for the date I specify so I don't think that it is a problem with the formatting. Some of the data that meets the where conditions are returned but not all.