creating a new universe

[achowe]

Im in the process of creating a new universe. Ive connected to a SQL Server database no problem, but when I come to select the tables/fields which I require it seems to only make available fields with a number value. Any ideas why?

Cheers

 

[skrandel]

Depends on the datatypes. BO supports varchar, but not nvarchar.

Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group

http://www.knightsbridge.com

 

[Sridharan]

Yeah the datatype must be nchar, nvarchar or ntext. Jus try to create them manually in the classes. It will work.

Sri

 

[achowe]

OK...it seems to only like char, int, float and alike..it doesnt recognise nvarchar or varchar. More importantly, it deosnt recognise datetime or smalldatetime. The data we are using is highly dependent on dates.....is there any way around this?

Cheers

 

[Sridharan]

Even with this you should be able to create the object manually for nchar or nvarchar and it should recognize datetime or smalldatetime. Did you try creating an object and setting the datatype to Date???

Sri

 

[achowe]

Yeah, tried that. The fact still remains however that fields brought from SQL Server with type datetime or small datetime are not recognised. Surely it would be defeating the object of using such a tool if I were to create the fields from scratch in BO?

Cheers

 

[skrandel]

BO fully supports datetime fields.

It may just be stopping after it finds a nchar.

Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group

http://www.knightsbridge.com

 

[skrandel]

Even though it won't create them when you drag a table over, can you drag the columns over 1 at a time?

Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group

http://www.knightsbridge.com