Lantica User Forum - Table View: can this be modified

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Table View: can this be modified

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: 1

Send Topic

Print

Normal Topic

Table View: can this be modified (Read 693 times)

Infinity Senior Member Members Offline Diagonally parked in a parallel dimension Posts: 1290 Location: Massachusetts Joined: May 27^th, 2005	Table View: can this be modified Sep 12^th, 2007 at 11:17am	Print Post
	I'm using the "Toggle Table View" menu bar item (as posted in the Programming forum) and it works well, but it has an odd behavior. (I don't think the behavior is related to the item's programming; I seem to remember noticing this when I was using the function key.) Here's what happens: I toggle the table view and it pops up with all my records as selected and sorted according to my retrieve and sort specs. I can then click on any field of a specific record, and toggle it off, at which time I am taken to that specific record. Super! However, if I toggle the view to the table again, I'm plunked back at the first record, first column, same as when I started. What I'd like to do, naturally, is be presented with a table view with the record I was just on as the focus. Does that make sense? What happens now is I have to perform my vertical and horizontal scrolls all over again, to get back to the view I was just looking at. It this something I can control in some way?

	** Captain Infinity
	WWW IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Table View: can this be modified Reply #1 - Sep 12^th, 2007 at 6:53pm	Print Post
	If you are asking if there is an INI setting that controls this, the answer is No there is not. Table View will display the records starting with record number 1. -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

Infinity Senior Member Members Offline Diagonally parked in a parallel dimension Posts: 1290 Location: Massachusetts Joined: May 27^th, 2005	Re: Table View: can this be modified Reply #2 - Sep 13^th, 2007 at 4:05pm	Print Post
	Actually wasn't thinking of .ini, but programming. Say something using ResultSetCurrentPosition() and @SelectTreeItem("Search Update Menu!Other Commands!Toggle Table View (Shift-F6)") ?

	** Captain Infinity
	WWW IP Logged

Carl Underwood Senior Member Members Offline Posts: 1351 Location: New Hampshire Joined: Mar 11^th, 2003	Re: Table View: can this be modified Reply #3 - Sep 14^th, 2007 at 2:33am	Print Post
	Infinity wrote on Sep 13^th, 2007 at 4:05pm: Actually wasn't thinking of .ini, but programming. �Say something using ResultSetCurrentPosition() and @SelectTreeItem("Search Update Menu!Other Commands!Toggle Table View (Shift-F6)") �? During the Beta phase, I played around with the concept of combining @SelectTreeItem and @FormResultSetCurrentPosition in a command button, to make the table focus on the same record that was displayed in form view. But, there are some problems with it. The biggest being that it only works one time per form session. That is, if you open a form, navigate to the 10th record and click the button, you will be in table view AND on the 10th line. Then, if you press Shift-F6 to go back to form view, navigate to another record (say the 15th) and click the button, table view will open with focus on the 1st line. If you close the form and re-open it, the button will work again, just once. I don't know why that is.

	Carl Underwood CDU Computer Consulting LLC Epsom, New Hampshire
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Table View: can this be modified Reply #4 - Sep 14^th, 2007 at 3:20am	Print Post
	How about this general skeleton of flow? Button to Toggle Table View: If TableViewOFF then Get CurrentRecordPosition Set GlobalValue to TableViewOn, and GlobalValue of CurrentRecord Switch to Table View Toggle Table View to go back If TableViewOn then Set GlobalValue TableViewOff Go to RecordPosition = GlobalValue of CurrentRecord set earlier Clear GlobalValue of CurrentRecord Close Table View

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Carl Underwood Senior Member Members Offline Posts: 1351 Location: New Hampshire Joined: Mar 11^th, 2003	Re: Table View: can this be modified Reply #5 - Sep 14^th, 2007 at 3:25am	Print Post
	Hi Bob, I already tried GlobalValues, and they don't seem to help.

	Carl Underwood CDU Computer Consulting LLC Epsom, New Hampshire
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Table View: can this be modified Reply #6 - Sep 14^th, 2007 at 4:17am	Print Post
	I like the way you think Carl! How about static variable instead? You probably tried that too?

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Carl Underwood Senior Member Members Offline Posts: 1351 Location: New Hampshire Joined: Mar 11^th, 2003	Re: Table View: can this be modified Reply #7 - Sep 14^th, 2007 at 1:28pm	Print Post
	Bob_Hansen wrote on Sep 14^th, 2007 at 4:17am: I like the way you think Carl! How about static variable instead? �You probably tried that too? Yes, I did -- same results.

	Carl Underwood CDU Computer Consulting LLC Epsom, New Hampshire
	WWW IP Logged

Page Index Toggle

Pages: 1

Send Topic

Print

‹ Previous Topic | Next Topic ›

« Board Index ‹ Board Top

Top

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid XHTML

Valid CSS

Powered by Perl

Source Forge