RE: [sqlite] New SQLitePlus version available

2006-05-18 Thread Chethana, Rao \(IE10\)
Hello! Is it an open source? Kind regards, Chethana. -Original Message- From: Brett Goodman [mailto:[EMAIL PROTECTED] Sent: Friday, May 19, 2006 9:48 AM To: sqlite-users@sqlite.org Subject: [sqlite] New SQLitePlus version available Hello all. Just to let everyone know I've

RE: [sqlite] SQL error: near "ANALYZE": syntax error

2006-04-11 Thread Chethana, Rao \(IE10\)
I think u've got to type the query after typing(next to) ANALYZE. -Original Message- From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 12, 2006 8:58 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] SQL error: near "ANALYZE": syntax error SQLite 3.2.2 does not support

RE: [sqlite] no errors,but not executed: Stored procedures in triggers

2006-03-24 Thread Chethana, Rao \(IE10\)
ect: Re: [sqlite] no errors,but not executed: Stored procedures in triggers On 3/24/06, Chethana, Rao (IE10) <[EMAIL PROTECTED]> wrote: > My problem is not with cascading or using recursive triggers. > Actually, > I am using "sqlite3_create_function" to execute some que

[sqlite] no errors,but not executed: Stored procedures in triggers

2006-03-24 Thread Chethana, Rao \(IE10\)
_open, before you can refer to them in your SQL statements. > They > are not stored in the database file itself. > > Finally, SQLite prepared statements (sqlite_prepare) can be thought of > as simple stored procedures defined in your program. Similar to custom > functions, you can pr

[sqlite] Stored procedures in triggers

2006-03-24 Thread Chethana, Rao \(IE10\)
 Hi, Can you tell me how to create a stored procedure in an sqlite3 database and use the same in a trigger? Please provide an example (as complete as possible). In the stored procedure I need to execute few queries on some tables. Can you tell me how to do that also? Any help is deeply

[sqlite] help in triggers(calling functions)

2006-03-18 Thread Chethana, Rao \(IE10\)
Hello! How do I call functions(user defined) or stored procedures from triggers in sqlite? For example, how do I do this in sqlite? CREATE TRIGGER TrgIns_PTable AFTER INSERT ON PTable FOR EACH ROW EXECUTE PROCEDURE PP_InsPTable(); Please do reply

RE: [sqlite] File locking additions

2006-03-09 Thread Chethana, Rao \(IE10\)
Hello! Why do u need semicolon there? U can just give-- Select Name,Surname,' ',Address as Details from personm where persID = 1098 Think this works. -Original Message- From: Roger [mailto:[EMAIL PROTECTED] Sent: Thursday, March 09, 2006 12:01 AM To: sqlite-users@sqlite.org Subject:

RE: [sqlite] OT: Donations?

2006-02-27 Thread Chethana, Rao \(IE10\)
Hi! Did u enquire about donations to sqlite.org ? what reply u got? -Original Message- From: Firman Wandayandi [mailto:[EMAIL PROTECTED] Sent: Monday, February 27, 2006 1:08 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] OT: Donations? On 2/27/06, Chethana, Rao (IE10) <[EM

RE: [sqlite] File format changed !!

2006-02-27 Thread Chethana, Rao \(IE10\)
Hi! Just use select * from sqlite_master; -Original Message- From: Pavan Savoy [mailto:[EMAIL PROTECTED] Sent: Monday, February 27, 2006 10:13 PM To: sqlite-users@sqlite.org Subject: [sqlite] File format changed !! I am trying to open a database created in SQLite 3.3.1 in SQlite

RE: [sqlite] OT: Donations?

2006-02-27 Thread Chethana, Rao \(IE10\)
Hello! That's a good idea! I think u can post ur question to www.sqlite.org & see. They'll b able to tell u. -Original Message- From: Denis Sbragion [mailto:[EMAIL PROTECTED] Sent: Monday, February 27, 2006 12:50 AM To: sqlite-users@sqlite.org Subject: [sqlite] OT: Donations? Hello,