[fdo-trac] #641: SQLite Can't create a datetime column

[FDO]

#641: SQLite Can't create a datetime column
-----------------------------+----------------------------------------------
 Reporter:  bscott           |         Owner:  traianstanev
     Type:  enhancement      |        Status:  assigned    
 Priority:  blocker          |     Milestone:  3.5.0       
Component:  SQLite Provider  |       Version:  3.5.0       
 Severity:  1                |    Resolution:              
 Keywords:                   |   External_id:              
-----------------------------+----------------------------------------------
Comment (by bscott):

 I've made a try with UseFdoMetadata=TRUE
 and with fdo_columns table well populated.

 So when using FdoIFeatureReader and FdoIDataReader ( for simple query )
 everything works well,a describe on the table returns a datetime type.

 For Complex Query ( on multiple tables with joins ) using
 FdoISQLDataReader
 I still have the date as string problem


 Now just imagine an application with more than 200 tables and 50 views.
 This is a common situation for our client.
 Maintaining the fdo_columns table is lot of overhead and will make sqlite
 less attractive

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/641#comment:8>
FDO <http://fdo.osgeo.org/>
Feature Data Objects