Normal Topic Questions On Table View (Read 1204 times)
josebetzy
Member
*
Offline


Hmmm. How? Cómo?

Posts: 33
Location: Las Piedras, Puerto Rico
Joined: Dec 15th, 2003
Questions On Table View
Feb 7th, 2004 at 2:22pm
Print Post Print Post  
I have a form which has quite a few elements. When I select Table View it takes a while for it to display. When it does display, all of the elements are included. Is there a way to limit what elements are displayed. I have looked at the table views in the examples but do not understand the way they are structured.

Can I design more than one table view for a particular DB?




  

Jose L. Muñoz
Back to top
 
IP Logged
 
Alec
Lanticans
*****
Offline



Posts: 200
Location: Ascot, England, UK
Joined: Nov 22nd, 2002
Re: Questions On Table View
Reply #1 - Feb 8th, 2004 at 7:05pm
Print Post Print Post  
No, you can't customise table view.  However, you can create multiple forms, with an eye to how they will appear in table view.
  

Alec
Back to top
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: Questions On Table View
Reply #2 - Feb 8th, 2004 at 9:20pm
Print Post Print Post  
What does determine the order of fields in tableview? I have made just a second form using the Layout Element bound to existing database  (folder in the command tree) field. I was surprized to see that my last field appears before the first in tableview.

  
Back to top
 
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: Questions On Table View
Reply #3 - Feb 8th, 2004 at 9:32pm
Print Post Print Post  
Quote:
Can I design more than one table view for a particular DB?  


josebetzy, As Alec pointed out, you have to make different layout form with a few LEs to display fields value of the underlying database you want to view in tableview.  See the LEs as the windows which display the values of the underlined database.  Just make certain that you bind these elements to the proper field of the database using property editor.
« Last Edit: Feb 9th, 2004 at 12:31am by Bharat_Naik »  
Back to top
 
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: Questions On Table View
Reply #4 - Feb 8th, 2004 at 9:56pm
Print Post Print Post  
Quote:
What does determine the order of fields in tableview?

Huh! It is the field order in the underlying database.  Well, it will be more practical to have order determined by the order of layout elements, that way users can choose the order in table view.  Is there anyway to change the database field order?  
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Questions On Table View
Reply #5 - Feb 8th, 2004 at 10:25pm
Print Post Print Post  
While you can't change the underlying order of the fields in Table View (Shift-F6), you can reorder the columns using drag and drop on the column headers while it is being viewed. However, it is not retained the next time you bring up Table View.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
josebetzy
Member
*
Offline


Hmmm. How? Cómo?

Posts: 33
Location: Las Piedras, Puerto Rico
Joined: Dec 15th, 2003
Re: Questions On Table View
Reply #6 - Feb 9th, 2004 at 1:33am
Print Post Print Post  
Thanks for the clarification.  I certainly believe that this should be addressed for future versions.  At least the last Table View layout should be retained if nothing else.  It seems, at least to me, that a feature to add table lookup would be available if the table view is set to the form content, or am I missing something.

Speaking about sort order, I have resorted (reorganised) the layout elements in Change Program Execution Order, but even after saving the form and reconciling, when I go to the form, it does not follow the sort order I programmed. It just follows the natural next field. I have tried it several times but no luck. Any ideas?
  

Jose L. Muñoz
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Questions On Table View
Reply #7 - Feb 9th, 2004 at 7:26pm
Print Post Print Post  
josebetzy

Description of "Program Execution Order " from page 124 in the Sesame user Guide

".. This is where you control in what order Sesame will execute On-Form-Change programming statements in separate layout elements"


as of right now the only way to change the tab order, to anything other than natural tab order, is with sbasic programming.
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
josebetzy
Member
*
Offline


Hmmm. How? Cómo?

Posts: 33
Location: Las Piedras, Puerto Rico
Joined: Dec 15th, 2003
Re: Questions On Table View
Reply #8 - Feb 12th, 2004 at 3:45am
Print Post Print Post  
Thank you. I did read and understood it wrong. Back to the drawing board.
  

Jose L. Muñoz
Back to top
 
IP Logged