Incompatible fields type between Oracle 9i and Oracle 10G
Posted: Wed 09 Feb 2005 11:05
Till now for my applications I Worked with a Oracle DB - Version 9i and earlier -
Now I'm trying to improve my application with Oracle 10g, but I found this error on my queries with preloaded fields :
Project "Myproject" raised exception class EDatabaseError with message 'MyTable": Type mismatch for field 'Field1', expecting: Float actual: Integer'
To solve the problem I tried to reload fields on a session with Oracle 10g (designtime); so the original type of my field, TFloatField, changed in TIntegerField, even if types on the db 9i and 10g are the same.
After this, my application works on the Oracle 10g Db, but not with 9i (I have now the opposite problem!)
I need my application works with both Oracle versions, without reloading fields every time at runtime ( I need preloaded field for my application original structure ).
So Why Odac TOraQuery ot TOraTable object change the field type when reload the field in fields editor??
Is There any solution for my problem that doesn't need to change the application structure ??
I need HELP !! This is Very important !!
Thanks !
Thanks
Now I'm trying to improve my application with Oracle 10g, but I found this error on my queries with preloaded fields :
Project "Myproject" raised exception class EDatabaseError with message 'MyTable": Type mismatch for field 'Field1', expecting: Float actual: Integer'
To solve the problem I tried to reload fields on a session with Oracle 10g (designtime); so the original type of my field, TFloatField, changed in TIntegerField, even if types on the db 9i and 10g are the same.
After this, my application works on the Oracle 10g Db, but not with 9i (I have now the opposite problem!)
I need my application works with both Oracle versions, without reloading fields every time at runtime ( I need preloaded field for my application original structure ).
So Why Odac TOraQuery ot TOraTable object change the field type when reload the field in fields editor??
Is There any solution for my problem that doesn't need to change the application structure ??
I need HELP !! This is Very important !!
Thanks !
Thanks