table name

From: Leonardo R. Nunes (leonard..umersoft.com)
Date: Fri Nov 28 2003 - 14:24:38 EST

  • Next message: Andrus Adamchik: "Re: Not updating values of FK columns"

    This is the auto pkScript from the modeler user interface. The maximum
    length of my table name is 32 characters.
    I suggest to verify the table name in the modeler user interface. Or
    change this var length to my table name length.
     
    CREATE PROCEDURE auto_pk_for_table..name VARCHAR(32), @pkbatchsize INT
    AS BEGIN BEGIN TRANSACTION UPDATE AUTO_PK_SUPPORT set NEXT_ID = NEXT_ID
    +..kbatchsize WHERE TABLE_NAME = @tname SELECT NEXT_ID FROM
    AUTO_PK_SUPPORT WHERE TABLE_NAME =..name COMMIT END
     
    Regards,
    Leonardo.
     
     



    This archive was generated by hypermail 2.0.0 : Fri Nov 28 2003 - 13:21:41 EST