Re: [sqlite] using tcl/tk and sqlite

In addition to what D.R. Hipp said, you are also creating and closing your db before you get the chance to enter any data, what you really need is to create a procedure to (1) open db (2) enter data and (3) close db every time the "execute" button is pressed. Below is a complete working example

RE: AW: [sqlite] VB6 question

Steve, I works very similar to ADO. Except no Data Control Ray Steve O'Hara <[EMAIL PROTECTED]> wrote: How does a C++ wrapper help someone using VB6? Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] rg]On Behalf Of RAY BORROR Sent: 29 July 2005 05:22 To:

Re: [sqlite] Segmentation fault on large selects

Am 01.08.2005 um 21:41 schrieb Kervin L. Pierre: scunacc wrote: I have built with debugging on, and can't do anything with the core dump: dbx Type 'help' for help. enter object file name (default is `a.out', ^D to exit): sqlite3 reading symbolic information ... [using memory image in

Re: [sqlite] Segmentation fault on large selects

scunacc wrote: I have built with debugging on, and can't do anything with the core dump: dbx Type 'help' for help. enter object file name (default is `a.out', ^D to exit): sqlite3 reading symbolic information ... [using memory image in core] Illegal instruction (reserved addressing fault)

[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

Re: [sqlite] Segmentation fault on large selects

On 7/31/05, scunacc <[EMAIL PROTECTED]> wrote: > Dear all, > > SQLite is wonderful. Thank you for this piece of software. > > I have a problem however with large tables > 1M rows. Are you running out of memory?

Re: [sqlite] Data/time storing?

Henry Miller wrote: On 8/1/2005 at 08:41 Puneet Kishor wrote: I am curious about this as well... not about the various functions, but what is, if at all, a better way to store the values -- as '-MM-DD HH:MM:SS' strings (are they not stored internally as just strings?) or as unixepoch

Re: [sqlite] Data/time storing?

On 8/1/2005 at 08:41 Puneet Kishor wrote: >I am curious about this as well... not about the various functions, but >what is, if at all, a better way to store the values -- as '-MM-DD >HH:MM:SS' strings (are they not stored internally as just strings?) or >as unixepoch time (which would

[sqlite] assertion in balance_nonroot

We get a strange assertion in the sqlite3 code in our app which is multithreaded and heavily uses sqlite. The assertion we get is from within balance_nonroot in btree.c, line 4085: assert( cntNew[0]>0 ); We use separate database connections from each thread (actually, more likely, even

Re: [sqlite] Data/time storing?

On Aug 1, 2005, at 7:57 AM, Griggs, Donald wrote: Re: Wonder what the best way is to store a date (and time). Hello Edwin, If you haven't already, you'll want to read about the sqlite date/time functions at: http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions I am curious

RE: [sqlite] Data/time storing?

Re: Wonder what the best way is to store a date (and time). Hello Edwin, If you haven't already, you'll want to read about the sqlite date/time functions at: http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions Donald Griggs Opinions are not necessarily those of Misys

[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.