Re: [sqlite] Re: Loss of table feature.. ever?

Yes but imo a rather daunting task. I better leave it to the author of sqlite :) - Original Message - From: "Igor Tandetnik" <[EMAIL PROTECTED]> To: "SQLite" <sqlite-users@sqlite.org> Sent: Tuesday, December 12, 2006 8:01 PM Subject: [sqlite] Re: Loss o

[sqlite] Loss of table feature.. ever?

Hello people, i really need to ask this thing again. My visual design tool has a custom written datacontrol for sqlite. This means MoveFirst, Previous, next and movelast buttons. This control depends heavily on the gettable() sqlite functions. While i already understand that these functions are

[sqlite] Icon for sqlite?

My tool needs an sqlite icon, is there one? I see a logo only. :)

Re: [sqlite] v3.2.1 and current differences!

Question remains if it isn't better to go to a new major version on such changes. Forward compatibility is assumed by users imo. - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Tuesday, June 27, 2006 1:08 PM Subject: Re: [sqlite] v3.2.1 and current

Re: [sqlite] v3.2.1 and current differences!

TED]> To: <sqlite-users@sqlite.org> Sent: Monday, June 26, 2006 8:20 PM Subject: Re: [sqlite] v3.2.1 and current differences! "Edwin Knoppert" <[EMAIL PROTECTED]> wrote: Just wanted to warn you i can not read a newly created table created with the current release and opening it

Re: [sqlite] v3.2.1 and current differences!

o: <sqlite-users@sqlite.org> Sent: Monday, June 26, 2006 8:16 PM Subject: Re: [sqlite] v3.2.1 and current differences! On Mon, 26 Jun 2006 20:03:35 +0200, Edwin Knoppert wrote: Just wanted to warn you i can not read a newly created table created with the current release and opening it in

[sqlite] v3.2.1 and current differences!

Just wanted to warn you i can not read a newly created table created with the current release and opening it in v3.2.1 (afaik) Sorry, i removed the older dll, i overwrote it with the latest and read the table instantly. Before i had 0 tables shown. A simple query was used: CREATE TABLE

Re: [sqlite] how can I import CSV file into SQLite quickly

PBDBMS on www.hellobasic.com All through ADO.. - Original Message - From: "Cariotoglou Mike" <[EMAIL PROTECTED]> To: Sent: Wednesday, December 07, 2005 9:23 AM Subject: RE: [sqlite] how can I import CSV file into SQLite quickly sqlite3Explorer does that

Re: [sqlite] Re: converting a mysql database

If the mysql db is reachable through dsn (ado-providerstring) you can use my pbsdbms tool to import tables. http://www.hellobasic.com - Original Message - From: "Arjen Markus" <[EMAIL PROTECTED]> To: Sent: Monday, November 07, 2005 8:43 AM Subject: Re:

Re: [sqlite] Tool to load a database and see all tables and fields.

On my site i have a tool, www.hellobasic.com - Original Message - From: "Eno Thereska" <[EMAIL PROTECTED]> To: Sent: Wednesday, September 28, 2005 4:36 PM Subject: Re: [sqlite] Tool to load a database and see all tables and fields. What about

Re: [sqlite] Storing RTF text in a field

Simple convert it to 2byte hex "0AFF00..." etcc. So the update query should use X'your hex data here' - Original Message - From: "Gaurav Patole" <[EMAIL PROTECTED]> To: Sent: Tuesday, September 20, 2005 7:14 AM Subject: [sqlite] Storing RTF text in a field

Re: [sqlite] Duration of reading records seems longer when sortedas not.

I'm using 3.2.1 and have no index. Note that i'm not talking about the query itself but the data retrieval. - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: Sent: Thursday, August 25, 2005 2:59 PM Subject: Re: [sqlite] Duration of reading

[sqlite] Duration of reading records seems longer when sorted as not.

FYI: Duration of reading records seems longer when sorted as not. ~600 rec's in 500ms instead of 2400 (also ~500ms) I'm not talking about prepare but the data retrieval per record.

Re: [sqlite] Why can i open a textfile?

