Retrieving Date Column from SQL and Displaying

[tom.smith]

OK, so this should be easy.

I have a date field within a MS SQL database.
I have a DB resource in ebase which selects all columns from the table.
The type for the date column is set to "Date".
I have a table on my ebase form, which is mapped to the DB resource.
I have a column within my ebase table which is mapped to the date field from the DB resource, and that is set to type "Date".

When I issue a fetchtable command, I get the following error:

Code: Select all

com.ebasetech.xi.exceptions.FormRuntimeException: Unable to set value for field ALERTS_TBL-REGISTRATIONDATE, value 2014-05-23 not compatible with type DATE

I can issue an updatetable command without any issues at all. Date gets entered into the MS SQL DB without any issues.

Any ideas?

Thanks

Tom

[Steve James]

Hi Tom

Looks like MSS is returning a date in a format not acceptable for Ebase see acceptable formats http://portal.ebasetech.com/cp/doc/UFS_ ... c369594441

Thanks

[Jon]

Could be that you're using the DATE type introduced with SQL Server 2008, which is not supported by the jtds JDBC driver supplied with Ebase. The simplest solution is to change the type to one supported by the driver i.e. datetime. For info, here's a link to the supported jtds column types: http://jtds.sourceforge.net/typemap.html

[tom.smith]

Thanks for the info guys