Re: [sqlite] Sqlite Version 3.2.2

e.org> Sent: Monday, February 18, 2008 1:13 PM Subject: [sqlite] Sqlite Version 3.2.2 > Is it feasible to a DataBase on one computer and have multiple users on a > LAN accessing the DataBase at the same time? > > Thanks for your input > > Walt Mc Whirter > _

Re: [sqlite] Sqlite Version 3.2.2

"Walt" <[EMAIL PROTECTED]> wrote: > Is it feasible to a DataBase on one computer and have multiple > users on a LAN accessing the DataBase at the same time? > This can be made to work. But you will probably be much happier with a client/server database such as MySQL or PostgreSQL. They are

[sqlite] Sqlite Version 3.2.2

Is it feasible to a DataBase on one computer and have multiple users on a LAN accessing the DataBase at the same time? Thanks for your input Walt Mc Whirter ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Version 3.2.2

Mike McGonagle wrote: > > Could you site a reference on this? I have been looking for documentation on > how SQL deals with quoted things for a while now, but have not found > anything. > Mike, Standard SQL is defined by several different standards; SQL-92, SQL:1999, and SQL:2003. Ultimately

Re: [sqlite] Version 3.2.2

Trey, Could you site a reference on this? I have been looking for documentation on how SQL deals with quoted things for a while now, but have not found anything. Thanks, Mike On Feb 6, 2008 8:21 PM, Trey Mack <[EMAIL PROTECTED]> wrote: > > UPDATE listings SET buyer = 'Price' WHERE listnum =

Re: [sqlite] Version 3.2.2

Mack" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Wednesday, February 06, 2008 7:21 PM Subject: Re: [sqlite] Version 3.2.2 > > UPDATE listings SET buyer = 'Price' WHERE listnum = 12345 > > Double quotes are

Re: [sqlite] Version 3.2.2

Literals in SQL use single quotes. Walt wrote: > I have a table 'listings' with fields 'listnum', 'price' and 'buyer' etc. > > executing the following sql > > UPDATE listings SET buyer = "Price" WHERE listnum = 12345 > > results in the 'buyer' field being set to the contents of the 'price'

Re: [sqlite] Version 3.2.2

UPDATE listings SET buyer = 'Price' WHERE listnum = 12345 Double quotes are for column names. Walt wrote: > I have a table 'listings' with fields 'listnum', 'price' and 'buyer' etc. > > executing the following sql > > UPDATE listings SET buyer = "Price" WHERE listnum = 12345 > > results in the

[sqlite] Version 3.2.2

I have a table 'listings' with fields 'listnum', 'price' and 'buyer' etc. executing the following sql UPDATE listings SET buyer = "Price" WHERE listnum = 12345 results in the 'buyer' field being set to the contents of the 'price' field instead of setting the field 'buyer' to "Price". Need