Maybe we should explain the term 'wrapper'. I'm using wrappers around the salite dll in my own code. But a wrapper might be seen over here as additional library (dll or so) others can use. A redistribute part, which i don't like. (Like the VB 'wrapper' dll) - Original Message - From:

Re: [sqlite] Why can i open a textfile?

, 2005 1:28 AM Subject: Re: [sqlite] Why can i open a textfile? On Tue, 2005-08-23 at 00:04 +0200, Edwin Knoppert wrote: All i meant is that sqlite is created by a c programmer, like my colleague he seems to forget there are different languages but he doesn't care. Actually, I'm a TCL prog

Re: [sqlite] Why can i open a textfile?

C++ sort of suggests doing this regardless Steve -Original Message- From: Edwin Knoppert [mailto:[EMAIL PROTECTED] Sent: Mon 22/08/2005 23:20 To: sqlite-users@sqlite.org Cc: Subject: Re: [sqlite] Why can i open a textfile? At the other hand, this is database stuff, what on ear

Re: [sqlite] Why can i open a textfile?

At the other hand, this is database stuff, what on earth would you encrypt in real life business databases. No one cares, except for a few purposes. (Now i done it :) ) Encrypting a header, like if any virus writer is busy with a tool like sqlite.. pfffttt. - Original Message -

Re: [sqlite] Why can i open a textfile?

t; <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, August 22, 2005 11:31 PM Subject: Re: [sqlite] Why can i open a textfile? Edwin Knoppert wrote: Hmm, but every known file format has an header. Sqlite has a string, not really a header as it seems. Sqli

Re: [sqlite] Why can i open a textfile?

Hmm, the latter might have sounded a bit harsh. It must be seen as reminder, no pointing finger or so :) - Original Message - From: "Edwin Knoppert" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, August 22, 2005 11:12 PM Subject: Re: [

Re: [sqlite] Why can i open a textfile?

Hmm, but every known file format has an header. Sqlite has a string, not really a header as it seems. Maybe for v4 to implement a real header (if not yet) A header doesn't need to be encrypted. (A bit for testing if it's encrypted might have it use as well) Sqlite seems to be created espec. for

Re: [sqlite] Why can i open a textfile?

Confirmed but open still opens the textfile, i wish it cancelled that as well. There is no use to an open textfile for sqlite. - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: Sent: Monday, August 22, 2005 5:54 PM Subject: Re: [sqlite]

Re: [sqlite] Why can i open a textfile?

open the database read only? Edwin Knoppert wrote: I haven't test on exactly 1kb file but larger and indeed an error is shown. May i stress again that the test should be during open() imo? And rather not using a 2nd function to examine the db.

Re: [sqlite] Why can i open a textfile?

can i open a textfile? On Sat, 2005-08-20 at 09:06 -0700, Will Leshner wrote: On Aug 20, 2005, at 1:25 AM, Edwin Knoppert wrote: > v3.2.1, i opened a textfile containing a simple list not related to > sqlite. > Was testing my error handler but it still opens it. > Do you mean

Re: [sqlite] Why can i open a textfile?

05 6:21 PM Subject: Re: [sqlite] Why can i open a textfile? On Sat, 2005-08-20 at 09:06 -0700, Will Leshner wrote: On Aug 20, 2005, at 1:25 AM, Edwin Knoppert wrote: > v3.2.1, i opened a textfile containing a simple list not related to > sqlite. > Was testing my error handler but it still open

Re: [sqlite] Why can i open a textfile?

On Sat, 2005-08-20 at 09:06 -0700, Will Leshner wrote: On Aug 20, 2005, at 1:25 AM, Edwin Knoppert wrote: > v3.2.1, i opened a textfile containing a simple list not related to > sqlite. > Was testing my error handler but it still opens it. > Do you mean you called sqlite3_open? I

Re: [sqlite] Why can i open a textfile?

ail. Thanks, - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Saturday, August 20, 2005 6:21 PM Subject: Re: [sqlite] Why can i open a textfile? On Sat, 2005-08-20 at 09:06 -0700, Will Leshner wrote: On Aug 20

