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]
