[sqlite] blobs

2007-07-29 Thread Jim McNamara
hi- i never had to do serious import/export. if a blob happens to be a document like a microsoft word document i have trouble visualizing where the document goes when it gets exported from the sqlite table. i saw the maestro and data wizard with its blob export command. when i think of export

[sqlite] re: blobs

2007-07-29 Thread Jim McNamara
hi - after i got some sleep i searched for some examples. i have TCL. i am going to fool with these. http://preview.tinyurl.com/2mv5oz http://wiki.tcl.tk/775 dbcmd incrblob ?-readonly?? ?DB? TABLE COLUMN ROWID thanks, jim - Yahoo! oneSearch:

[sqlite] simple create db question

2005-08-22 Thread Jim McNamara
Hi- i always use to use tcl and created my db that way or used a tool with that menu option. now i'd like to use the command line to do it. i have a sqlite3.exe command utility in a directory named c:\aTest. i tried c:\aTest> "sqlite3 t1.db" and get an error message. what i am looking in to

[sqlite] re: create db question---command line

2005-08-22 Thread Jim McNamara
i just needed to use java -jar sqlite.jar t1.db now my computer is associating db files with sqlite because paradox is on the computer. great...oh well...that will be my next thing to fix if i can. thanks, later __ Yahoo! Mail Stay connected,

[sqlite] ok wrapper...what gives???

2005-08-23 Thread Jim McNamara
hi- i am trying to use christian werners wrapper with mixed results. it recognizes the db version but nothing prints out in the console of eclipse when i run this code. if anyone else is using it could you take a glance and see why i am not getting a console print out of the data? i get this

[sqlite] which db admin tool to use for the java wrapper??

2005-08-24 Thread Jim McNamara
hi- i tried dgSqlite admin tool and it says the db is loaded but when i try to run a query against a table it says table does not exist. when i query the same table using my eclipse set up the query returns a result. there has to be an explanation. i know dgSqlite is not broke. i'd like to

[sqlite] re: which db admin tool for java wrapper

2005-08-24 Thread Jim McNamara
hi- i see where it says to use isql viewer. i am playing with that now trying to get it to work. thanks, jim Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs

[sqlite] trigger question

2005-09-19 Thread Jim McNamara
Hi- This syntax isnt working. I cant figure out what i am doing wrong. I created a budget calculator with a sqlite java wrapper/driver. I am trying to make it a little easier to use. thanks for any tips! jim CREATE TRIGGER fki_statusDetail_statusMaster_id BEFORE INSERT ON Status_Detail FOR

Re: [sqlite] trigger question

2005-09-19 Thread Jim McNamara
. it is enforcing the trigger now :-) thanks, jim --- Jim McNamara <[EMAIL PROTECTED]> wrote: > Hi- > > This syntax isnt working. > I cant figure out what i am doing wrong. > I created a budget calculator with a sqlite java > wrapper/driver. I am trying to make it a little > easier

[sqlite] wondering about sqlite and webhosts

2005-10-06 Thread Jim McNamara
hi- when thinking about software to use on my next website i came up with sqlite, http://www.freeguppy.org/articles.php?lng=en=55044 , php5, abyss webserver, and phpedit. i dont see many webhosts that advertise sqlite availability. are webhosts excluding support for sqlite for any reason i.e.

Re: [sqlite] wondering about sqlite and webhosts

2005-10-06 Thread Jim McNamara
Hi Bob- thanks for the great info. I will try to word this part more carefully. I am not worried about the information in my DB being secured or i would just use mysql. Sometimes a webhost wont use software like some tcl extension or other for various reasons including but not limited to security

Re: [sqlite] sqlite and webhosts -SOLVED

2005-10-07 Thread Jim McNamara
--- John Stanton <[EMAIL PROTECTED]> wrote: > I think you miss the point about Sqlite. It is just > a part of your CGI > program - you don't need any help from the ISP, just > a directory with > enough disk space for the Sqlite file. For a > modestly sized web > application it is a great

[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

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

[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] sorry for the confusion re: academic software

2004-06-04 Thread jim mcnamara

[sqlite] re: academic software licensing (delphi)

2004-06-04 Thread jim mcnamara
hi- i dont think delphi 7 personal edition will work with sqlite (not 100% sure though). i believe i need more than a tdataset that works with sqlite to get it to work with delphi 7 personal edition. there is an alternative however. http://ibobjects.com seems to be very generous with licensing