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]<mailto:[email protected]>>
To: rbase-l <[email protected]<mailto:[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]<mailto:[email protected]?>]
Sent: Friday, August 25, 2017 9:14 AM
To: [email protected]<mailto:[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]<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]<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.
