mORMot Open Source

Bascy

Member

From: The Netherlands

Registered: 2012-06-22

Posts: 108

MSSQL via ODBC: Datetime field overflow (0)

When i'm trying to add a record to my table in MS SQL (2008) server via ODBC i get the following message

[22008] [Micrsoft][ODBC SQL Server Driver]Datetime field overflow (0)

The field involved is a Tdatetime field, created as a datetime field in the external SQL-table, and the value assigned to it is now()

callstack:

SynDBODBC.TODBCLib.HandleError(-1,3,$D1D4D0,False,sllNone)
SynDBODBC.TODBCLib.Check(-1,3,$D1D4D0,False,sllNone)
SynDBODBC.TODBCStatement.ExecutePrepared
SQLite3DB.TSQLRestServerStaticExternal.ExecuteFromJSON('{"ModTime":135058350095,"Name":"Hans Hasenack 0","Question":"{7DFAE7C2-C6F0-40D9-8D05-AA2A835A359C}","Address_":"Dit is het adres laan, 23","PostalCode":"1234AA","City":"Nijmegen","Datum":"2012-09-14T14:00:15","FloatNumber":0,"IntNumber":0,"CurrencyNumber":0}',0)
SQLite3DB.TSQLRestServerStaticExternal.EngineAdd(TSQLUnitTestSampleRecord,'{"ModTime":135058350095,"Name":"Hans Hasenack 0","Question":"{7DFAE7C2-C6F0-40D9-8D05-AA2A835A359C}","Address_":"Dit is het adres laan, 23","PostalCode":"1234AA","City":"Nijmegen","Datum":"2012-09-14T14:00:15","FloatNumber":0,"IntNumber":0,"CurrencyNumber":0}')
SQLite3Commons.TSQLRestServer.URI('root/UnitTestSampleRecord','POST','{"ModTime":135058350095,"Name":"Hans Hasenack 0","Question":"{7DFAE7C2-C6F0-40D9-8D05-AA2A835A359C}","Address_":"Dit is het adres laan, 23","PostalCode":"1234AA","City":"Nijmegen","Datum":"2012-09-14T14:00:15","FloatNumber":0,"IntNumber":0,"CurrencyNumber":0}','','',$9A164D)
SQLite3.TSQLRestClientDB.InternalURI('root/UnitTestSampleRecord','POST',$18F4BC {''},$18F568 {''},$18F574 {'{"ModTime":135058350095,"Name":"Hans Hasenack 0","Question":"{7DFAE7C2-C6F0-40D9-8D05-AA2A835A359C}","Address_":"Dit is het adres laan, 23","PostalCode":"1234AA","City":"Nijmegen","Datum":"2012-09-14T14:00:15","FloatNumber":0,"IntNumber":0,"CurrencyNumber":0}'})
SQLite3Commons.TSQLRestClientURI.URI('root/UnitTestSampleRecord','POST',nil {''},$18F568 {''},$18F574 {'{"ModTime":135058350095,"Name":"Hans Hasenack 0","Question":"{7DFAE7C2-C6F0-40D9-8D05-AA2A835A359C}","Address_":"Dit is het adres laan, 23","PostalCode":"1234AA","City":"Nijmegen","Datum":"2012-09-14T14:00:15","FloatNumber":0,"IntNumber":0,"CurrencyNumber":0}'})
SQLite3Commons.TSQLRestClientURI.EngineAdd(TSQLUnitTestSampleRecord,'{"ModTime":135058350095,"Name":"Hans Hasenack 0","Question":"{7DFAE7C2-C6F0-40D9-8D05-AA2A835A359C}","Address_":"Dit is het adres laan, 23","PostalCode":"1234AA","City":"Nijmegen","Datum":"2012-09-14T14:00:15","FloatNumber":0,"IntNumber":0,"CurrencyNumber":0}')
SQLite3Commons.TSQLRestClient.Add($104E830,True,False)

Last edited by Bascy (2012-09-14 12:04:10)