[sqlite] Sqlite Version 3.2.2

2008-02-18 Thread Walt 
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/listinfo/sqlite-users

Re: [sqlite] Version 3.2.2

2008-02-07 Thread Walt 
Trey,

Thank you for the prompt reply.

Did not realize that double quote would denote column name.  Will have to 
check for column names when building sql statement and insert single quotes 
around that part of data.

Thanks again

Walt Mc Whirter


- Original Message - 
From: Trey 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 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 'buyer' field being set to the contents of the 'price' 
 field instead of setting the field 'buyer' to Price.

 Need HELP

 Walt Mc Whirter
 ___
 sqlite-users mailing list
 sqlite-users@sqlite.org
 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



 ___
 sqlite-users mailing list
 sqlite-users@sqlite.org
 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
 

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Version 3.2.2

2008-02-06 Thread Walt 
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

Walt Mc Whirter
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users