Skip to Content
0

Expression type not compatible with Object type- error- UDT

Feb 26 at 06:52 PM

77

avatar image

Hi guys

we recently migrated our database from oracle to SQL. So now I am trying to fix the universes . There is a datetime object in one of the tables and it needs to be converted to Date. The old oracle sql was TRUNC(table1.field1)

Now I have to convert it into SQL so I am trying this:

CAST(table1.field1 as DATE) but it gives me the error "

Expression type not compatible with Object type"

It works fine when I run it in sql server...

Any idea?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sonet Kebede
Feb 26 at 07:30 PM
0

Hello,

You need to change the Data Type from DateTime to Date.

Thanks,

Sonet

Show 6 Share
10 |10000 characters needed characters left characters exceeded

Change data type where?

0

Definition Tab of the Edit properties of "your object" window.

or Double click the object and you will see the Name of the object and Type

0

It is already in Date format...

0

Normally, Expression type not compatible with Object type mean that object definition data type is not set as same way as your database or if there is a conversion than you have to set it based on that conversation. What's the version of BO are you using? if you did not convert his object, would the object parse? if yes, what is the data type?

0
Its BO 4.2

If I convert this object to 'Char', it parses fine.

0

If you did not convert his object, would the object parse? if yes, what is the data type you select?

Normally, DATETETIME and SMALLDATETIME in SQL Server should convert to DATE in UDT.

And CHAR, VARCHAR and TEXT should convert to Char in UDT.

0