[fdo-users] Conversion of SQLServer Date type to FDO type Double ?

[Bo Victor Thomsen]

To the list -

I've just realized that I've been looking at the wrong table :-/

"Date" columns in SQLServer 2008 is not being converted to FDO type 
"Double". "Date" columns simply disappear from the MapGuide Studio preview.

So my question is:

Is it possible to make a column from Sql Server 2008, Type "Date",  
visible (and usable) in MapGuide ?

Versions: MapGuide Open Source ver. 2.1, FDO ver 3.4.1, SqlServer 2008 R2


Den 30-05-2011 13:37, Bo Victor Thomsen skrev:
> Hello list-members -
>
> I have a SQLServer 2008 R2 based table which contains a "Date" field. 
> I've connected this table to MapGuide 2.1 using FDO ver. 3.4.1. When I 
> preview the the table in Maestro, the "Date" based field is identified 
> as type "Double" in the preview window.
>
> A similar SQLServer 2008 R2 based table, which contains a "DateTime" 
> field instead of the "Date" field is treated correctly and the field 
> is is shown as a "DateTime" field in MapGuide.
>
> Is this behaviour by design or is it an error ?
> Is it possible for MapGuide to identify the Date field correctly 
> (short of converting the field from "Date" to "DateTime") ?
> Regards
> Bo Victor Thomsen
>


-- 
Med venlig hilsen

Civ.Ing.
Bo Victor Thomsen
Geograf A/S