Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding Rows-Perplexed
Message
From
09/06/2006 23:57:37
 
 
To
09/06/2006 12:25:39
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Pro
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01128125
Message ID:
01128251
Views:
22
Can you try using this in your code
=TABLEUPDATE(.T.,.T.,<table to update alias>)
Flush           && Flush is not necessary but just in case if you have a small bit of doubt
=Requery(<alias>) 

* Refresh your LISTBOX control 
* Refresh your form and other controls. 
You can take a look at VFP Help on different Buffering Types and TABLEUPDATE.



>Dave:
>I am using buffering. On my form I have a listbox which shows the records in the table. The form also has an add/save button. When I do the "save" I issue tableupdate() and also do the "...requery" to the listbox. As a result, the listbox DOES get refreshed with the newly added row... great.
>Then when I click on the newly added row in the listbox, within the click(), I do a LOCATE on the table, and it never finds the newly added row in the table. It finds all the others ok. It's as if the row has not been committed. I thought the tableupdate() function was supposed to commit changes to a table, but it doesn't seem to be happening here.
>Rich
Sanjay Dhiraj Patel

MCSE, MCDBA

Net2Biz (Thailand)
Previous
Reply
Map
View

Click here to load this message in the networking platform