Re: [sqlite] Accessing sqlite3 through javascript.

I would like to thank you all first for replying to my query.. You have cleared my doubt to a great extent.However I still have somethings to be cleared.I will ask them later after studying sqlite a bit more. Its better to ask precise questions rather than vauge queries. Thank you. --- On Sat,

[sqlite] append table

howdy! Questions: suppose tables t1 t2 exits in two separate db files, d1 d2 respectively. t1 t2 have identical schemas, but different data. I want to append t2 to t1. I suppose the way to do that is to open a connect to d1, use the attach command to reference d2.t2 and issue a

Re: [sqlite] append table

On Sat, May 16, 2009 at 5:22 PM, James Gregurich bayouben...@mac.com wrote: howdy! Questions: suppose tables t1 t2 exits in two separate db files, d1 d2 respectively. t1 t2 have identical schemas, but different data. I want to append t2 to t1. I suppose the way to do that is to open

[sqlite] Updating two tables rows in one sql statement

Hello, I'm trying to update two tables with one statement but, i'm not getting something right. can someone here help me , or guide me to the right place to get help? Thanks UPDATE funrecipes, ingredients SET funrecipes.recipetitle, funrecipes.copyright, funrecipes.directions,

Re: [sqlite] Updating two tables rows in one sql statement

On Sat, May 16, 2009 at 5:35 PM, velkropie velkro...@gmail.com wrote: Hello, I'm trying to update two tables with one statement but, i'm not getting something right. can someone here help me , or guide me to the right place to get help? Thanks UPDATE funrecipes, ingredients SET

Re: [sqlite] Updating two tables rows in one sql statement

On 17/05/2009 1:35 AM, velkropie wrote: Hello, I'm trying to update two tables with one statement but, i'm not getting something right. can someone here help me , or guide me to the right place to get help? Thanks UPDATE funrecipes, ingredients SET funrecipes.recipetitle,

Re: [sqlite] Updating two tables rows in one sql statement

John Machin wrote: On 17/05/2009 1:35 AM, velkropie wrote: Hello, I'm trying to update two tables with one statement but, i'm not getting something right. can someone here help me , or guide me to the right place to get help? Thanks UPDATE funrecipes, ingredients SET

Re: [sqlite] Updating two tables rows in one sql statement

On 17/05/2009 10:34 AM, velkropie wrote: John Machin wrote: On 17/05/2009 1:35 AM, velkropie wrote: Hello, I'm trying to update two tables with one statement but, i'm not getting something right. can someone here help me , or guide me to the right place to get help? Thanks UPDATE