Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>My understanding is that you have control over how XML file gets embedded into PowerPoint presentation in the first place. Here I do not quite understand why you chose to keep the data you need as <em>contents</em> of an embedded object.</p> <p>To be sure, the task of getting those contents back is not a piece of cake. Actually, as long as there is no (simple or even moderately difficult) way to call <code>QueryInterface</code> and use <code>IPersist*</code> interfaces from VBA, there is just one way to get to contents of embedded object. The way involves following steps:</p> <ol> <li>Activate an embedded object. You used <code>OLEFormat.DoVerb 1</code> for that. A better way would be to call <code>OLEFormat.Activate</code>, but this is irrelevant for your particular problem.</li> <li>Use embedded object's programming model to perform useful operations like getting contents, saving or whatever is exposed. <code>Notepad.exe</code> exposes no such programming model, and you resorted to <code>WinAPI</code> which is the best choice available.</li> </ol> <p>Unfortunately, your current approach has at least 2 flaws:</p> <ol> <li>The one you identified in the question (activation of <code>notepad.exe</code> leading to possibility of user's interference).</li> <li>If a user has default program for opening <code>.txt</code> files other than <code>notepad.exe</code>, your approach is doomed.</li> </ol> <p>If you do have control over how embedded object is created then better approach would be to store your XML data in some property of <code>Shape</code> object. I would use <a href="http://msdn.microsoft.com/en-us/library/office/bb265694.aspx" rel="nofollow"><code>Shape.AlternativeText</code></a> (very straightforward to use; shouldn't be used if you export your <code>.pptm</code> to HTML or have some different scenario where <code>AlternativeText</code> matters) or <a href="http://msdn.microsoft.com/en-us/library/office/bb265778.aspx" rel="nofollow"><code>Shape.Tags</code></a> (this one is probably the most semantically correct for the task) for that.</p>
    singulars
    1. This table or related slice is empty.
    1. POVBA to Prevent Keyboard Input While a Package Object (XML) is Read into ADODB Stream?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USIlya Kurnosov
    1. USIlya Kurnosov
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POVBA to Prevent Keyboard Input While a Package Object (XML) is Read into ADODB Stream?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTBountyClose
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThanks for the detailed response. I have control over how the XML gets embedded. I am writing a txt/xml file with FSO, then embedding that file as the object. I had experimented with storing the contents in a `TextBox` shape, but had some problems with the application crashing when I try this with very long strings (several hundred thousands of characters). I am going to revisit that approach and/or the `AlternativeText` property, since I think the crash error was caused by how I was generating "dummy" string data (a loop caused the crash, not the size of the string).
      singulars
      1. PO
      1. USDavid Zemens
    2. COThere is a limit to this approach somewhere about 5.23MM and 5.28MM characters but that may well exceed the length of any user-generated XML (that is about 100x larger than the sample XML embed). I will have to do further testing to make sure this limit is within reasonably expected use cases, but if not, I could always split the XML string in to multiple shapes. I very much prefer this method so far. Thanks again!
      singulars
      1. PO
      1. USDavid Zemens
    3. COThis is working great -- and it's pretty much what I *wanted* to do before I went down the XML/Notepad route, anyways. Although Sid's response also adequately resolves this problem, I think this approach is ultimately the best solution for the reasons you stated.
      singulars
      1. PO
      1. USDavid Zemens
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload