C
Chris Redekop
Using OWC10, I've set up a pivot table to use data from an XML file. For
some reason it is hitting the server twice to retrieve the XML. Given the
following chunk of code, it hits the server once on line #2 (which makes
sense) and once on line #4 (why would it need to refresh the recordset
there?).
datasource.ConnectionString = "Provider=MSPersist.1";
name =
datasource.RecordsetDefs.AddNew("urltoxmlfile",datasource.Constants.dscComma
ndFile);
pivot.DataSource = document.dsc;
pivot.DataMember = name;
This wouldn't be a huge problem, but the XML file is potentially quite
large, and it is dynamically generated by a server-side script, so it's
basically taking twice as long as it needs to. Is there a flag or something
I can specify in the data itself to tell it to not refresh (unless of course
the user explicitly refreshes the data)?
some reason it is hitting the server twice to retrieve the XML. Given the
following chunk of code, it hits the server once on line #2 (which makes
sense) and once on line #4 (why would it need to refresh the recordset
there?).
datasource.ConnectionString = "Provider=MSPersist.1";
name =
datasource.RecordsetDefs.AddNew("urltoxmlfile",datasource.Constants.dscComma
ndFile);
pivot.DataSource = document.dsc;
pivot.DataMember = name;
This wouldn't be a huge problem, but the XML file is potentially quite
large, and it is dynamically generated by a server-side script, so it's
basically taking twice as long as it needs to. Is there a flag or something
I can specify in the data itself to tell it to not refresh (unless of course
the user explicitly refreshes the data)?