Just asking those of you out there who use SPT with an SQL Back End how you 
handle Grid refreshes (refreshing the underlying data) when browsing tables on 
the main data server assuming that you may well stay on a browse window when  
somebody else may well update the data.

I am just trying to write a small set of demo forms using Remote views, Cursor 
Adapters as well as SPT for Tom here in order to better explain the 
advantages/disadvantages of each data access method. Obviously with cursor 
adapters you can issue a cursorRefresh() against the back end and with remote 
views you can do a requery() against the view. The only method I use with SPT 
is in fact to issue the "select..." again.

Anyone got any better suggestions apart from using stored procedures on the 
back end which I don't really want to use.

The nice thing about the remote view and cursor adapter method is that the 
currently selected row gets preserved in the grid. I have tried the same in SPT 
by saving the current row and navigating to it after the re-select but it 
causes screen glitches regardless of using _Screen.Lockscreen unless anyone 
else has a better idea!

Dave



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to