[EMAIL PROTECTED] said the following, On 2007-05-09 20:16: > I wanted to try out some trees in sql using methods as in > > http://www.dbazine.com/oracle/or-articles/tropashko4 > http://www.grzm.com/fornow/archives/2004/07/10/static_hierarchies > > > So I set up a simple table; > > heirarchy(name,path)={ > King, '1' > Jones, '1.1' > Scott, '1.1.1' > Adams, '1.1.1.1' > Ford, '1.1.2' > Smith, '1.1.2.1' > Blake, '1.2' > Allen, '1.2.1' > Ward, '1.2.2' > Clark, '1.3' > Miller, '1.3' > } > > with a query defined in the SQL screen > myquery=SELECT name, path FROM heirarchy WHERE path = '1.1' OR path = '1' > > But when I add a text widget to a form with formsource=myquery > the widget datasource is 'expr1' > If I click on the query design view, then myquery is changed to: > SELECT name,path FROM heirarchy > But there seems to be no way of selecting fields from mysquery > without clicking on the query design view screen. > > > Is it possible to pick query columns without using query design mode?
In other words this would lead to designing a query with subquery, if I understand correctly. Subqueries are not supported at all in the Query Designer yet (before Kexi 2.1...), even in SQL View -- and even if something does not cause error in the SQL View. Feel free to add a wish to bugs.kde.org for relevant features -- more wishes filed explicitly help making people aware what they can demand and vote... -- regards / pozdrawiam, Jaroslaw Staniek Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on Kexi & KOffice: http://www.kexi.pl/en, http://www.koffice.org KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kde.org _______________________________________________ Kexi mailing list [email protected] https://mail.kde.org/mailman/listinfo/kexi