[sqlite] PBSDBMS, sqlite database tool

On my site http://www.hellobasic.com/ (free downloads) you can find PBSDBMS, a DBMS for sqlite v3.07 and up. Does handle the main aspects for sqlite like tables, columns, views and a few others.. Also does import and export. Blob data having nul chars is supported. An extensive querybuilder.

Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote.

- From: "Andrew Brampton" <[EMAIL PROTECTED]> To: "Edwin Knoppert" <[EMAIL PROTECTED]> Sent: Tuesday, August 16, 2005 10:12 PM Subject: Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote. Hi again, ok I just tested Duplicate again and it did

Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote.

- Original Message - From: "Edwin Knoppert" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Tuesday, August 16, 2005 8:29 AM Subject: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote. I only need a list what i need to correct like critical

Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote.

Only Windows i'm affraid. (Virtual PC?) - Original Message - From: "Dr Gerard Hammond" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Cc: "Edwin Knoppert" <[EMAIL PROTECTED]> Sent: Tuesday, August 16, 2005 10:51 AM Subject: Re: [sqlite] I need

[sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote.

I only need a list what i need to correct like critical errors, not what to change like gui changes or similar. It's a freeware tool and not being released before it had a better test than i did. Mail me if you want to help. App consists from exe, hlp and sqlite3 dll. hope you'll look into

[sqlite] DB locked on prepare?

Is it me doing something wrong (again :) )? I have a transaction and renaming a table like table1 to let's say table1_tmp (whatever) I open table1_tmp using prepare. Right after that i create a table named table1, i get an error 6. Previously i used gettable instead of prepare and left it open

[sqlite] Data/time storing?

Wonder what the best way is to store a date (and time). At this time i use "mmdd" but is there a by sqlite recommended method? This aplies time as well, not sure what i'll use, prob HH:MM:SS. But then it lacks ms's.

Re: [sqlite] BLOB field returns as TEXT type

Oops, forgot to use X before the storage (grrr!) X'hexdata' sqlite3_column_text returns a pointer to binary data wich i can copy by obtaining the columndata size. BLOB type is now properly returned as well :) Thanks anyway. - Original Message - From: "Edwin Knoppert&quo

Re: [sqlite] BLOB field returns as TEXT type

al Message - From: "Edwin Knoppert" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Friday, July 29, 2005 3:39 PM Subject: [sqlite] BLOB field returns as TEXT type I'm expecting SQLITE_BLOB when using sqlite3_column_type() It keeps returning SQLITE_TEXT (3) whi

[sqlite] BLOB field returns as TEXT type

I'm expecting SQLITE_BLOB when using sqlite3_column_type() It keeps returning SQLITE_TEXT (3) while the field was created as BLOB. The text returned from sqlite3_column_text() is in hex notation. At this time i don't mind the wrong type nr as long i can distinguish the HEX blob data from

Re: [sqlite] Sorry, trivail question probably, chr(0) in blob.

esday, July 27, 2005 6:13 PM Subject: Re: [sqlite] Sorry, trivail question probably, chr(0) in blob. On Wed, 27 Jul 2005, Edwin Knoppert wrote: I reread the faq hundred times but i don't understand the \000 remark. For INSERT how can i embed BLOB data having single quote and chr(0) bytes? C

Re: [sqlite] Sorry, trivail question probably, chr(0) in blob.

in blob. On Wed, 27 Jul 2005, Edwin Knoppert wrote: I reread the faq hundred times but i don't understand the \000 remark. For INSERT how can i embed BLOB data having single quote and chr(0) bytes? Currently i replace all singlequotes with 2x single quotes and that works fine. The chr(0) byt

Re: [sqlite] Commit and Rollback

And i wish for a test if the transaction is already set or not, without using a callback. Even better, nested tranactions would be the best. :) - Original Message - From: "Marco Bambini" <[EMAIL PROTECTED]> To: Sent: Thursday, July 28, 2005 9:24 AM Subject:

