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 to [email protected]<mailto:[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.
