Ok, So I've got to go about this a different way, So I'm using this.
In the Open() event of the appication, I am doing this:
---------------
dim dbfile as FolderItem
app.AutoQuit = true
dbfile = GetFolderItem("").child("backend.rsd") 'Find the one in
the current folder
dbfile.CopyFileTo TemporaryFolder
dbfile = TemporaryFolder.child("backend.rsd")
if dbfile<>nil and dbfile.Exists then
db = new REALSQLDatabase
db.DatabaseFile = dbfile
if not db.Connect() then
MsgBox "Could not connect to database."
quit
end if
else
MsgBox "Data files not found"
quit
end if
---------------
In the App.Close() event, I am doing this:
---------------
dim dbfile,destfile as FolderItem
db.Close
dbfile = TemporaryFolder.child("backend.rsd") 'Find the one in the
temporary folder
destfile = GetFolderItem("").child("backend.rsd")
if destfile.Exists then
destfile.Delete
end if
dbfile.CopyFileTo destfile
dbfile.Delete
---------------
Not as elegant as I had hoped for, and it will be a pain if the
backend ever gets big, but for the time being it will work for this
application (single user at the moment anyway) I just wanted to have
the data portion reside on our server that gets regularly backed up.
Thanks for all your help.
Greg
On Feb 28, 2006, at 6:42 pm, Marco Bambini wrote:
Unfortunately this is a know bug that affect sqlite since version 2.
Only Apple has developed a solution right now for the library
included in OSX 10.4 and this fix isn't yet merged in the official
distribution.
For who is interested the Apple bug is described here: http://
developer.apple.com/technotes/tn/tn2037.html
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
On Feb 28, 2006, at 11:52 PM, Chris Little wrote:
on 2/28/06 4:58 PM, Stefan Pantke at [EMAIL PROTECTED] wrote:
Am 28.02.2006 um 22:40 schrieb Chris Little:
on 2/28/06 3:41 PM, Greg at [EMAIL PROTECTED] wrote:
but the folderitem is the same at the end of the conditional
area as
it was before and I still get the error. I wonder if this is a
10.4
issue.....I'll try to get our 10.3 machine to try it out...
I believe that REALSQLDatabase's are not supported on a network
volume under
OS X.
Then, this question comes to mind: What's the difference between
a local volume and a share?
There might be some difference, but more or less any app that
I know of, works in a share.
Could someone explain?
I believe that there is a problem with one of the file APIs that
SQLite 3
uses on OS X. A search of the SQLite mailing list should reveal the
background.
Chris
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
