Logical datatype

erikfandersen · Post by **erikfandersen** » 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

Challenger · Post by **Challenger** » Wed 27 Sep 2006 11:55

No, ODAC has no functionality to solve such problems. We suggest you to change SQL statements and use parameters.