Re: [sqlite] Sorry, trivail question probably, chr(0) in blob.

question probably, chr(0) in blob. in sqlite 3.x you can bind data to prepared statements, no escaping is required. On 7/27/05, Edwin Knoppert <[EMAIL PROTECTED]> wrote: I reread the faq hundred times but i don't understand the \000 remark. For INSERT how can i embed BLOB data having s

[sqlite] Sorry, trivail question probably, chr(0) in blob.

I reread the faq hundred times but i don't understand the \000 remark. For INSERT how can i embed BLOB data having single quote and chr(0) bytes? Currently i replace all singlequotes with 2x single quotes and that works fine. The chr(0) byte did not succeed. I'm using the dll and don't do any c

Re: [sqlite] I still think it's a bug, 0 rows, no fieldnames

API, that need "PRAGMA empty_result_callbacks = 1" to return the columns on empty result sets, but I haven't used that API for a long time. Regards, ~Nuno Lucas [25-07-2005 9:08, Edwin Knoppert escreveu] I might be mistaken but you should never expect row-0 for data. What i meant is that

Re: [sqlite] I still think it's a bug, 0 rows, no fieldnames

API, that need "PRAGMA empty_result_callbacks = 1" to return the columns on empty result sets, but I haven't used that API for a long time. Regards, ~Nuno Lucas [25-07-2005 9:08, Edwin Knoppert escreveu] I might be mistaken but you should never expect row-0 for data. What i meant is that

Re: [sqlite] I still think it's a bug, 0 rows, no fieldnames

M Subject: Re: [sqlite] I still think it's a bug, 0 rows, no fieldnames On 2005-07-24 at 16:11:26 [+0200], Edwin Knoppert <[EMAIL PROTECTED]> wrote: Why defending it? It's prob. a simple issue. Besides, why i want the names, why should a system need to parse a query? You approach this w

Re: [sqlite] I still think it's a bug, 0 rows, no fieldnames

: "Puneet Kishor" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Sunday, July 24, 2005 3:40 PM Subject: Re: [sqlite] I still think it's a bug, 0 rows, no fieldnames On Jul 24, 2005, at 6:52 AM, Edwin Knoppert wrote: I would recommend the SQLite engine keeps retu

[sqlite] I still think it's a bug, 0 rows, no fieldnames

I would recommend the SQLite engine keeps returning the 0-row having the fields from the result query (select) It does not seem to do that when there was no data returned. At the end my goal would be to enumerate the fieldnames + it's tablename. As far is i know, msaccess does this. Am i wrong?

Re: [sqlite] How to store ' ?

Gosh, sorry, just re-read the faq: INSERT INTO xyz VALUES('5 O''clock'); - Original Message - From: "Edwin Knoppert" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Tuesday, July 19, 2005 1:49 PM Subject: [sqlite] How to store ' ? If i read correct BL

[sqlite] How to store ' ?

If i read correct BLOB data can now handle chr(0) as well. But another issue i solved with access is the embedding of ' characters. I'm using single quotes for field data during INSERT. How can a field contain single quotes for data? Access allows to use BASIC code and let's you insert + Chr()

Re: [sqlite] My first post, a few wishes..

trouble obtaining the field types, but that will be another post. - Original Message - From: <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Cc: "Kiel W." <[EMAIL PROTECTED]> Sent: Thursday, July 07, 2005 3:35 PM Subject: Re: [sqlite] My first post, a fe

Re: [sqlite] My first post, a few wishes..

rs@sqlite.org> Sent: Thursday, July 07, 2005 2:52 PM Subject: Re: [sqlite] My first post, a few wishes.. On 7/7/05, Edwin Knoppert <[EMAIL PROTECTED]> wrote: 1) I wish for a better way to recreate a table's definition. The FAQ example is no good if you are unknown to it's fields. F

[sqlite] My first post, a few wishes..

1) I wish for a better way to recreate a table's definition. The FAQ example is no good if you are unknown to it's fields. For example, imy dbms obtains the create table query for the user, he might want to reset table name as add or remove fields. After that the copy as suggested in the FAQ