Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>See my question and answer here: <a href="https://stackoverflow.com/questions/10259692/app-sandbox-document-scoped-bookmark-not-resolving-not-returning-any-error">App Sandbox: document-scoped bookmark not resolving; not returning any error</a></p> <p>I'm embedding collection-scoped bookmarks into my XML files.</p> <p><strong>Update</strong></p> <p>Given the specification that you have no control over the input XML format, the only way to get access for your app to a file specified in the XML is by having the user select that file or one of the file's parent directories in an <code>NSOpenPanel</code>. If the XML contains multiple file references, you can have the user grant access to a directory that contains all of them.</p> <p>There is no way around asking permission, since that would defeat the purpose of sandboxing. If your app could get around the user's direct permission, so could malware. Once given access, though, you can create a security-scoped bookmark to each file so you don't need to ask the user for permission multiple times.</p> <p><strong>Update 2</strong></p> <p>Answering the question in your comment, you can make the dialog easier for the user with the following:</p> <pre><code>[openPanel setMessage:@"Click 'OK' to allow access to files contained in the selected directory"]; [openPanel setDirectoryURL:[NSURL fileURLWithPath:pathFromTheXMLFile]]; </code></pre> <p>Here's the <a href="https://developer.apple.com/library/mac/#documentation/Cocoa/Reference/ApplicationKit/Classes/NSSavePanel_Class/Reference/Reference.html#//apple_ref/occ/cl/NSSavePanel" rel="nofollow noreferrer">documentation on <code>NSSavePanel</code></a> (<code>NSOpenPanel</code> inherits from it, and the properties above are defined there).</p>
    singulars
    1. This table or related slice is empty.
    1. POHow do I gain access to files referenced by another file when sandboxed (app-store)
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USDov
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow do I gain access to files referenced by another file when sandboxed (app-store)
      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. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTBountyClose
    1. COThe XML file is not created by me, it's exported from another application, so I can't control what goes into it.
      singulars
      1. PO
      1. USGrezzo
    2. COFair enough, I was just hoping to find abetter way of asking for permission than having the user browse. It seems there is no other way. The solution we have implemented is to tell the user which folder contains files that we need to access, then get them to browse to that folder. The files are often in subfolders of a folder like ~/Documents, so I am telling them that a higher folder is fine. I am storing the bookmarks, so they hopefully won't have to browse to them very often.
      singulars
      1. PO
      1. USGrezzo
    3. COYou can also initialize the browser to the folder you suggest, and give explanatory text in the browser. All they have to do is click "OK" (or you can even change that button's caption to something like "Allow").
      singulars
      1. PO
      1. USDov
 

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