I'm new to Informix and a 3rd party system we're recently installed @ work is pushing my google-powers to their limit.
I have a table into which a row is inserted everytime an a/c limit is changed. Unfortunately this a/c limit is contained within a a/c details management page, on the 3rd party system, and everytime the user saves their a/c details a new row is inserted (into the a/c limit table) regardless of whether that information has changed . This being a 3rd party system I have no control how it behaves.
The table contains the following -
Current limit (true/false)
My query needs to return all rows contain records within a specific time period where the limit has actually changed. Something like -
select * from limit table were creation date > x and creation date < y and limit <> (select last(limit) from limit table where current limit = false)
Am I attempting the impossible? Should I look @ a code solution? Or am I missing a trick?