table keeps filter after it's closed?

[thatguy]

Hey there,

so i'm creating my own dataenvironment with several tables, one of which has a filter set. the DE closes with the form (a form class actually) and all tables close as they should. then i open the same table (the one that had the filter) into a different DE in a different form class, but the same filter is set!

i've stepped thru the program and made sure that the tables do, in fact, close. i even put a 'de.closetables()' call into the formclass.unload() event. but still, as soon as i open the table again in a different de, the filter is still set. is there some reasonable explanation for this?

thanks.
-- michael~

 

[fluteplr]

are you sure you have your data session set to private?

 

[Morpheus1981]

Then set filter to nothing each time u load ur form or each time u close it. aND DONE

 

[thatguy]

setting the filter to nothing on form.unload() works, but that seems to be just a workaround for a problem that shouldn't exist.

i open the table into a de (programmatically with createobject(), not using the de designer), set a filter (this.thisde.otable.filter = 'filter'), do my work, then that de object gets destroyed with the form's close (i even tried issuing closetable() on form.unload() with no difference). the next time the table is opened in a completely different form with a different de, the same filter exists on the table.

can anyone tell me why this happens??

thanks,
-- michael~

 

[fumbles]

Are you explicitly releasing the variable that holds your data environment? It may be that VFP is looking for a particular object name when it releases the form. Since you used creatobject for your de object, rather than the visual design tools, your variable may not be automatically released.