Grid Problem

[SteveMacPSU]

I have a form that contains a grid that displays a list of names from a table. The current data from the selected record on the grid is displayed on the right side of the form. When I delete the record and refresh the grid the name still appears with the accompanying data. When I look in the table the record is marked for deletion. I have set deleted on, and can see the record in the table when I set deleted off. But either way it still shows in the grid until I pack the table. Thoughts?

 

[Mike Gagnon]

Is the SET DELETE ON put in the init of the form? It is datasession sensitive.


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)

 

[SteveMacPSU]

Mike,

That did the trick, thank you so much for the quick response. Does that mean I have to put that into the init event of all forms? I guess I'm not exactly sure what a Datasession is.

 

[Mike Gagnon]

Take a look in the help file at all the SET commands. You will find information about what scope they will affect. For example if you look at SET DELETED ON near the bottom you will find this notice SET DELETED is scoped to the current data session.. So if for example you use private datasession in your forms, that means that everytime two people open that form in your application they each have their own datasession, meaning that what ever changes they make to the data in their own datasession will not affect the other user's session and nothing is final until it is written to the disk with a tableupdate or a FLUSH. A good bunch of SET commands need to be reset in the init of each forms because whatever was set elsewhere no longer applies to the datasession.



Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)