Yeah, you're sorta right. This form started out with an editable DBGrid based on a table. Then we switched it to be based on a view (and therefore became not-editable), and it was easier to simply modify the existing DBGrid to be based on a view than to throw it out and turn it into a list view. But a list view is on our "workaround" list if we don't get this to work.
Karen -----Original Message----- From: jan johansen <[email protected]> To: rbase-l <[email protected]> Sent: Fri, Aug 25, 2017 12:40 pm Subject: RE: [RBASE-L] - Help with DBGrid search command - correction Karen, Why are you using a DB-Grid? Seems you can you do want with Variable List View that you can keep the focus on the row. Jan -----Original Message----- From: Dan Goldberg <[email protected]> To: "[email protected]" <[email protected]> Date: Fri, 25 Aug 2017 16:57:35 +0000 Subject: RE: [RBASE-L] - Help with DBGrid search command - correction Don’t know. I use the search command that looks the same as yours. I use a similar code without any issues. SET VAR vedate DATE = (.#DATE - 1) SET VAR vesearch TEXT = ('PROPERTY TABLE orders99 SEARCH->onlinedate->'++ (CTXT (.#date))) &vesearch Dan Goldberg From: karentellef via RBASE-L [mailto:[email protected]] Sent: Friday, August 25, 2017 9:49 AM To: [email protected] Subject: Re: [RBASE-L] - Help with DBGrid search command - correction 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 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. -- 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. -- 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.
