On Jul 31, 2005, at 7:05 AM, Thom McGrath wrote:
• Despite the documentation
Which is a duplicate of the REALDatabase documentation and incorrect...
the "_rowid" column does not really exist.
It's called RowID and only created if you don't create a primary key.
• 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.
Create an empty database? How about CreateDatabaseFile?
• I have yet to be able to remove/modify columns in a table that's
already been saved. This really hurts.
You can, it's just a PITA to do it because you have to create
temporary tables and copy everything over in some cases. Not that
it's particularly hard, just annoying.
http://www.sqlite.org/lang.html
There will probably be more. How does anybody use this?
Very very well. It's freaking fast and stable and the most popular
single-user database around, most likely (SQLite3 that is).
Seth Willits
----------------------------------------------------------
Freak Software - http://www.freaksw.com/
ResExcellence - http://www.resexcellence.com/realbasic/
----------------------------------------------------------
_______________________________________________
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>
|