Re: [sqlite] Sqlite Version 3.2.2

ebruary 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 desi

[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 http://sqlite.org:8080/cgi-bin/mailman/li

Re: [sqlite] Version 3.2.2

Thanks Trey and Dennis, I guess it is just confusing to me because these things appear to be "optional", but actually have very specific rules for how to use them or NOT use them. The only one that seems mandatory are the single quote literals. I try not to use field names with spaces or unusual ch

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 t

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 = 12

Re: [sqlite] Version 3.2.2

Mack" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" 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 for column names. &

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' fiel

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 HELP