Re: New Era & manual column supertables

Paul Bennett <bennettp@stangen.pix.za> wrote: >I have a problem when using grid-form supertables with manual columns. >The reason I am using these, is that I have found that when a supertable >is tied to a table, it has poorer performance than when you use your own >SQL fetches & populate the table manually. Are you sure the SQL is identical? We found that doing your own fetch is slower (but only marginally). >1. When scrolling to the bottom of the grid-form, the scroll bar >dissappears & the supertable is wiped clean. We have no problems with this. How are you populating the supertable? >2. When I have 2 grid forms, (highlight a row in the one, and >subsequently populate the 2nd grid form from the 1st's select row event) >I have a problem where the first time I select a row, every row is >returned, but subsequent times, the first row is omitted. By forcing a >focus out of the first supertable, I can get it to return all rows. Are the right event generated the second time? I'm not sure what you mean by "the first row is omitted". Please explain. >I am now considering rewriting the app using supertables linked to >tables. Doing your own SQL gives you more flexibility so that's what we use. >If anyone has info that can help me, please reply. >Thanks, P.N.Bennett >BennettP@stangen.pix.za David W Chan GO5 Limited david@go5.com (work) dwc@cix.compulink.co.uk (home)