Re: [sqlite] newbie question about laying out a simple database for bookings

2008-04-10 Thread sqlfan
Dennis Cote wrote: > > sqlfan wrote: >> I'm booking five resources, and right now I just use an excel sheet with >> all >> the dates in the first column (1/1/2000, 2/1/2000 ..., and the next five >> columns are the five resources. When I book one, I just scr

Re: [sqlite] newbie question about laying out a simple database for bookings

2008-04-07 Thread sqlfan
rive the other views from? Thank you! P Kishor-3 wrote: > > On 4/7/08, sqlfan <[EMAIL PROTECTED]> wrote: >> >> I'm booking five resources, and right now I just use an excel sheet with >> all >> the dates in the first column (1/1/2000, 2/1/2000 ..., and the ne

Re: [sqlite] What is the standard way to store dates and do operations with dates please?

2008-04-05 Thread sqlfan
I mentioned, right? Thank you. Dennis Cote-2 wrote: > > sqlfan wrote: >> I'm very new to sqlite but I notice there is no way to mark a column as >> containing dates... What is the standard way to do operations with dates, >> please, and to store dates? Should I try the

[sqlite] What is the standard way to store dates and do operations with dates please?

2008-04-05 Thread sqlfan
I'm very new to sqlite but I notice there is no way to mark a column as containing dates... What is the standard way to do operations with dates, please, and to store dates? Should I try the format 20080405 and do my own calculations using my language's standard library? (I'm using Python) or

[sqlite] wxgrid fed with sqlite

2008-01-13 Thread sqlfan
has anyone fed an editable wxgrid with sqlite? -- View this message in context: http://www.nabble.com/wxgrid-fed-with-sqlite-tp14790059p14790059.html Sent from the SQLite mailing list archive at Nabble.com. - To

Re: [sqlite] free excel-like COLORFUL gui for sqlite

2008-01-08 Thread sqlfan
Let me be more clear. There's very little data, and I want to help my client be able to expand his business, so the first step is automating what he's been doing by hand. I can get the excel data into sqlite no problem -- and wish to do so in order to START doing automated stuff with the data

[sqlite] free excel-like COLORFUL gui for sqlite

2008-01-08 Thread sqlfan
I have a client who's using a colorful excel sheet as a database. It's colorful, well-structured, and a joy to use. He has no code working on the data though -- it's just used for holding data, like a ledger book! My question is how I can put his information into a sqlite database but give him