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
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
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
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
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
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
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.
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
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
>> 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
>> >
>> >
>> > -Original
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
>> > 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
>> >
>&
lto:[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
>>
gt; 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
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:
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
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
]
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"
---
> 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
> >
> 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
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 code
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"
lease 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@sqlite.o
-
> 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, whic
f 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 programs, or
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 confusingly
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?
>
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
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
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
>
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
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
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
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
34 matches
Mail list logo
