exception on TDateField in TMSTable

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
spzsoft
Posts: 4
Joined: Tue 30 Oct 2007 17:51

exception on TDateField in TMSTable

Post by spzsoft » Mon 06 Sep 2010 17:12

I have a TMSTable with TDateField component associad. The tipe in DB is DateTime.
When retrive data SDAC make the follow error
"EconvertError with message -1358299136.0 is not a valid timestamp".
I think the problen is due to the size of TDateField.
Exist a workarround for solve the conversion problem ?

AndreyZ

Post by AndreyZ » Tue 07 Sep 2010 08:23

Hello,

I could not reproduce the problem.
Please send me a complete small sample to andreyz*devart*com to demonstrate it, including a script to create and fill table.

Also supply me the following information:
- the exact version of SDAC. You can see it in the About sheet of TMSConnection Editor;
- the exact version of your IDE;
- the exact version of SQL server and client. You can see it in the Info sheet of TMSConnection Editor.

Post Reply