When copying data from another workfile it's possible to copy by entering the full path to the workfile. We are working on a network and not using the local c-drive. For us it is much faster to open the workfile by command "dbopen" and then copy series. I don't think this is the correct way to do it, but the fastes way for us. (The manual indicates, however, that this is not an option).
Anyway, when opening a workfile as a "database" its possibly to copy from diffrent sheets. But there only possibly to query from the first sheet? If I hit the button "all" in the workfile that is open whith "dbopen" only the objects in the first sheets are visibly.
Is this a bug? There would bee nice to be able to query/see all series from all sheets.
Attaching som exampel code
Code: Select all
' STEP 1
WfCreate(wf=firstwf,page=a) a 2010 2015
PageCreate(page=q) q 2010 2015
PageSelect A
Series testing = 40
PageSelect Q
Series testing = 20
WfSave c:\temp\firstwf
Close @All
' STEP 2 - Works
WfCreate(wf=secondwf,page=a) a 2010 2015
PageCreate(page=q) q 2010 2015
DbOpen c:\temp\firstwf.wf1
Copy firstwf::a\testing a\
Copy firstwf::q\testing q\
' STEP 3 WQuery
' Works
String tmp1
tmp1 = @WQuery("firstwf","name matches testing and freq=A", "name, freq")
' Does not works
String tmp2
tmp2 = @WQuery("firstwf","name matches testing and freq=Q", "name, freq")