Matt, I tried out your SQL file and was getting a syntax error on the first few lines of comments (it didn't seem to like the /* */ syntax). I converted this to the "--" style comments and then it worked.
Looking at the output, everything seems to match what I would expect with a couple minor differences: 1) Buckets that do not have any transactions/money flows yet do not show up in the list. This happens in my file only because I've started as of this month and haven't had those type of expenses yet. I handled this in my script by explicitly querying for all the non-hidden buckets to come up with my listing, but admittedly most people probably won't care about this, but it was something my wife noticed and requested to be fixed :) 2) I use a custom bucket order (not alphabetical) and this query returns an alphabetically sorted list. In my script I order by ZBUCKET.ZSEQUENCE to get the order I expect. Again, this might not matter if people simply suck this output into another script that manipulates it further. -Lance --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "No Thirst Software User Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/no-thirst-software?hl=en -~----------~----~----~----~------~----~------~--~---
