Post reply

ERROR :(

  • July 13, 2005 at 6:43 am

    #88924

    INSERT INTO ClnPdoScl ( Codigo, CodigoPrd, Prd_Qnt, Prd_Prc_Unit, Vl_Frete, Vl_Total ) VALUES ( '000001', '10299457-BR', 002, '51,00', '0', '102,00' )

    error

    -->

    Disallowed implicit conversion from data type varchar to data type money, table 'compexnet2_1.dbo.ClnPdoScl', column 'Prd_Prc_Unit'. Use the CONVERT function to run this query. Disallowed implicit conversion from data type varchar to data type money, table 'compexnet2_1.dbo.ClnPdoScl', column 'Vl_Frete'. Use the CONVERT function to run this query. Disallowed implicit conversion from data type varchar to data type money, table 'compexnet2_1.dbo.ClnPdoScl', column 'Vl_Total'. Use the CONVERT function to run this query.

  • July 13, 2005 at 6:55 am

    #573849

    HELP ME PLEASE.. XD

    I'm noob...

  • July 13, 2005 at 6:56 am

    #573850

    The columns that you are trying to write '51,00', '0', '102,00' are set-up as MONEY.  They will not auto-change '51,00' from a CHARACTER into MONEY.

    You can either do 51, 0, 102 OR

    CONVERT(MONEY, '51'), CONVERT(MONEY, '0'), CONVERT(MONEY, '102')

    See example:

    DECLARE @VAR CHAR(10)

    SET @VAR = '51'

    SELECT @VAR, CONVERT(MONEY, @VAR)



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • July 13, 2005 at 7:03 am

    #573853

    very obliged Ten Centuries

    I go to test this now

  • July 13, 2005 at 7:07 am

    #573856

    a new error happened

    sql --> INSERT INTO ClnPdoScl ( Codigo, CodigoPrd, Prd_Qnt, Prd_Prc_Unit, Vl_Frete, Vl_Total ) VALUES ( '000001', '10299457-BR', 002, CONVERT(MONEY, '51'), CONVERT(MONEY, '0'), CONVERT(MONEY, '102') )

    error printed --> String or binary data would be truncated. The statement has been terminated.

  • July 13, 2005 at 7:27 am

    #573865

    Check the string fields. Some data you are trying to insert is too large for the column.

  • July 13, 2005 at 7:36 am

    #573873

    ours as I am lay. very obliged.

    it forgives for my English.

    I am Brazilian XD

  • July 13, 2005 at 7:45 am

    #573881

    Alright. Sorry to ask but do you still need help (not too sure from your last post)?

  • July 13, 2005 at 7:54 am

    #573889

    Congrats on the big K AJ ... and I see this one is not about loops so that's cool .

  • July 13, 2005 at 8:13 am

    #573910

    vlw galera... IUpiiiiiiiii

    gostei desse forum.. XD

  • July 13, 2005 at 8:15 am

    #573912

    I'll take that as a no .

Viewing 11 posts - 1 through 11 (of 11 total)

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