Hi, I'm using 64-bit ODBC to read/write data from/to filemaker. I have some problems with timestamp data type.

Writing is working correctly:

 

 

INSERT INTO ScriptChangelog (SaveTime, Message) VALUES(time, msg)
 

The SaveTime value (timestamp) is corretly stored in db.

 

 

Reading of SaveTime is not working:

 

 

SELECT SaveTime, Message FROM ScriptChangelog
 

The Message is OK, SaveTime is empty. Note that date or time types are not working too...

The client is a program written using Qt5 library for ODBC access. So don't know if there is a bug in FM12 or the client part...

 

Has anyone expirienced this problem?

 

Thanks for help

Automatic message

This topic has been moved from "User Group Central - Sponsored by FMPug.com" to "External Data Sources".

 

The User Group Central a sponsored topic area and is reserved for their announcements, etc. not for asking how-to questions.