Re: [RBASE-L] - go to today in enhanced dbgrid

[A. Razzak Memon]

At 09:30 AM 1/26/2017, Karen Tellef wrote:


Nope, sorry, didn't see the 2nd response.


Here's my advice ...

How about doing your homework prior to responding to any of "my" posts?



Razzak:  Are you saying that the "JUMPTO 2" command no longer works??
I'm pretty sure I'm still using that from previous versions, 
although I haven't coded
a new one in years.  If I bring up a form sorted by the State, and I 
have a button
that puts the cursor on the first Illinois row, and I know that 
Illinois starts on

row 100, then I do "JUMPTO 100"



In my reply, did I say that "JUMPTO 2" command no longer works?

No. I did not.

Here's what I said:

FWIW ... JUMPTO only "jumps" the number of record(s) and does NOT 
jump to the matched record.


If it helps ...
Syntax:
PROPERTY TABLE FormTable 'JUMPTO absPos'
Where:
FormTable is the appointed table by property
absPos is the absolute record to jump to, positive only or backward 
with negative value


Razzak




-Original Message-
From: A. Razzak Memon <raz...@rbase.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Thu, Jan 26, 2017 8:10 am
Subject: Re: [RBASE-L] - go to today in enhanced dbgrid

You apparently didn't see my second (Part 2) post, that illustrates
the "SEARCH" option of the Enhanced DB Grid.

FWIW ... JUMPTO only "jumps" the number of record(s) and does NOT
jump to the matched record.

Razzak

At 08:57 AM 1/26/2017, Karen Tellef wrote:

>I see Razzak's examples, which are basically filters. But if you
>want to keep all the
>records on the screen and just MOVE to the record, can you try the
>"jump" command?
>
>PROPERTY TABLE TableName 'JUMPTO 2'
>
>If there's a way you can determine which row your first "today" is
>on, you could jump
>to that row. Of course, this would get screwed up if the user
>resorted. If it's a temp table,
>you could autonumber the records.
>
>If you don't excessive scrolling, you could do this instead:
>
>PROPERTY TABLE TableName 'JUMP 1'
>
>You could move down the grid one row at a time, check the date, and
>keep jumping 1 row at a time


--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - go to today in enhanced dbgrid

[Dan Goldberg]

Thx That did it!

Not sure why mine didn't work when I typed it.

Dan Goldberg

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
A. Razzak Memon
Sent: Wednesday, January 25, 2017 5:49 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - go to today in enhanced dbgrid

At 05:18 PM 1/25/2017, Dan Goldberg wrote:

>Does anyone have an ideas to accomplish it?


Part 2 ...

If you would like the SEARCH option of the Enhanced DB Grid, use the following 
technique to accomplish your goal.

Here's how:

-- A very simple technique ...

