PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
Dim dvView as dataview Dim m_dstBaseSettings as Dataset Dim m_ProjCode as String Dim dtTempTable as DataTable Dim drRow as Datarow dvDataview = m_dstBaseSettings.Tables("BASE_SETTINGS").DefaultView dvDataview.RowFilter = "SETTING_DESCRIPTION = 'REQUIRED' OR SETTING_DESCRIPTION = 'REQUIRED_W_DEFAULT'" dvDataview.Sort = "SETTING_DESCRIPTION, SETTING_NAME" 'Create a temporary table so Station_Code can be added dtTempTable = dvDataview.ToTable.Copy 'Loop through temp table For Each drRow In dtTempTable.Rows 'Assign the stationcode to the new project station code drRow.Item("STATION_CODE") = m_ProjCode drRow.EndEdit() m_dstBaseSettings.Tables("BASE_SETTINGS").Rows.Add(drRow) ****ERROR HERE "Row already belongs to another table" Next
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.