Re: [sqlite] C++ SQLite

2006-11-28 Thread sebcity
Time constraints Craig Morrison-2 wrote: > > sebcity wrote: >> Thanks, Could you supply an example? > > I'm not going to be as nice as everyone else, go here: > > http://www.sqlite.org/cvstrac/wiki > > Do some research and then come back instead of

Re: [sqlite] C++ SQLite

2006-11-28 Thread sebcity
Thanks, Could you supply an example? Clay Dowling wrote: > > sebcity wrote: >> How would one go about using c++ (Visual Studio.NET) to call and display >> SQLite tables. C++ wrappers? > > You could just use the API directly. Myself, I've put a wrapper around >

[sqlite] C++ SQLite

2006-11-28 Thread sebcity
How would one go about using c++ (Visual Studio.NET) to call and display SQLite tables. C++ wrappers? -- View this message in context: http://www.nabble.com/C%2B%2B-SQLite-tf2717819.html#a7577607 Sent from the SQLite mailing list archive at Nabble.com. -

Re: [sqlite] Saving tables

2006-11-28 Thread sebcity
Where do you execute the SQLite program from? Is it just the sqlite.exe file? John Stanton wrote: > > Use anything you like. Version 3 Sqlite is easy to recognize if you use > .db3. > > RB Smissaert wrote: >>>sqlite3 mydatabase.db3 >> >> >> I always use the extension .db >> What is the d

Re: [sqlite] Saving tables

2006-11-28 Thread sebcity
Where do you execute the SQLite program from? Is it just the sqlite.exe file? P Kishor-2 wrote: > > I like using .sqlite as the extension (or .sqlite3). That way no > Windows program will want to mess with it... usually 3 letter > extensions are grist for the mill > > On 11/27/06, John Stant

Re: [sqlite] Saving tables

2006-11-28 Thread sebcity
Where do you execute the SQLite program from? Is it just the sqlite.exe file? Kees Nuyt wrote: > > On Mon, 27 Nov 2006 12:43:24 -0800 (PST), you wrote: > >> >>I typed exactly what you typed there and i get >>SQL error: no such table: bar >>my command window doesnt have : "sqlite3 foo.sqlite"

Re: [sqlite] Saving tables

2006-11-27 Thread sebcity
; Point Of Light Software > http://www.polsoftware.com/ > > -- Original message -- > From: sebcity <[EMAIL PROTECTED]> >> >> I created a table. >> I populated the table. >> I exited SQLite. >> Started

Re: [sqlite] Saving tables

2006-11-27 Thread sebcity
CREATE TABLE bar (a, b); > sqlite> INSERT INTO bar (a, b) VALUES (1, 'my mp3'); > sqlite> .quit > > .. time passes.. > >>sqlite3 foo.sqlite > SQLite version 3.3.7 > Enter ".help" for instructions > sqlite> SELECT * FROM bar; > 1|my

[sqlite] RE: Re: Saving tables

2006-11-27 Thread sebcity
Sorry but could you show me the exact code to create a table that will be permenently there? Griggs, Donald wrote: > > Regarding: > sebcity <[EMAIL PROTECTED]> wrote: >> ... After you create your tables how do you save them so >> they are permenently there? >

[sqlite] RE: Re: Saving tables

2006-11-27 Thread sebcity
Thanks Griggs, Donald wrote: > > Regarding: > sebcity <[EMAIL PROTECTED]> wrote: >> ... After you create your tables how do you save them so >> they are permenently there? > > And Igor T's reply: > They are "permanently there" from

Re: [sqlite] Saving tables

2006-11-27 Thread sebcity
I created a table. I populated the table. I exited SQLite. Started SQLIte again. Typed "select * from ". ANd it tells me no such table exists?? Igor Tandetnik wrote: > > sebcity <[EMAIL PROTECTED]> wrote: >> Im new to SQLite, After you create your tables how do

Re: [sqlite] Music Files

2006-11-27 Thread sebcity
Ok,so just save them as BLOB files? Igor Tandetnik wrote: > > sebcity <[EMAIL PROTECTED]> wrote: >> Is it possible to store mp3 files in a SSQLite database? would they >> be able to be played from the database? How would you save them? > > SQLite does not know

[sqlite] Music Files

2006-11-27 Thread sebcity
Is it possible to store mp3 files in a SSQLite database? would they be able to be played from the database? How would you save them? -- View this message in context: http://www.nabble.com/Music-Files-tf2714035.html#a7566722 Sent from the SQLite mailing list archive at Nabble.com. -

[sqlite] Saving tables

2006-11-27 Thread sebcity
Hi, Im new to SQLite, After you create your tables how do you save them so they are permenently there? It might be a dumb question but i cant find the answer anwhere?! -- View this message in context: http://www.nabble.com/Saving-tables-tf2714011.html#a7566646 Sent from the SQLite mailing list a