Trouble getting a UD110A table to update a column

[Miker (Mike Ruoppoli)]

I think I know what my issue is but don’t know how to fix it.

UD110Adapter uAdpt = new UD110Adapter(UD110Form);
               uAdpt.BOConnect();
               // Load the matching record in the UD110 table...
			   bool MorePages;
               SearchOptions opts = new SearchOptions(SearchMode.AutoSearch);
               opts.NamedSearch.WhereClauses.Add("UD110A", "Key1 = '" + JobNum + "' AND " + "Key2 = '" + PartNum + "' AND " + "Key3 = '" + AsmSeq + "' AND " + "ChildKey1 = '" + Serial + "'");
               opts.PageSize = 0;
               DataSet ds = uAdpt.GetRows(opts, out MorePages);
               ds.Tables["UD110A"].Rows[0]["Date08"] = ThisDate;
               uAdpt.Update(); 

The update at the bottom refers to the UD110Adapter but I don’t know how to make the changed ds.Tables[“UD110A”].Rows[0][“Date08”] record update as well.

[Banderson (Brandon Anderson)]

Hey, check this thread out on formatting your code blocks. It will help people be able to read your code.

Code Syntax Highlighting in Posts

The test below ```cs public void test() { MessageBox.Show("testing"); } ``` will produce public void test() { MessageBox.Show("testing"); } The 3 back tics ``` signify the start and end of a code block. The first set of 3 back tics are followed by the language type you have posted for be it C#, VB, or SQL. The languages available to use are cs, xml, ini, objectivec, sql, vbscript, vbnet, sql, txt. All the languages that could be included in the above list can be found here. highlight.j…

[Miker (Mike Ruoppoli)]

Sorry I was using the single quote not the thing under the tilda ~

[Banderson (Brandon Anderson)]

I think you’ll need to set the RowMod to “U”. But I’ve never done it that way…

[Miker (Mike Ruoppoli)]

So I added the RowMod with the Begin and End edit. Still not saving the updated “Date08” value to UD110A

               UD110Adapter uAdpt = new 
               UD110Adapter(UD110Form);
               uAdpt.BOConnect();

               // Load the matching record in the UD110 table...
			   bool MorePages;
               SearchOptions opts = new 
               SearchOptions(SearchMode.AutoSearch);
               opts.NamedSearch.WhereClauses.Add("UD110A", "Key1 = '" + JobNum + "' AND " + "Key2 = '" + PartNum + "' AND " + "Key3 = '" + AsmSeq + "' AND " + "ChildKey1 = '" + Serial + "'");
               opts.PageSize = 0;
               DataSet ds = uAdpt.GetRows(opts, out MorePages);
               ds.Tables["UD110A"].Rows[0].BeginEdit();
		ds.Tables["UD110A"].Rows[0]["RowMod"] = "U";
		ds.Tables["UD110A"].Rows[0]["Date08"] = ThisDate;
		ds.Tables["UD110A"].Rows[0].EndEdit();
               uAdpt.Update();
               uAdpt.Dispose();

Not sure what else to do here, suggestions?

[Banderson (Brandon Anderson)]

So the other thing that some methods need is a before and after row. So before you make changes, copy the row, then make the the changes on one of the rows. So the row mod for one of them will be U and the other won’t have a row mod. This is the unchanged row. Use BufferCopy.Copy(rowfrom, rowtoo); to make the copy.

[Miker (Mike Ruoppoli)]

I ended up getting this to work

UD110Adapter uAdpt = new UD110Adapter(UD110Form);
				uAdpt.BOConnect();
				uAdpt.GetByID(JobNum, PartNum, AsmSeq, "", "");
				// Loop through UD110A to find the serial in ChildKey1 and update the date field in ColN
				foreach(DataRow dr in uAdpt.UD110Data.UD110A.Rows)
				{
					if(dr["ChildKey1"].ToString() == Serial)
					{
						dr.BeginEdit();
						dr[ColN] = ThisDate;
						dr.EndEdit();
					}
				}

[Banderson (Brandon Anderson)]

ah, I was in server side code world in my head. We try to do as little as possible on the client side since all that code will be basically useless once you get to kinetic web UI. I’m glad you figured it out.

[Miker (Mike Ruoppoli)]

We will be royally screwed if we ever have to switch to Kinetic. Thousands of lines of code. I dread the thought.