on 11-01-2014 8:01 AM
hi every one,
i accidentally update a udf in purchase request wrongly. and it affect same value in all purchase request document. now i want to update purchase request udf with purchase order. i write the query but have some problem.plz help me
update prq1
set prq1.U_U_S=(select por1.U_U_S
from
por1 inner join
PRQ1 on POR1.BaseLine = prq1.LineNum AND por1.BaseEntry = prq1.DocEntry and por1.Basetype = prq1 .ObjType
and por1.ItemCode=PRQ1.ItemCode
)
from PRQ1
Hi,
Update is not allowed even for your UDF. Because this is a B1 system table not UDT. Stop this from now on. However, for correcting the mistake, you may revise the select to remove the last condition for itemcode matching. The last line is also wrong. No from for update script.
Always run the select query first to make sure it only return one value which is what you need.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please refer SAP note:
896891
- Support Scope for SAP Business One - DB Integrity
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
106 | |
12 | |
10 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.