Logical datatype
Posted: Tue 26 Sep 2006 12:25
Hello!
I'm new to Oracle but have plenty of experience with other databases. I have an application that I need to adapt to Oracle 10g and I have choosen Oracle Data Access Components for the task. I use Delphi 7.
My question is what I should / could do about all the SQL code I already have that assumes the presence of a logical datatype in the database? This datatype does not exist in Oracle. I would really hate to make too many changes to my existing code.
I can have SQL that looks like:
"select * from sometable where x"
or
"select * from sometable where x=false"
where 'x' is a logical field in the table sometable.
I thought about basing my code on TOraQuery component. Is it somehow possible to change the SQL on the fly or is there an even better approach to this problem (in ODAC)?
Regards,
Erik F. Andersen
I'm new to Oracle but have plenty of experience with other databases. I have an application that I need to adapt to Oracle 10g and I have choosen Oracle Data Access Components for the task. I use Delphi 7.
My question is what I should / could do about all the SQL code I already have that assumes the presence of a logical datatype in the database? This datatype does not exist in Oracle. I would really hate to make too many changes to my existing code.
I can have SQL that looks like:
"select * from sometable where x"
or
"select * from sometable where x=false"
where 'x' is a logical field in the table sometable.
I thought about basing my code on TOraQuery component. Is it somehow possible to change the SQL on the fly or is there an even better approach to this problem (in ODAC)?
Regards,
Erik F. Andersen