Using SeekByPrimaryKey


Author
Message
Bill Cunnien
Bill Cunnien
StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)
Group: Forum Members
Posts: 785, Visits: 3.6K
I am attempting to edit/save (aka update) selected BO's represented on a grid. Here is the code that I am using to accomplish this seemingly easy task:





waitWindow1.Message = "Updating the following parts . . . \r";

waitWindow1.ShowWaitWindow();

int[] mRows = gridView1.GetSelectedRows();

for (int i = 0; i < gridView1.SelectedRowsCount; i++)

{

int mPartIndex = (int)gridView1.GetRowCellValue(mRows[i], "partindex");

if (partsBO1.SeekToPrimaryKey(mPartIndex))

{

waitWindow1.Message += partsBO1.partnum + "\r";

partsBO1.Edit();

if (chkProdAppend.Checked) { partsBO1.prodnotes += txtNewNote.Text; }

if (chkProdReplace.Checked) { partsBO1.prodnotes = txtNewNote.Text; }

if (chkShipAppend.Checked) { partsBO1.shipnotes += txtNewNote.Text; }

if (chkShipReplace.Checked) { partsBO1.shipnotes = txtNewNote.Text; }

partsBO1.Save();

}

}

waitWindow1.HideWaitWindow();





The result of this code is that only the first and last record are updated. All other selected parts in between are ignored. Each part number shows up in the WaitWindow as I cycle through the selected records; however, only the first and last records are actually persisted to the database.



Blink



Any ideas?



Thanks,

Bill

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Bill Cunnien - 15 Years Ago
Edhy Rijo - 15 Years Ago
Bill Cunnien - 15 Years Ago
Bill Cunnien - 15 Years Ago
Trent L. Taylor - 15 Years Ago
                         [quote]3. The planets are beginning to align for a total...
Bill Cunnien - 15 Years Ago
                             Ok. The ListView displays the data from a query within its own...
Bill Cunnien - 15 Years Ago
                                 AutoNavigateToSelectedRecord

Setting this to true did the...
Bill Cunnien - 15 Years Ago
                                     You will have to set the MultiSelect property to true in code. It is...
Trent L. Taylor - 15 Years Ago
                                         Yepper...that was the ticket.

So far, we have replaced that...
Bill Cunnien - 15 Years Ago
                                             What does your code look like now? Also, why are you calling edit?...
Trent L. Taylor - 15 Years Ago
                                                 Here's the code...I did take out the Edit(). I am now testing without...
Bill Cunnien - 15 Years Ago
                                                     If I select the first four in the list...only the first one is...
Bill Cunnien - 15 Years Ago
                                                     First, I would use a foreach. I would do something more like this:...
Trent L. Taylor - 15 Years Ago
                                                         Hi Bill,

Adding to Trent's reply, I have a this suggestion:...
Edhy Rijo - 15 Years Ago
                                                             Hi Edhy,

I did try using the checked property; however, the...
Bill Cunnien - 15 Years Ago
                                                                 Then there has to be something either set within your BO or some other...
Trent L. Taylor - 15 Years Ago
                                                                     There was other logic resetting CheckButton. :Whistling: I...
Bill Cunnien - 15 Years Ago
                                                                         Glad you got to the bottom of it! :)
Trent L. Taylor - 15 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search