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

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

2004-06-03 Thread Xuer
is there a browseable list of supported functions such as date,time,datetime...etc? new to sqlite, thx in adv.:) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

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

2004-06-03 Thread Gerard Samuel
On Thursday 03 June 2004 03:32 am, Xuer wrote: > is there a browseable list of supported functions such as > date,time,datetime...etc? > > new to sqlite, thx in adv.:) > http://sqlite.org/ - To unsubscribe, e-mail: [EMAIL PROTECT

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 100k

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: [EMA

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 here

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 sq

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, surn

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

2004-06-03 Thread jim mcnamara
>>IF you are still a student, have you checked out "Educational Pricing" for software at your school's bookstore? fred, I work part-time in an electronics department at a mass retailer. I better not be dishonest and buy academic software. I will look at python free or cheap tools and activestate

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

2004-06-03 Thread Darren Duncan
At 2:44 PM -0400 6/3/04, jim mcnamara wrote: I work part-time in an electronics department at a mass retailer. I better not be dishonest and buy academic software. I will look at python free or cheap tools and activestate unless I run across any other ideas. FYI, lots of students work part time to

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

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

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 som

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] 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 cour

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

2004-06-03 Thread jim mcnamara
http://www.polsoftware.com/> http://www.polsoftware.com/ hi eric- thank you for the ideas. i will have fun picking out software used to design more software. i already am investigating sqlite for delphi on sourceforge to see if it works with delphi personal 7 edition. i have two questions post