Fw: [sqlite] add new column to table

2005-01-12 Thread Dennis Cote
Dennis Cote wrote: Lloyd Thomas wrote: Thanks. That is going OK but I am having a problem with updating the new column with the info I need. It seems to update with the same entry from my users table to all rows. UPDATE call_data SET caller_name = (SELECT firstname || surname AS 'caller_name' FROM

Re: [sqlite] add new column to table

2005-01-12 Thread Lloyd Thomas
new column to table Dennis Cote wrote: Lloyd Thomas wrote: Thanks. That is going OK but I am having a problem with updating the new column with the info I need. It seems to update with the same entry from my users table to all rows. UPDATE call_data SET caller_name = (SELECT firstname || surname

Re: [sqlite] add new column to table

2005-01-12 Thread Dennis Cote
: [sqlite] add new column to table Dennis Cote wrote: Lloyd Thomas wrote: Thanks. That is going OK but I am having a problem with updating the new column with the info I need. It seems to update with the same entry from my users table to all rows. UPDATE call_data SET caller_name = (SELECT

Re: [sqlite] add new column to table

2005-01-12 Thread Lloyd Thomas
Message - From: Dennis Cote [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Wednesday, January 12, 2005 5:21 PM Subject: Re: [sqlite] add new column to table Lloyd Thomas wrote: Thanks Dennis. As long as I know where I stand. I can probably use PHP or Delphi to update each row manually

Re: [sqlite] add new column to table

2005-01-11 Thread Lloyd Thomas
UPDATES with SUB SELECTS. What is the URL?Lloyd- Original Message - From: Bert Verhees [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Tuesday, January 11, 2005 7:55 AM Subject: Re: [sqlite] add new column to table Op maandag 10 januari 2005 23:56, schreef Lloyd Thomas: Thanks

Re: [sqlite] add new column to table

2005-01-11 Thread Lloyd Thomas
regarding UPDATES with SUB SELECTS. What is the URL? Lloyd - Original Message - From: Bert Verhees [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Tuesday, January 11, 2005 7:55 AM Subject: Re: [sqlite] add new column to table Op maandag 10 januari 2005 23:56, schreef Lloyd Thomas

[sqlite] add new column to table

2005-01-10 Thread Lloyd Thomas
I wish to create a new column in a table and add data, which is queried from another table.What is the best way? Lloyd

Re: [sqlite] add new column to table

2005-01-10 Thread Lloyd Thomas
another table. Lloyd - Original Message - From: Paul Dixon [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Monday, January 10, 2005 5:50 PM Subject: Re: [sqlite] add new column to table Lloyd Thomas wrote: I wish to create a new column in a table and add data, which is queried from

Re: [sqlite] add new column to table

2005-01-10 Thread Lloyd Thomas
extn_no FROM call_data)); I have missed something? - Original Message - From: Lloyd Thomas [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Monday, January 10, 2005 9:08 PM Subject: Re: [sqlite] add new column to table Thanks Paul, I have used that example before

Re: [sqlite] add new column to table

2005-01-10 Thread Bert Verhees
: Monday, January 10, 2005 9:08 PM Subject: Re: [sqlite] add new column to table Thanks Paul, I have used that example before to recreate a table. Can I use the same thing to recreate a table and populate a new column with data from a select query. The table I wish to recreate