I haven't tested REALSQLDatabase yet, but sqlite3 has a rowid column.
And you can get the schema of a table. I have just tested it again in
the small shell that comes with the library:
dda> sqlite3 test.db
sqlite> select rowid from agent;
1
2
3
sqlite> .schema AGENT
CREATE TABLE AGENT (
AGENT_ID mediumint(2) NOT NULL default '0',
[...]
);
sqlite>
So the functionalities are in the library. The sqlite seems to reject
DESCRIBE tableName; so they do it in another way. Sorry to be of
little help...
--
dda
On 7/31/05, Thom McGrath <lists at thezaz dot com> wrote:
> ok, so REALDatabase is dead. Wonderful. REALSQLDatabase is barely
> alive, so do I now have to purchase something that *works*?
>
> Here are my issues:
>
> • 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.
>
> There will probably be more. How does anybody use this?
>
> --
> Thom McGrath
_______________________________________________
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>
|