>Cetin
> I use copy to table, only if nothing else will work
>Really I am angry, because described method really works for natural tables , put into environment of first form and fast like devil
>use gain for query works fast inside one form. Why this method does not work
>for two forms like it works for them for natural tables
>Does it mean some gap in dataenvironment.addobject method
>or gap between different datasession
>I know some old sample similar to it, I marked in 1997
>let we have some main form in default session when we need
>to read reference tables and let we have private form to get these refrence tables , really to read it only. From this second form we can call thrird forms to add new records or edit records in refrence table
>So, if we shall do readonly=.t. on the first or second form ,it will be error in the third form (private session), where we have not readonly for same table
>It will say-table is read only.
>Private session should not be sencitive to cursor property from other form with default or private session, but it sencitive to it
>Here is something very similar.
I remember that one... puzzled me well. Did you try to select from it instead of reusing it? Like
Select * from (thisform.ob.dataenvironment.tmp.datasource) into cursor tmp_new
It should give you a filtered cursor which should be equally fast.
Let me guess - you're trying to build a pyramid with a spoon and a toothpick, IOW, trying to make something really big work, and your machines are low-end? Been there, done that. Good luck.