SQLite

[Bruce]

Where does the Data Base store any new information I add to it???

[Bruce]

I burned the template to a CD and ran it. I then got this:



What does this mean?

[rhosk]

Is the database on CD??

[Corey]

Yes it sounds like Ron is one the right path here. I'm not too familiar with this plug-in yet but that's probably what happened from the look of it. If it's trying to access the CD-ROM which is read-only, that's the error you'd get.

Corey Milner
Creative Director, Indigo Rose Software

[Bruce]

Ok... does this mean that this plugin can not be used on a CD?
How does this plugin get used???????????????????????????

[Corey]

Yep it can be used, but obviously the idea is to use it to manipulate data on the hard drive. Let me get up to speed on this one Bruce then I'll offer some advice. Unfortunately I just haven't had time to sit down and build some stuff with these yet.

Corey Milner
Creative Director, Indigo Rose Software

[sferguson]

As I understand it, you can "unpack" the database to memory, or to client machine's HD. I had a similar question a few weeks ago, Brett commented on this, but I can't recall where the post was... So, in theory the CD-ROM solution is do-able. It's probably something in the "set-up" on the dev side.

[Corey]

Yes I remember that post. You're right on the money there I think. I can hardly wait to build some stuff with this thing, I've been dying to get at it for weeks.

Corey Milner
Creative Director, Indigo Rose Software

[rhosk]

I'm not familiar with the plug-in, but I would also assume that the database would unpack to the hard drive (or maybe upload or exist on a server?) w/ an attribute change. Can't wait to play with it either!

[Lorne]

(ahem) This would be a good time to RTFM.

The first step in working with a database is to open a database file with SQLite.Open(). This action takes a single parameter: the filename of the database that you want to open.

As it says in the documentation for this action:

Opens a SQLite database. If the database does not exist, it is created.

For example:

-- open a database file in the user's temp folder
handle = SQLite.Open(_TempFolder .. "\\MyDatabase.db");

That action opens a MyDatabase.db file in the user's temp folder. If the file doesn't exist yet, it gets created first.

The action returns a database handle, which is used by the other SQLite actions. For example, if you wanted to close that database, you would use:

SQLite.Close(handle);

As you can see, you can open/create a database file anywhere you want. The sample project opens its database file from _SourceFolder by default. If you want to burn it to a CD, change the SQLite.Open() actions to open the database file somewhere else.

[Lorne]

This would be a good time to RTFM.

The first step in working with a database is to open a database file with SQLite.Open(). This action takes a single parameter: the filename of the database that you want to open.

As it says in the documentation for this action:

Opens a SQLite database. If the database does not exist, it is created.

For example:

-- open a database file in the user's temp folder
handle = SQLite.Open(_TempFolder .. "\\MyDatabase.db");

That action opens a MyDatabase.db file in the user's temp folder. If the file doesn't exist yet, it gets created first.

The action returns a database handle, which is used by the other SQLite actions. For example, if you wanted to close that database, you would use:

SQLite.Close(handle);

As you can see, you can open/create a database file anywhere you want. The sample project opens its database file from _SourceFolder by default. If you want to burn it to a CD, change the SQLite.Open() actions to open the database file somewhere else.

[Bruce]

Sorry Lorne, I did read it... :( I was so jazzed to get that I over read it!