Re: [sqlite] implementing editable result sets

2005-12-20 Thread John Stanton
Will Leshner wrote: On Dec 20, 2005, at 7:46 AM, John Stanton wrote: I haven't looked closely at the problem, so these are just first ideas extending CM's approach. Basically there should be no reason to perform any analysis of the SQL since that has already been done and the

Re: [sqlite] implementing editable result sets

2005-12-20 Thread Robert Simpson
All the source code is on sourceforge ... http://sourceforge.net/projects/sqlite-dotnet2 - Original Message - From: "Joel Lucsy" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Tuesday, December 20, 2005 11:53 AM Subject: Re: [sqlite] implementing edit

Re: [sqlite] implementing editable result sets

2005-12-20 Thread Will Leshner
On Dec 20, 2005, at 10:46 AM, Fanda Vacek wrote: If you parse such a simple query like SELECT [*,] bla [, bla] FROM table-name WHERE blabla , you'll get into less troubles than if you play with the rowid trick. All you need is to check if returned colnames can be found in table-name. And

Re: [sqlite] implementing editable result sets

2005-12-20 Thread Will Leshner
On Dec 20, 2005, at 10:19 AM, Robert Simpson wrote: What I'm left with are the alias names and original database table and column names for all the fields in the query, complete with information on whether or not any field is a primary key, how many different tables are involved in the

Re: [sqlite] implementing editable result sets

2005-12-20 Thread Joel Lucsy
Can you share what you changed? On 12/20/05, Robert Simpson <[EMAIL PROTECTED]> wrote: > > My approach in the ADO.NET 2.0 provider was to modify the core engine > slightly. I added a database pragma, which when enabled, directs the > internal generateColumnNames() function in select.c to emit

Re: [sqlite] implementing editable result sets

2005-12-20 Thread Fanda Vacek
If you parse such a simple query like SELECT [*,] bla [, bla] FROM table-name WHERE blabla , you'll get into less troubles than if you play with the rowid trick. All you need is to check if returned colnames can be found in table-name. And it is a simple question using PRAGMA

Re: [sqlite] implementing editable result sets

2005-12-20 Thread Robert Simpson
- Original Message - From: "Will Leshner" <[EMAIL PROTECTED]> On Dec 20, 2005, at 7:46 AM, John Stanton wrote: I haven't looked closely at the problem, so these are just first ideas extending CM's approach. Basically there should be no reason to perform any analysis of the SQL

Re: [sqlite] implementing editable result sets

2005-12-20 Thread Will Leshner
On Dec 20, 2005, at 7:46 AM, John Stanton wrote: I haven't looked closely at the problem, so these are just first ideas extending CM's approach. Basically there should be no reason to perform any analysis of the SQL since that has already been done and the metalanguage generated. My

Re: [sqlite] implementing editable result sets

2005-12-20 Thread John Stanton
and such. of course, there is a cost to this... -Original Message- From: Will Leshner [mailto:[EMAIL PROTECTED] Sent: Monday, December 19, 2005 11:12 PM To: Forum SQLite Subject: [sqlite] implementing editable result sets Hi. I apologize in advance for the length of this question

RE: [sqlite] implementing editable result sets

2005-12-20 Thread Cariotoglou Mike
TECTED] > Sent: Monday, December 19, 2005 11:12 PM > To: Forum SQLite > Subject: [sqlite] implementing editable result sets > > Hi. I apologize in advance for the length of this question, > but it is a little involved. > > I am the author of a wrapper for SQLite and in that

[sqlite] implementing editable result sets

2005-12-19 Thread Will Leshner
Hi. I apologize in advance for the length of this question, but it is a little involved. I am the author of a wrapper for SQLite and in that wrapper there is an object called a RecordSet that represents the results of a query. One of the things you can do with a RecordSet is edit records.