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

The new PRAGMA or Virtual Table will be more useful. But I don't sure about possibility of this. 2011/6/14 Nico Williams : > On Tue, Jun 14, 2011 at 1:58 PM, Alexey Pechnikov > wrote: >> As example, we have view: >> >> create view vtest as select

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

On Tue, Jun 14, 2011 at 1:58 PM, Alexey Pechnikov 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

[sqlite] How to parse VIEW fields definitions?

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/