Workfile as a "database"-file
Posted: Wed Apr 29, 2015 11:08 am
Hi
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
Regards Johan
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")