Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Requerying Backend Data.

Status
Not open for further replies.

knopmike

Programmer
Sep 6, 2001
12
CA
I have a form that uses a pageframe object such that a remote view is associated with each page. I've implemented code such that on the activate of the page, I select the view associated with it and do a requery (the goal is to have current data). Everything appears to work ok except when I click on a tab that I've already clicked on before, I get the following:

Table buffer for alias "name" contains uncommitted changes (Error 1545)

The code for my activate looks like this:

select (this.viewname)
liLocation = recno()
tablerevert(.f.)
requery(this.viewname)
if !(liLocation > reccount())
go liLocation
endif

Without the tablerevert command above, I get the above error message every time I click on a tab; with tablerevert I can at least click on a tab once, but when I click on another tab and come back, I get the error message.

Any help would be appreciated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top