details: https://code.openbravo.com/erp/devel/pi/rev/90fbe84a3f82
changeset: 15060:90fbe84a3f82
user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date: Tue Jan 03 15:53:10 2012 +0100
summary: Fixed potential SQLException issue.
diffstat:
src-db/database/model/functions/MA_COPY_VERSION.xml | 71 ++++++++++----------
1 files changed, 37 insertions(+), 34 deletions(-)
diffs (83 lines):
diff -r 034b948649c9 -r 90fbe84a3f82
src-db/database/model/functions/MA_COPY_VERSION.xml
--- a/src-db/database/model/functions/MA_COPY_VERSION.xml Fri Dec 16
09:15:09 2011 +0100
+++ b/src-db/database/model/functions/MA_COPY_VERSION.xml Tue Jan 03
15:53:10 2012 +0100
@@ -173,42 +173,45 @@
Cur_Product.Divisiongroupqty, Cur_Product.Line
)
;
- FOR Cur_ProductAtt IN
- (SELECT *
- FROM MA_SequenceProductAtt
- WHERE MA_SequenceProduct_ID=Cur_Product.MA_SequenceProduct_ID
- )
- LOOP
- v_ResultStr:='InsertProductsCopyFromAttribute';
- v_ProductAtt_ID := get_uuid();
+ FOR Cur_ProductAtt IN
+ (SELECT *
+ FROM MA_SequenceProductAtt
+ WHERE MA_SequenceProduct_ID=Cur_Product.MA_SequenceProduct_ID
+ )
+ LOOP
+ v_ResultStr:='InsertProductsCopyFromAttribute';
+ v_ProductAtt_ID := get_uuid();
- SELECT MA_SequenceProduct_ID
- INTO v_MASequenceProductFrom_ID
- FROM MA_SequenceProduct
- WHERE MA_Sequence_ID = v_Sequence_ID
- AND LINE = (SELECT LINE
- FROM MA_SequenceProduct
- WHERE MA_SequenceProduct_ID =
Cur_ProductAtt.MA_Sequenceproductfrom_id);
+ SELECT MAX(MA_SequenceProduct_ID)
+ INTO v_MASequenceProductFrom_ID
+ FROM MA_SequenceProduct
+ WHERE MA_Sequence_ID = v_Sequence_ID
+ AND isactive = 'Y'
+ AND LINE = (SELECT LINE
+ FROM MA_SequenceProduct
+ WHERE MA_SequenceProduct_ID =
Cur_ProductAtt.MA_Sequenceproductfrom_id
+ AND isactive = 'Y')
+ AND m_product_id = (SELECT m_product_id
+ FROM MA_SequenceProduct
+ WHERE MA_SequenceProduct_ID =
Cur_ProductAtt.MA_Sequenceproductfrom_id
+ AND isactive = 'Y');
- IF (v_MASequenceProductFrom_ID IS NOT NULL) THEN
- INSERT
- INTO MA_SequenceProductatt
- (
- MA_SequenceProductatt_ID, AD_Client_ID, AD_Org_ID,
Isactive,
- Created, Createdby, Updated, Updatedby,
- MA_Sequenceproduct_id, MA_Sequenceproductfrom_id,
M_Attributeuseto_id, M_Attributeuse_id,
- Isspecialatt, Specialatt
- )
- VALUES
- (
- v_ProductAtt_ID, v_Client_ID, v_Org_ID, 'Y',
- now(), COALESCE(v_User_ID, '0'), now(),
COALESCE(v_User_ID, '0'),
- v_Product_ID, v_MASequenceProductFrom_ID,
Cur_ProductAtt.M_Attributeuseto_id, Cur_ProductAtt.M_Attributeuse_id,
- Cur_ProductAtt.Isspecialatt,
Cur_ProductAtt.Specialatt
- )
- ;
- END IF;
- END LOOP;
+ IF (v_MASequenceProductFrom_ID IS NOT NULL) THEN
+ INSERT
+ INTO MA_SequenceProductatt (
+ MA_SequenceProductatt_ID, AD_Client_ID, AD_Org_ID, Isactive,
+ Created, Createdby, Updated, Updatedby,
+ MA_Sequenceproduct_id, MA_Sequenceproductfrom_id,
M_Attributeuseto_id, M_Attributeuse_id,
+ Isspecialatt, Specialatt
+ ) VALUES (
+ v_ProductAtt_ID, v_Client_ID, v_Org_ID, 'Y',
+ now(), COALESCE(v_User_ID, '0'), now(), COALESCE(v_User_ID, '0'),
+ v_Product_ID, v_MASequenceProductFrom_ID,
Cur_ProductAtt.M_Attributeuseto_id, Cur_ProductAtt.M_Attributeuse_id,
+ Cur_ProductAtt.Isspecialatt, Cur_ProductAtt.Specialatt
+ )
+ ;
+ END IF;
+ END LOOP;
END LOOP;
END LOOP;
--MA_Copy_Version - Finish Process
------------------------------------------------------------------------------
Write once. Port to many.
Get the SDK and tools to simplify cross-platform app development. Create
new or port existing apps to sell to consumers worldwide. Explore the
Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
http://p.sf.net/sfu/intel-appdev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
