Re: [sqlite] Saving tables from Visual Studio designer

2012-02-03 Thread Joe Mistachkin
I'll look into this issue later today; however, the Visual Studio Designer components are not feature complete and this functionality may simply be missing. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080

Re: [sqlite] Saving tables

2006-11-29 Thread John Stanton
Christian Smith wrote: John Stanton uttered: If you use an extension greater than 3 chars you violate rules for some existing file systems and reduce portability. You can also make it difficult to parse the extension when it is used to type the file. An extension of arbitray length shoul

Re: [sqlite] Saving tables

2006-11-29 Thread Christian Smith
John Stanton uttered: If you use an extension greater than 3 chars you violate rules for some existing file systems and reduce portability. You can also make it difficult to parse the extension when it is used to type the file. An extension of arbitray length should be just as easy to parse

Re: [sqlite] Saving tables

2006-11-28 Thread John Stanton
Extensions are used by such systems as MIME to indicate file type. Fitting into those conventions is better than not doing so for some capricious reason. Name extensions are easier to handle than the traditional Unix "magic" method. Trevor Talbot wrote: On 11/28/06, John Stanton <[EMAIL PRO

Re: [sqlite] OT: filenaming conventions -- was: Re: [sqlite] Saving tables

2006-11-28 Thread Trevor Talbot
On 11/28/06, P Kishor <[EMAIL PROTECTED]> wrote: On 11/28/06, Craig Morrison <[EMAIL PROTECTED]> wrote: > Just a bit of warning, as it has bitten a few in the bum, about >3 > character extensions under the NT+ variants.. They can and will bite > you, for instance: > > dir *.sql > > Will list n

Re: [sqlite] Saving tables

2006-11-28 Thread Trevor Talbot
On 11/28/06, John Stanton <[EMAIL PROTECTED]> wrote: If you use an extension greater than 3 chars you violate rules for some existing file systems and reduce portability. You can also make it difficult to parse the extension when it is used to type the file. The journal filename violates most

Re: [sqlite] Saving tables

2006-11-28 Thread Trevor Talbot
On 11/28/06, sebcity <[EMAIL PROTECTED]> wrote: Where do you execute the SQLite program from? Is it just the sqlite.exe file? You need to start from your OS command prompt; run "sqlite3 database.filename" from there. Do not double-click sqlite3.exe. --

Re: [sqlite] OT: filenaming conventions -- was: Re: [sqlite] Saving tables

2006-11-28 Thread Will Leshner
On 11/28/06, P Kishor <[EMAIL PROTECTED]> wrote: Whether or not this is true, the fact is, in Windows (and even in Mac OS X, while using the Finder), three letter extensions mean something special. By making it '.sqlite' (or '.bobbitybob', for that matter), I hope to make my db immune from all t

Re: [sqlite] OT: filenaming conventions -- was: Re: [sqlite] Saving tables

2006-11-28 Thread P Kishor
On 11/28/06, Craig Morrison <[EMAIL PROTECTED]> wrote: P Kishor wrote: > On 11/28/06, John Stanton <[EMAIL PROTECTED]> wrote: >> If you use an extension greater than 3 chars you violate rules for some >> existing file systems and reduce portability. You can also make it >> difficult to parse the

Re: [sqlite] Saving tables

2006-11-28 Thread John Stanton
;> >> RB Smissaert wrote: >> >>sqlite3 mydatabase.db3 >> > >> > >> > I always use the extension .db >> > What is the difference between db3 and db or maybe db2 etc.? >> > >> > RBS >> > >> > >> > -----Orig

[sqlite] OT: filenaming conventions -- was: Re: [sqlite] Saving tables

2006-11-28 Thread Craig Morrison
P Kishor wrote: On 11/28/06, John Stanton <[EMAIL PROTECTED]> wrote: If you use an extension greater than 3 chars you violate rules for some existing file systems and reduce portability. You can also make it difficult to parse the extension when it is used to type the file. we are going a bit

Re: [sqlite] Saving tables

2006-11-28 Thread P Kishor
> >> > RBS >> > >> > >> > -----Original Message- >> > From: Kees Nuyt [mailto:[EMAIL PROTECTED] >> > Sent: 27 November 2006 22:49 >> > To: sqlite-users@sqlite.org >> > Subject: Re: [sqlite] Saving tables >> >

Re: [sqlite] Saving tables

2006-11-28 Thread John Stanton
EMAIL PROTECTED] > Sent: 27 November 2006 22:49 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Saving tables > > 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 >>m

Re: [sqlite] Saving tables

2006-11-28 Thread sebcity
lways use the extension .db >> What is the difference between db3 and db or maybe db2 etc.? >> >> RBS >> >> >> -Original Message- >> From: Kees Nuyt [mailto:[EMAIL PROTECTED] >> Sent: 27 November 2006 22:49 >> To: sqlite-users@sqlite

Re: [sqlite] Saving tables

2006-11-28 Thread sebcity
ion .db >> > What is the difference between db3 and db or maybe db2 etc.? >> > >> > RBS >> > >> > >> > -Original Message- >> > From: Kees Nuyt [mailto:[EMAIL PROTECTED] >> > Sent: 27 November 2006 22:49 >> > To:

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 P Kishor
22:49 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Saving tables > > 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 : "sqlit

Re: [sqlite] Saving tables

2006-11-27 Thread John Stanton
] Sent: 27 November 2006 22:49 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Saving tables 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" like y

RE: [sqlite] Saving tables

2006-11-27 Thread epankoke
age- > From: Kees Nuyt [mailto:[EMAIL PROTECTED] > Sent: 27 November 2006 22:49 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Saving tables > > On Mon, 27 Nov 2006 12:43:24 -0800 (PST), you wrote: > > > > >I typed exactly what you typed there and i get >

RE: [sqlite] Saving tables

2006-11-27 Thread RB Smissaert
> sqlite3 mydatabase.db3 I always use the extension .db What is the difference between db3 and db or maybe db2 etc.? RBS -Original Message- From: Kees Nuyt [mailto:[EMAIL PROTECTED] Sent: 27 November 2006 22:49 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Saving tables On

RE: [sqlite] Saving tables

2006-11-27 Thread RB Smissaert
there. Must admit it is confusing. RBS -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 27 November 2006 21:44 To: sqlite-users@sqlite.org Subject: RE: [sqlite] Saving tables It depends on how the wrapper was written. If it is a C wrapper with the SQLite

Re: [sqlite] Saving tables

2006-11-27 Thread Kees Nuyt
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" like yours If you don't include a database name after the sqlite3 command, sqlite uses the "memory" database

Re: [sqlite] Saving tables

2006-11-27 Thread Isaac Raway
every x.x.y release of SQLite is a crucial upgrade). You could write to the author of your VB dll, buy her a beer or something. > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of P Kishor > Sent: 27 November 2006 20:59 > To: sqlite-users@

RE: [sqlite] Saving tables

2006-11-27 Thread epankoke
-- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of P Kishor > Sent: 27 November 2006 20:59 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Saving tables > > SQLite is the C library that does all the db magic. You have to > somehow get to that library,

Re: [sqlite] Saving tables

2006-11-27 Thread P Kishor
] On Behalf Of P Kishor Sent: 27 November 2006 20:59 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Saving tables SQLite is the C library that does all the db magic. You have to somehow get to that library, which you can do from a program written in a variety of different languages, even GUI pr

RE: [sqlite] Saving tables

2006-11-27 Thread RB Smissaert
t: 27 November 2006 20:59 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Saving tables SQLite is the C library that does all the db magic. You have to somehow get to that library, which you can do from a program written in a variety of different languages, even GUI programs, or, from another confus

Re: [sqlite] Saving tables

2006-11-27 Thread epankoke
Can you describe in more detail the process you're trying to use to do this? -- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ -- Original message -- From: sebcity <[EMAIL PROTECTED]> > > Nope, how would i do that? > >

Re: [sqlite] Saving tables

2006-11-27 Thread P Kishor
SQLite is the C library that does all the db magic. You have to somehow get to that library, which you can do from a program written in a variety of different languages, even GUI programs, or, from another confusingly similar named program called sqlite or sqlite shell. Since the jump from version

Re: [sqlite] Saving tables

2006-11-27 Thread John Stanton
If you are using Sqlite3 to access the DB you would -0 sqlite3 harry.db3 //Creates a database called harry.db3 enter some SQL to create a table and populate it exit To retrieve your data sqlite3 harry.db3//Opens DB harry.db3 enter some SQL e.g. SELECT * FROM

Re: [sqlite] Saving tables

2006-11-27 Thread sebcity
Nope, how would i do that? Eric Pankoke wrote: > > Did you open the database when you launched SQLite again? Sorry if this > is a stupid question, but I've never used SQLite from a command line or > the shell. > > -- > Eric Pankoke > Founder / Lead Developer > Point Of Light Software > http:/

Re: [sqlite] Saving tables

2006-11-27 Thread sebcity
I typed exactly what you typed there and i get SQL error: no such table: bar my command window doesnt have : "sqlite3 foo.sqlite" like yours P Kishor-2 wrote: > >>sqlite3 foo.sqlite > SQLite version 3.3.7 > Enter ".help" for instructions > sqlite> CREATE TABLE bar (a, b); > sqlite> INSERT I

Re: [sqlite] Saving tables

2006-11-27 Thread epankoke
Did you open the database when you launched SQLite again? Sorry if this is a stupid question, but I've never used SQLite from a command line or the shell. -- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ -- Original message --

Re: [sqlite] Saving tables

2006-11-27 Thread P Kishor
sqlite3 foo.sqlite SQLite version 3.3.7 Enter ".help" for instructions sqlite> 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 mp

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 you save them >> so they are per