Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Not updating table
Message
From
14/06/2005 09:31:27
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Not updating table
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01023078
Message ID:
01023078
Views:
68
I have the following code. But once I condcut a =requery(), nothing shows up in the table. When I look at the raw data, the records are not being updated.
SELE v_FedEx  &&This is a local view. the base table is FEDEX.dbf

llsuccess = TABLEUPDATE(.T.)

IF !llsuccess
	aerror(aSQLError)
	msg = "Data was not saved -- call a programmer"
	messagebox(msg, 0+16+0, "Data Update Failure")
	list memory like aSQLError noconsole to print
	=TABLEREVERT(.t., .t.)
	=REQUERY()
ELSE
	brow && At this point, everything looks okay
	=REQUERY()
	brow  && At this point, nothing appears in the local view of the table
ENDIF
Thanks in Advance.

J. Turner
Next
Reply
Map
View

Click here to load this message in the networking platform