Button Caption: [Show Today's]
On Click EEP:
-- Show Today's
SET VAR vSearch TEXT = +
('PROPERTY TABLE InvoiceHeader SEARCH->TransDate->'+(CTXT(.#DATE)))

RETURN

Note:

. There are no filters involved in this example . You will need to create a 
concatenated text string to use the PROPERTY command

For your viewing pleasure ...

http://www.razzak.com/tips/Ehnanced_DB_Grid_Column_Search_01.png
http://www.razzak.com/tips/Ehnanced_DB_Grid_Column_Search_02.png

Have fun!

Very Best R:egards,

Razzak


--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - go to today in enhanced dbgrid

[A. Razzak Memon]

You apparently didn't see my second (Part 2) post, that illustrates 
the "SEARCH" option of the Enhanced DB Grid.


FWIW ... JUMPTO only "jumps" the number of record(s) and does NOT 
jump to the matched record.


Razzak


At 08:57 AM 1/26/2017, Karen Tellef wrote:

I see Razzak's examples, which are basically filters.  But if you 
want to keep all the
records on the screen and just MOVE to the record, can you try the 
"jump" command?


PROPERTY TABLE TableName 'JUMPTO 2'

If there's a way you can determine which row your first "today" is 
on, you could jump
to that row.  Of course, this would get screwed up if the user 
resorted.  If it's a temp table,

you could autonumber the records.

If you don't excessive scrolling, you could do this instead:

PROPERTY TABLE TableName 'JUMP 1'

You could move down the grid one row at a time, check the date, and 
keep jumping 1 row at a time


--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - go to today in enhanced dbgrid

[A. Razzak Memon]

At 05:18 PM 1/25/2017, Dan Goldberg wrote:


Does anyone have an ideas to accomplish it?



Part 2 ...

If you would like the SEARCH option of the Enhanced DB Grid, use the following
technique to accomplish your goal.

Here's how:

-- A very simple technique ...

   Button Caption: [Show Today's]
   On Click EEP:
   -- Show Today's
   SET VAR vSearch TEXT = +
   ('PROPERTY TABLE InvoiceHeader SEARCH->TransDate->'+(CTXT(.#DATE)))
   
   RETURN

Note:

. There are no filters involved in this example
. You will need to create a concatenated text string to use the 
PROPERTY command


For your viewing pleasure ...

http://www.razzak.com/tips/Ehnanced_DB_Grid_Column_Search_01.png
http://www.razzak.com/tips/Ehnanced_DB_Grid_Column_Search_02.png

Have fun!

Very Best R:egards,

Razzak


--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - go to today in enhanced dbgrid

[A. Razzak Memon]

At 05:18 PM 1/25/2017, Dan Goldberg wrote:


Does anyone have an ideas to accomplish it?


If your users don't want to use the filter or are reluctant to type 
today's date, then create
a button that automatically filters the Enhanced DB Grid and displays 
all "Today's" orders.


Here's how:

-- A very simple technique ...

   Button Caption: [Show Today's]
   On Click EEP:
   -- Show Today's
   PROPERTY DBGrid_Invoices FILTERS->COLUMN_NAME->TransDate .#DATE
   RETURN

For your viewing pleasure ...

http://www.razzak.com/tips/Ehnanced_DB_Grid_GoTo_Todays_01.png
http://www.razzak.com/tips/Ehnanced_DB_Grid_GoTo_Todays_02.png

Let me know if you need that form to illustrate the use of such technique.

Very Best R:egards,

Razzak


--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - go to today in enhanced dbgrid

[Dan Goldberg]

Thx. I tried it and it is not working. I must be missing something.

Dan Goldberg

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Albert Berry
Sent: Wednesday, January 25, 2017 3:49 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - go to today in enhanced dbgrid

Try something like this? All the bold must be within quotes

PROPERTY TABLE 'FORMTABLENAME SEARCH->COLUMNNAME->' ‘value'

‘ScheduleTable SEARCH>DateColumn’ ‘.#DATE’

Albert


On Jan 25, 2017, at 3:18 PM, Dan Goldberg 
<d...@lancecamper.com<mailto:d...@lancecamper.com>> wrote:

I have a request from users to go to today’s schedule via a button in an 
enhanced dbgrid. They do not want to use the filter.

When it opens it is sorted by the newest date first, which is 6 months from 
now. So they have to page down for a bit to get to it. They want to be able to 
click a button and it takes them to today so they can look forward from there.

For some reason I cannot think of a property to do that. I know I can filter by 
just today but they want to be able to scroll to other days(future and past) 
starting from there.



Does anyone have an ideas to accomplish it?

TIA

Dan Goldberg

--
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 
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

--
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 
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - go to today in enhanced dbgrid

[Albert Berry]

Try something like this? All the bold must be within quotes

PROPERTY TABLE 'FORMTABLENAME SEARCH->COLUMNNAME->' ‘value'

‘ScheduleTable SEARCH>DateColumn’ ‘.#DATE’

Albert

> On Jan 25, 2017, at 3:18 PM, Dan Goldberg  wrote:
> 
> I have a request from users to go to today’s schedule via a button in an 
> enhanced dbgrid. They do not want to use the filter.
>  
> When it opens it is sorted by the newest date first, which is 6 months from 
> now. So they have to page down for a bit to get to it. They want to be able 
> to click a button and it takes them to today so they can look forward from 
> there.
>  
> For some reason I cannot think of a property to do that. I know I can filter 
> by just today but they want to be able to scroll to other days(future and 
> past) starting from there.
>  
> 
>  
> Does anyone have an ideas to accomplish it?
>  
> TIA
>  
> Dan Goldberg
> 
> -- 
> 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 rbase-l+unsubscr...@googlegroups.com 
> .
> For more options, visit https://groups.google.com/d/optout 
> .

-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.