devnull

How does the client interface with the PROIV installation?

Just interested.

@MOD rocks your socks

Seriously, whats so wrong with @MOD? Its quick and direct and stays out of the way.

Bob

And Windows isnt proprietary?

Seems a bit odd that this is your driving force, and yet you are recommending the leap to windows. What did someone once say about the frying pan and the fire?

If you really want to avoid being tied to a single vendor, have a look at linux. Linux is linux, so if one vendor doesnt perform you are always open to migrate (painlessly) to another vendor.

Is the variable NULLable?  If not, that's probably your problem.  For 0 date, PRO-IV should be saving a NULL to the database.  31/12/1799 probably causes the PRO-IV kernel all kinds of problems when it reads it out of the DB (it's not allowed...)

For those that are interested, this is exactly what it was - we had a new PL/SQL package decide that since 31/12/1799 was PROIV's base date, its what it would insert instead of null. Just a simple bug really.

Funny how it only caused it to fail sometimes tho - only in particular circumstances for particular clients. It must cause some sort of overflow or something which only goes wrong on occasion

God I love PRO/IV

yup, Im kind of a piece of furniture down here. They prod me with sticks and every now and then I put on a gorilla suit and do a little dance.