On Jul 31, 2005, at 8:05 AM, Thom McGrath 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.
It does BUT if you want it returned you have to specifically request it.
select * from table won't get it
but
select _rowid, * from table
should
• 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.
In code
The documentation for SQLite from SQLite.org should mostly apply.
• I have yet to be able to remove/modify columns in a table that's
already been saved. This really hurts.
In code you should be able to do
select * from <table> into <temporarytable>
drop table <table>
sql to create table with new columns
insert into table select * from temporarytable
drop table temporarytable
I don't believe there is any way from the IDE to achieve this
There will probably be more. How does anybody use this?
_______________________________________________
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>
|