Results 1 to 9 of 9

Thread: Changeing a table with a timetamp column is not working in the studio

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Default Changeing a table with a timetamp column is not working in the studio

    MSSQL con. kit.

    If I make a change in a table that has a sql timestamp Data Type i get an error if I try to change any change to the table from the studio. The error is:
    ---------------------------
    Studio Error
    ---------------------------
    Table changes for (KUNDE) were not saved.


    General error. 23000 (273)--[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column. Table = KUNDE (502), Source = MSSQLDRV.Structure_End.CopyRecords
    ---------------------------
    OK
    ---------------------------

    The studio also only lists the sql native type as "binary" and a DataFlex Type as "Binary". The native type "timestamp" seems not to be supported by the con. kit.?

    Studio version: 19.0.34.0
    Con. kit version: 6.2.0.42
    Last edited by Allan Greis Eriksen; 8-May-2018 at 10:23 AM. Reason: Added versions.

Posting Permissions

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