Yes, vOldBLNo is a row that still exists. They are not allowed to change the Primary Key BLNo field in the grid.
Originally I was using the form variable vBLNo which identifies the PK, but found that the Close/Open command put the focus back on the first row and changed the vBLNo variable. That's why I had to "save" the vBLNo of the row they were on and search using that variable after the Close/Open! Karen -----Original Message----- From: Dan Goldberg <[email protected]> To: rbase-l <[email protected]> Sent: Fri, Aug 25, 2017 11:46 am Subject: RE: [RBASE-L] - Help with DBGrid search command - correction Does vOldBLNo exist in the grid? If it does not the search will not do anything. Dan Goldberg From: karentellef via RBASE-L [mailto:[email protected]] Sent: Friday, August 25, 2017 9:14 AM To: [email protected] Subject: [RBASE-L] - Help with DBGrid search command - correction A slight error in my message: Using version X, 7/31 build. I have a grid based on a view. Clicking in a column runs eep code that updates the underlying data, does a CLOSE/OPEN of the grid's view. Problem is that I lose the focus on the row the user was on. I thought that the "search" command was the way to go. It traces fine, no errors, the variable values look correct, but it doesn't change focus. Focus stays on the first row of the refreshed grid. Can anyone find an error in my code, or suggest a different way? I do not want to use "filter" commands because I want all data to show up. SET VAR vOldBLNo = .vBLNo UPDATE salesdelwksheet SET po = .vPO WHERE blno = .vBLNo PROPERTY TABLE vSalesDelWksheet2 'CLOSE' PROPERTY TABLE vSalesDelWksheet2 'OPEN' SET VAR vCommand = ('PROPERTY TABLE vSalesDelWksheet2 SEARCH->BLNo->' + (CTXT(.vOldBLNo)) ) &vCommand Thanks for the help! Karen -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email [email protected]. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
