[development-axapta] populating table contents from another table

[Agus Riyadi]

Hi all,

I have problem with populating table contents from another table.
I want to add rows in TableA which values are derived from EmplTable. TableA has 
emplId field.
I have a form with datasource named TableA.
Here is my code :

EmplTable eTable;
;
while select eTable {
           ttsbegin;
           TableA_ds.create();
           TableA.emplId = eTable.emplId;
           TableA.insert();
           ttscommit;
}
This code only create a new record. The remaining caused this errror message :
“Cannot Create a record in TableA (TableA).  The record already exists”
I’m sure that there is no duplicate in the emplId field.
Any help would be appreciated!

regards,

agus



Yahoo! Groups Sponsor	 
ADVERTISEMENT
Click to learn more... 	
	

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.