Personally, I have had so much succcess with the REALSQLDatabase that
I am actually doing one of my (simpler) professional projects in
RB2005 because of the database alone.
First of all, the "_rowid" field from the REALDatabase still exists,
but the name was changed. Now, it's called "rowid". Also, don't
forget that you have to explicitly ask for the rowid field it you
want it in a recordset.
Take a quick look at http://www.sqlite.org/ . There's some important
information about what you can and can't do, and how to do things.
Also, about removing and editing fields... I'm pretty sure that you
can't do that in an REALSQLDatabase. On the other hand, why would
you need to on a regular basis? I would think that a database would
be most useful if the fields were static. Also, it's not that hard
to simply create a new table with the fields you want and copy the
records over.
HTH-
Andrew Keller
On Jul 31, 2005, at 10:05 AM, Thom McGrath wrote:
• Despite the documentation, the "_rowid" column does not really
exist. That's minor, I should be able to create my own column.
Here's hoping.
• GetSchemaData and ReplaceSchemaData also do not exist. Did
anybody read that documentation, or just do a Find/Replace? How do
I create new empty databases without this functionality?
Considering the lack of documentation, I'm not sure what SQL I can
use to do so.
• I have yet to be able to remove/modify columns in a table that's
already been saved. This really hurts.
_______________________________________________
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>
|