Results 1 to 8 of 8

Thread: DF_FIELD_NATIVE_TYPE shows SQL_TYPE_TIMESTAMP not SQL_TYPE_DATETIME

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Mar 2009
    Posts
    16

    Default DF_FIELD_NATIVE_TYPE shows SQL_TYPE_TIMESTAMP not SQL_TYPE_DATETIME

    I have been wrestling with the MSSQL datetime fields and I still cannot get good results.

    Upon reconnecting to the MSSQL database tables to refresh the *.INT files I experience this behavior in the runtime:

    Moving a VDF datetime variable value into the MSSQL datetime fields truncates the value to the date portion only.

    If I use the DBBuilder to "reset" the data type of the field, I start having "Invalid Cast" errors on saves.

    The Studio shows the DF_FIELD_NATIVE_TYPE as SQL_TYPE_TIMESTAMP not SQL_DATETIME!

    Is this a bug in the CLI? I will try creating a restucture program to force this attribute to "SQL_DATETIME" to see if the time issue resolves.

    Any help appreciated!
    Last edited by rongen; 5-Dec-2010 at 04:09 PM. Reason: Misspelled variable name

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •