Error Inserting Data to MAS

[armanps]

I'm trying to insert data from MSSQL to MAS using VB as interface. My code is:

dbMAS.Execute "INSERT INTO IM1_InventoryMasterfile ( ItemNumber, ItemDescription, ProductLine, ProductType, Valuation, ProcureTypeBuyMakeSub) values ('" & Trim(mRS!cActualItem) & "','" & Trim(Replace(mRS!cItemDetName, "'", "`&quot) & "','" & Trim(mRS!cProdCode) & "','F','1','B')"

The insertion of data is OK but instead of inserting the value 'B' on ProcureTypeBuyMakeSub field, it was inserted on RoutingNo field.

I tried to rearrange the sequence of the fields and values but to no avail. I hope someone can help me with this.

Thanks in advance,

Arman

 

[armanps]

I tried to use brute force here. I run a scipt that will update the ProcureTypeBuyMakeSub field to 'B' but it seems my problem became worst. Instead of the field updated to 'B', some characters on my item description were inserted to that field. Are there restrictions/constraints on ProcureTypeBuyMakeSub?

Hope anyone can help me on my follow-up.