[sqlite] How to parse VIEW fields definitions?

2011-06-14 Thread Alexey Pechnikov
As example, we have view: create view vtest as select name1 || ' ' || name2 as name from test; How to get the definition of name field (will be name1 || ' ' || name2)? Of cource, the view can be more complex. -- Best regards, Alexey Pechnikov. http://pechnikov.tel/

Re: [sqlite] How to parse VIEW fields definitions?

2011-06-14 Thread Nico Williams
On Tue, Jun 14, 2011 at 1:58 PM, Alexey Pechnikov pechni...@mobigroup.ru wrote: As example, we have view: create view vtest as select name1 || ' ' || name2 as name from test; How to get the definition of name field (will be name1 || ' ' || name2)? Of cource, the view can be more complex.

Re: [sqlite] How to parse VIEW fields definitions?

2011-06-14 Thread Alexey Pechnikov
The new PRAGMA or Virtual Table will be more useful. But I don't sure about possibility of this. 2011/6/14 Nico Williams n...@cryptonector.com: On Tue, Jun 14, 2011 at 1:58 PM, Alexey Pechnikov pechni...@mobigroup.ru wrote: As example, we have view: create view vtest as select name1 || ' '