Re: [sqlite] Getting Started With SQLite3

2006-09-05 Thread Jay Sprenkle
> The ".import" command of the command line program that comes with sqlite > works. If you need something that doesn't do check out my program, see > the > links below. You should also check out a text editor that has macros and > regular expression search and replace. 180 lines isn't much harder

Re: [sqlite] Getting Started With SQLite3

2006-09-05 Thread Dennis Cote
Jay Sprenkle wrote: The ".import" command of the command line program that comes with sqlite works. If you need something that doesn't do check out my program, see the links below. You should also check out a text editor that has macros and regular expression search and replace. 180 lines

Re: [sqlite] Getting Started With SQLite3

2006-09-01 Thread Rich Shepard
On Fri, 1 Sep 2006, Jay Sprenkle wrote: The ".import" command of the command line program that comes with sqlite works. Thank you, Jay. I missed that. Rich -- Richard B. Shepard, Ph.D. |The Environmental Permitting Applied Ecosystem Services, Inc.(TM)|

Re: [sqlite] Getting Started With SQLite3

2006-09-01 Thread Jay Sprenkle
On 9/1/06, Rich Shepard <[EMAIL PROTECTED]> wrote: Is there a command to bulk load data (in comma and quote format) into a table? I'd hate to copy 180 lines x 31 attributes by individually. The ".import" command of the command line program that comes with sqlite works. If you need

Re: [sqlite] Getting Started With SQLite3

2006-09-01 Thread Rich Shepard
On Fri, 1 Sep 2006, Sergio 'OKreZ' Agosti wrote: http://www.rcs-comp.com/site/index.php/view/Utilities-SQLite_foreign_key_trigger_generator Sergio, Thank you. I'll need to re-do the tables now that I see that I can get the constraints that are needed. Rich -- Richard B. Shepard, Ph.D.

Re: [sqlite] Getting Started With SQLite3

2006-09-01 Thread Sergio 'OKreZ' Agosti
On 01/set/06, at 15:16, Rich Shepard wrote: Is there a way to write SQL statements that perform the same referential integrity checks as if foreign keys were available for constraints? http://www.rcs-comp.com/site/index.php/view/Utilities- SQLite_foreign_key_trigger_generator

[sqlite] Getting Started With SQLite3

2006-09-01 Thread Rich Shepard
I'm using sqlite3 in an application, and I think that I've read all the docs. A search of the archives didn't reveal any threads that answer my two questions so I'll ask them here. If there's something in the archives or a doc that I missed, please point me to it. Is there a way to write SQL