Hi Paul, This solution is great, thanks for your help.
Ben --- In [email protected], Paul Picard <[EMAIL PROTECTED]> wrote: > > > Ben, > There is a 2000 character limit built into AX. If you need to go over that, change the StringSize to "[Memo]" and you should be good to go. > > Paul > > > To: [email protected] > > From: [EMAIL PROTECTED] > > Date: Mon, 18 Aug 2008 02:12:57 +0000 > > Subject: [development-axapta] Modifying ItemFreeTxt EDT in AX 4.0 SP1 > > > > Hi, > > > > I tried to modify the length of ItemFreeTxt from 1000 to 3000, I go > > to its EDT which is ItemFreeTxtBase and change the SringSize > > property. Afterwards, AX synchronize the tables. But when I try to > > edit the Text field on InventTable, it gives me error like this: > > > > Cannot create a record in Inventory texts (InventTxt). Item number: > > ITEM001, EN-US. > > The SQL database has issued an error. > > > > When I go to event viewer, it show something like this: > > > > Object Server 14: The database reported (session 6 (bvt3)): > > [Microsoft][ODBC SQL Server Driver]Invalid precision value. The SQL > > statement was: "INSERT INTO INVENTTXT > > (ITEMID,TXT,LANGUAGEID,INVENTDIMID,DATAAREAID,RECVERSION,RECID) > > VALUES (?,?,?,?,?,?,?)" > > > > Am I missing something here when I did the ammendment? I will really > > appreciate you help. Thanks in advance. > > > > Best regards, > > > > Ben > > > > > > ------------------------------------ > > > > Yahoo! Groups Links > > > > > > > > > [Non-text portions of this message have been removed] >
