>>>>Did you Grid.Refresh after Append the record? You should give some credit to MS Foxpro team, most of things they do all right.
>>>
>>>Yes, I did a Grid.Refresh() after the APPEND
>>
>>I believe your problem is with the Requery(). If you do the requery it will go back to the database and run the query again. You can add records to the view and refresh the grid. Just don't requery until you want a new result set. When you have finished adding records you can do your tableupdate or tablerevert.
>
>I removed my Requery(), but now I see only a blank record.
The basic logic should be something like this:
User selects add button
append blank to the view
your form has text boxes etc tied to the view as datasource
if adding into a grid then refresh grid to show this new record
user enters data (goes into the blank record)
refresh your grid to display the data.
now user can save or cancel. You do either a tableupdate or tablerevert
You only need to requery when you need a new result set.
Remember, with buffered data you can add, delete, edit records to your hearts content and you can always back out of the changes with a tablerevert and none of the changes will be saved until the tableupdate. (No more scatter and gathers required. You can now work directly with the table or view)
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only