realbasic-nug
[Top] [All Lists]

Re: SaveInfo stored in RSQLDb not working

To: REALbasic NUG <realbasic-nug at lists dot realsoftware dot com>
Subject: Re: SaveInfo stored in RSQLDb not working
From: andrew at kellerfarm dot com
Date: Sat, 30 Jul 2005 23:44:19 -0400
Delivered-to: realbasic-nug at lists dot realsoftware dot com
References: <9AD9BB5C-D2A5-4EAB-8A56-387339217EF6 at kellerfarm dot com> <3889FC31-40FF-48A4-8071-6CC8E6667DE4 at bradrhine dot com>
For storing:
<connect to database>
<get recordset>
rs.Field("FileLocOSX").Value = EncodeBase64(f.GetSaveInfo(Nil))
rs.Update
db.Commit
db.Close

For retrieving:
<connect to database>
<get recordset>
s = DecodeBase64(rs.Field("FileLocOSX").Value)
f = GetFolderitem(s)

The debugger shows that a string is retrieved out of the database, however GetFolderitem can't make a folderitem with it for some reason.

Andrew Keller


On Jul 30, 2005, at 11:30 PM, Brad Rhine wrote:

I do this all the time with SQLite 2 databases and it works great. Can you show us some code?

On Jul 30, 2005, at 11:26 PM, andrew at kellerfarm dot com wrote:

I have a field in a REALSQLDatabase that contains the SaveInfo pointing to a file. Whenever I try to access the data, however, GetFolderitem cannot create a folderitem from it. I have simplified the code as much as possible. I have tried using and not using EncodeBase64. As far as I can tell, I am getting the string, storing it in the database, and later, getting it back, and I can't get a folderitem from it. Any ideas?
_______________________________________________
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>

<Prev in Thread] Current Thread [Next in Thread>