[sqlite] =?windows-1252?Q?Upgrading_version_2_databases__to_v?= =?windows-1252?Q?ersion_3_databases_-_what_is_meant_by_=93?= =?windows-1252?Q?have_ready_the_command-line_shells_for_both?= =?windows-1252?Q?_version_2=2E8_and_3=2E0=2E_=22?=

[Steve Frierdich]

Can anyone give me a step-by-step instruction on how to update databases 
to a version 3 database sqlite version 3 can be used? I referenced the 
website http://www.sqlite.org/version3.html ,as  indicated by Tito 
Ciuro,  but when I ran the sqlite.exe program from a command prompt 
with the parameters as specified from the  website, it failed:



C:\SQLITE>sqlite 33.db  .dump | sqlite3 new.db
'sqlite3' is not recognized as an internal or external command,
operable program or batch file.

I am not  sure what is meant by “have ready the command-line shells for 
both version 2.8 and 3.0. “.


Thanks
Steve Frierdich
Tito Ciuro wrote:
On Oct 7, 2004, at 16:00, Steve Frierdich wrote:
The same databases that are recognized and work in Sqlite version 
2.8.15 are not recognized in Sqlite version 3.0.7.  When the sqlite 
function sqlite3_get_table is called using version 3.0.7 the result 
is 26 which is:

File opened that is not a database file
When the same function is used in version 2.8.15 the result is 0 
which is:
SQLITE_OK

Check: http://www.sqlite.org/version3.html
The section is "New File Format".
-- Tito