Am Samstag, den 20.06.2009, 12:00 -0400 schrieb gnucash-devel-requ...@gnucash.org:
> Message: 1 > Date: Fri, 19 Jun 2009 12:52:37 -0400 > From: Phil Longstaff <plongst...@rogers.com> > Subject: Re: Another problem with scheme query and SQL backend > To: gnucash-devel@gnucash.org > Message-ID: <200906191252.37634.plongst...@rogers.com> > Content-Type: text/plain; charset="iso-8859-1" > > On May 31, 2009 12:41:13 pm Phil Longstaff wrote: > > On May 31, 2009 06:53:23 am Erwin Rieger wrote: > > > Hi, > > > > > > i have another funny problem with querying data from scheme with the > > > (my)sql backend. > > > > > > The query from my previous posts do only return transactions that > > > are/were shown in the gui (ledger)! > > > > > > Steps to reproduce: > > > * install config.user from my previous post in ~/.gnucash > > > * open a nonempty sql-book with gnucash (with --extra command line > > > option), all accounts closed, only account-tree visible > > > * run scheme query from the "Extensions - AQueryTest1" menu > > > * watch output on console: "got 0 transactions..." > > > * open a account with transactions in it > > > * run scheme query from the "Extensions - AQueryTest1" menu a > > > second time > > > * watch output on console, now it reports a number of returned > > > transactions > > > * close ledger view of account > > > * re-run query, console still reports a number of returned > > > transactions > > > > Yes, there definitely isn't support for general queries, yet. I *do* have > > something in there which is commented out, so maybe I need to get it > > working. I wasn't aware of the extensions menu, so didn't have a way of > > creating a general query. All I had was the ones built into gnucash. The > > main one is a split query for a single account, used to populate a > > register, and at this point, the assumption is that that is the only query > > used. This explains why your BQueryTest fails (isn't split query for a > > single account) and why this test here fails (it might load a single > > account, but not all accounts). However, any accounts which have a ledger > > open would have had those splits/transactions already loaded. > > Fixed (basically) in r18136 - still not support for complete queries, but > these queries work. > > Phil > I took a first look at the new revision - and it seems to be good. Now i am able to continue the work on my gnucash extensions. Thank you very much! -- Mit freundlichen Gruessen Erwin Rieger -------------------------------------------------------------------- | Ingenieurbuero Rieger, Software Entwicklung | EMail: erwin.rie...@ibrieger.de -------------------------------------------------------------------- _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
