Sorry, let me get this straight: WHAT syntax command do I use ?
sqlite> Make new database ? sqlite>contacts;
The problem there is no Contacts database created ? I would have to make a database first, before creating tables? please explain.....
Richard
Please not using any C or C++ programing ( using sqlite as stand alone app )
Ulrik Petersen <[EMAIL PROTECTED]> wrote:
R>ichard Nagle wrote:
Last login: Thu Feb 24 00:08:34 on ttyp1 Welcome to Darwin! fastmac:~ rn$ /Applications/SQLite/sqlite; exit SQLite version 2.8.13 Enter ".help" for instructions sqlite> .database 0 main 1 temp sqlite> create database contacts; # This is standard sql ? SQL error: near "database": syntax error sqlite>
So: at the command line: sqlite> what is the correct syntax command to create a NEW database, called Contacts???
T>here is no syntax command to do that. With the sqlite shell, you just give the name of the database on the command line. From within C, you explicitly open a connection to the database.
There is a command to attach a database (which is SQLite-specific). However, from the docs it seems that this is: a) Not what you want, and b) Only for attaching preexisting databases.
http://www.sqlite.org/lang_attach.html
H>TH
Ulrik Petersen