Post reply

User-defined type

  • November 7, 2001 at 2:49 am

    #157588

    i create a user-defined type (UDT) using Enterprise Manager (EM)

    udt_Money - decimal 18,4

    then i create a table with a column using this udt

    EM shows me Length is 2

    but if i use "decimal 18,4" for that column

    EM shows me Length is 9

    Anyone know why?

  • November 7, 2001 at 3:44 am

    #419763

    I have seen this before when creating a table with a user defined datatype. The EM showed incorrect lengths at this stage, but on closing the design window of the table and reopening it, the lengths were correct. Is this the same in your case?

    Paul Ibison

    email: Paul.Ibison@btinternet.com


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • January 11, 2002 at 1:37 am

    #422082

    Yes, exactly. Sorry for late reply.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply