I usually use the following constraction
select * from table into tmp
use dbf('tmp') again in 0 alias newalias and it always worked
Today I face with new situstion
Here it is
I have first form with default datasession
somewhere in code I do select and put it into dataenvironment
like this
select * from table into tmp
thisform.dataenvironment.addobject('tmp','cursor')
thisform.dataenvironment.tmp.alias='tmp'
thisform.dataenvironment.cursorsource=dbf('tmp')
I tested after it I can do
select * from (thisform.dataenvironment.tmp.alias) into cursor _tmp
work OK
and
use (thisform.dataenvironment.tmp.cursorsource) again alias _tm
It work OK
Now I did second form with private datasession, which I call from first one
like do form second with thisform
In init of the second form I wrote
lparameters _ob
thisform.ob=_ob
Now I tryed to repeat use comand for cursor from first form like that
use (thisform.ob.dataenvironment.tmp.cursorsource) again alias _tmr
and recieved the message about error number 3-file is in use
I did it to get data from the first form in my second form
You can say, put this table directly in the second form dataenvironment
Sure, it will work. But I have very serious reason don't do it
I did it all for client-server and I try to avoid many similar queries
to the server.
In my project second form can be called many times from first one at diffrent records, thats why it
second form must be in private datasession
I whanted to make all queris all reference data in first form and
get them already on client side in the second forms
So, whay use with again here fails?!!!
Sorry for very long exlanation
I have some other mechanism of sending/getting cursor data between forms with diffrent datasession. but it requies lots of coding, sending afields data from first form to second, making cursor there and making sicle to insert
all records from from from first form to second with private datasession constantly switchind datasessionid, so I started to hate it and wahnted to develope something new
Thanks in advance
Vladimir Zhuravelv
Thanks in advance