Re: [sqlite] Re: sqlite-users Digest 22 May 2004 05:23:11 -0000 Issue 115

2004-05-22 Thread Greg Miller
Ulrik Petersen wrote: IANAL, but the way I understand it, you can't link against their libraries and still distribute your code under an Open Source license, or distribute your binaries under a license that requires that the software be offered at no charge. My understanding may be flawed, so

Re: [sqlite] syncronizing

2004-05-22 Thread Derrell . Lipman
nathanvi <[EMAIL PROTECTED]> writes: > In my office we have to share a databse (a list of addresses). > A lot of people has a notebook. > So my idea was: > - a file.sqlite on the server in which all people can add, delete, > select contacts > - when someone have to go away, he can copy this

[sqlite] Re: sqlite-users Digest 22 May 2004 05:23:11 -0000 Issue 115

2004-05-22 Thread Ulrik Petersen
Hello all, Michael Roth wrote: > and I wrote: - Microsoft Visual C++ Toolkit 2003. Microsoft recently released their compiler and toolchain for free download: http://msdn.microsoft.com/visualc/vctoolkit2003/ Check the license! It is not really fair! Don't use this toolchain. Oops, I hadn't read

Re: [sqlite] Version 3 design issue: Keep the COPY command?

2004-05-22 Thread Hans-Juergen Taenzer
D. Richard Hipp ([EMAIL PROTECTED]) wrote: > Here are the options: > (1) Extend the syntax of the COPY command to allow the user > to specify the text representation of the file being > imported. I would prefer this option. In addition it should be possible to

Re: [sqlite] Version 3 design issue: Keep the COPY command?

2004-05-22 Thread Paolo Vernazza
D. Richard Hipp wrote: (3) Remove the COPY command all together. The third. Paolo - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Version 3 design issue: Keep the COPY command?

2004-05-22 Thread Darren Duncan
At 12:38 PM -0500 5/22/04, Daniel Lee Kruse wrote: Frank Baumgart wrote: D. Richard Hipp wrote: (3) Remove the COPY command all together. For the reasons you gave below, esp. to keep the size down (on an embedded system) Frank Baumgart [snip] I second Frank's response. I third this. Get COPY

Re: [sqlite] syncronizing

2004-05-22 Thread Mrs. Brisby
On Sat, 2004-05-22 at 13:47, Puneet Kishor wrote: > On May 22, 2004, at 12:31 PM, nathanvi wrote: > > > In my office we have to share a databse (a list of addresses). > > A lot of people has a notebook. > > So my idea was: > > - a file.sqlite on the server in which all people can add, delete, > >

Re: [sqlite] syncronizing

2004-05-22 Thread Puneet Kishor
On May 22, 2004, at 1:17 PM, Mario Ruggier wrote: On May 22, 2004, at 7:47 PM, Puneet Kishor wrote: On May 22, 2004, at 12:31 PM, nathanvi wrote: In my office we have to share a databse (a list of addresses). A lot of people has a notebook. So my idea was: - a file.sqlite on the server in which

Re: [sqlite] syncronizing

2004-05-22 Thread Mario Ruggier
On May 22, 2004, at 7:47 PM, Puneet Kishor wrote: On May 22, 2004, at 12:31 PM, nathanvi wrote: In my office we have to share a databse (a list of addresses). A lot of people has a notebook. So my idea was: - a file.sqlite on the server in which all people can add, delete, select contacts

Re: [sqlite] syncronizing

2004-05-22 Thread Puneet Kishor
On May 22, 2004, at 12:31 PM, nathanvi wrote: In my office we have to share a databse (a list of addresses). A lot of people has a notebook. So my idea was: - a file.sqlite on the server in which all people can add, delete, select contacts - when someone have to go away, he can copy this

Re: [sqlite] Version 3 design issue: Keep the COPY command?

2004-05-22 Thread Daniel Lee Kruse
Frank Baumgart wrote: D. Richard Hipp wrote: (3) Remove the COPY command all together. For the reasons you gave below, esp. to keep the size down (on an embedded system) Frank Baumgart [snip] I second Frank's response. -- Daniel Lee Kruse

[sqlite] syncronizing

2004-05-22 Thread nathanvi
In my office we have to share a databse (a list of addresses). A lot of people has a notebook. So my idea was: - a file.sqlite on the server in which all people can add, delete, select contacts - when someone have to go away, he can copy this file on his notebook and modify it when

Re: [sqlite] Version 3 design issue: Keep the COPY command?

2004-05-22 Thread Frank Baumgart
D. Richard Hipp wrote: (3) Remove the COPY command all together. For the reasons you gave below, esp. to keep the size down (on an embedded system) Frank Baumgart - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: [sqlite] Two Table Sort Question

2004-05-22 Thread Puneet Kishor
On May 22, 2004, at 2:25 AM, Darren Duncan wrote: At 10:23 PM -0700 5/21/04, Sanford Selznick wrote: I have Table1: data1 data2 data3 nameID -> id of record in Table2 I have Table2 id name1 name2 I'd like to select all records from table 1, and have them sorted by name1. What's the best way to

Re: [sqlite] Two Table Sort Question

2004-05-22 Thread Darren Duncan
At 10:23 PM -0700 5/21/04, Sanford Selznick wrote: I have Table1: data1 data2 data3 nameID -> id of record in Table2 I have Table2 id name1 name2 I'd like to select all records from table 1, and have them sorted by name1. What's the best way to do this? Try this: SELECT t1.* FROM Table1 t1 INNER