RE: [sqlite] sorry for the confusion re: academic software

2004-06-03 Thread Eric Pankoke
I'm sorry if this isn't really in line with the current thread, because I've only been reading bits and pieces. If you just want Delphi, have you checked Borland's site lately? They used to give away the personal version of Delphi, as long as you didn't write anything commercial with it. Of

Re: [sqlite] getpid() and linux threads in sqlite

2004-06-03 Thread ben . carlyle
Hello, "Mrs. Brisby" <[EMAIL PROTECTED]> 03/06/2004 01:37 PM To: Daniel K <[EMAIL PROTECTED]> cc: [EMAIL PROTECTED] Subject:Re: [sqlite] getpid() and linux threads in sqlite > On Wed, 2004-06-02 at 01:53, Daniel K wrote: > > The getpid() call on my

Re: [sqlite] Sqlite Secure backup

2004-06-03 Thread ben . carlyle
David Costa <[EMAIL PROTECTED]> 03/06/2004 09:26 AM To: [EMAIL PROTECTED] cc: Subject:[sqlite] Sqlite Secure backup > I am in the process of writing a PEAR package to handle Sqlite backups > (both local backups and remote backups) and I am looking for

[sqlite] sorry for the confusion re: academic software

2004-06-03 Thread jim mcnamara
hi- i was recently a student but not any longer. I should have grabbed an academic copy of delphi on my way out the door when i graduated from college last year (poor planning...i am kicking myself). I am disabled and work part time and am on ssdi. I confused everyone when I mentioned the

Re: [sqlite] help with evaluation of sqlite db tool

2004-06-03 Thread Mitchell Vincent
Jim, all you need to be careful of is the license that accompanies the academic version. Most prevent the author from using the software for "commercial" purposes (that is generally defined within the license). If you are enrolled in school then you are a student so it wouldn't be dishonest to

Re: [sqlite] Triggers & last_inserted_id

2004-06-03 Thread Darren Duncan
At 10:53 AM +0200 6/3/04, Pix wrote: No... I need the id of the row inserted by the TRIGGER... the trigger operations should be atomic, so no other db activity should be a problem... I still don't think you need last_insert_id. Try this in your trigger: INSERT INTO OldContacts (ID, name,

RE: [sqlite] help with evaluation of sqlite db tool

2004-06-03 Thread Fred Williams
IF you are still a student, have you checked out "Educational Pricing" for software at your school's bookstore? > -Original Message- > From: jim mcnamara [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 03, 2004 2:32 AM > To: [EMAIL PROTECTED] > Subject: [sqlite] help with evaluation of

Re: [sqlite] Sqlite Secure backup

2004-06-03 Thread David Costa
On Jun 3, 2004, at 2:17 AM, Darren Duncan wrote: At 2:04 AM +0200 6/3/04, David Costa wrote: so in this case you just check if a file .journal exist and if it does you keep that file right ? Yes. But check the sqlite.org website documentation to make sure that is the correct file name. from

Re: [sqlite] is there a list of built-in functions?

2004-06-03 Thread Kurt Welgehausen
> is there a browseable list of supported functions such as > date,time,datetime...etc? http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

RE: [sqlite] help with evaluation of sqlite db tool

2004-06-03 Thread jim mcnamara
-Original Message- From: jim mcnamara [mailto:[EMAIL PROTECTED] Sent: Thursday, June 03, 2004 3:32 AM To: [EMAIL PROTECTED] Subject: [sqlite] help with evaluation of sqlite db tool hi- >>one final note. i used visualtcl and love it but the code for the project is already around

[sqlite] help with evaluation of sqlite db tool

2004-06-03 Thread jim mcnamara
hi- i worked on a sqlite db tool a couple of months ago. i finished the project because i didnt know what direction to go from there. i'd like to expand the project and make it bigger with more features. i was wondering if someone could glance at it and give me some ideas for the basic features