Re: [dabo-users] Grid events- possible bug?

2009-09-08 Thread Ricardo Aráoz
Ed Leafe wrote: On Sep 7, 2009, at 9:07 PM, Ricardo Aráoz wrote: No, there are no records (when I use -1 as default hence NoRecordsException). But when I use 0 as default no exception is raised but the labels get their captions changed to the previously selected record. So my

Re: [dabo-users] Grid events- possible bug?

2009-09-08 Thread Ed Leafe
On Sep 8, 2009, at 6:18 AM, Ricardo Aráoz wrote: Scenario 2 : set default value of PrevRow to 0 == No exception raised but the values of both labels don't get changed on entry to the program (to be expected, as PrevRow == evt.row) but as soon as I start moving to other records the

Re: [dabo-users] PyCon 2010 - Call for Tutorials

2009-09-08 Thread Nate Lowrie
Ed Leafe wrote: I forwarded this to the list for two reasons: first, it was nice to see that Dabo is on the list of requested tutorials! Second, and more importantly, I need to get an idea as to what level of interest there would be in such a tutorial. If you think that

Re: [dabo-users] PyCon 2010 - Call for Tutorials

2009-09-08 Thread Ed Leafe
On Sep 8, 2009, at 9:40 AM, Nate Lowrie wrote: I think it would be nice to do an overview of Dabo and walk people through creating a database driven application. Here would be an interesting example: Thanks, but that's sort of what I had in mind. What I need is some sort of

Re: [dabo-users] How to determine control state chenge at form level?

2009-09-08 Thread Nate Lowrie
Jacek Kałucki wrote: Hi, Did the framework offers a way to determine control value change at form level? At the control level, I can use onInteractiveChange event, but when control losses focus, there is no possibility to determine change, because the control attribute _oldVal is reseted

Re: [dabo-users] PyCon 2010 - Call for Tutorials

2009-09-08 Thread John
On Tuesday 08 September 2009 07:44:16 am Ed Leafe wrote: On Sep 8, 2009, at 9:40 AM, Nate Lowrie wrote: I think it would be nice to do an overview of Dabo and walk people through creating a database driven application. Here would be an interesting example: Thanks, but that's sort

Re: [dabo-users] PyCon 2010 - Call for Tutorials

2009-09-08 Thread JpoorRandP
I'd like to do the tutorial, but I don't want to waste my time if there is no demand. -- Ed Leafe Ed, one or possibly two of us here would attend any dabo sessions you could put on. The more the better. Jonathan --- StripMime Report -- processed MIME parts ---

Re: [dabo-users] How to determine control state chenge at form level?

2009-09-08 Thread Jacek Kałucki
Użytkownik Nate Lowrie napisał: In your Form afterInit method after you declare the controls, just do: myControl.BindEvent(dabo.dEvents.ValueChanged, self.onMyControlValueChanged) where myControl is your control, and self.onMyControlValueChanged is the method you want to call to handle the

Re: [dabo-users] Design Question - Follow Up

2009-09-08 Thread Jeff Johnson
pgAdminIII was working fine. It was creating the public schema as well as my schema so when I executed it I get numerous errors because public already existed. I removed all of the public schema commands and I have a script where I could create duplicate schemas at will. To work with a

Re: [dabo-users] Design Question - Follow Up

2009-09-08 Thread John
I'm sure you already discovered that you can right click on any object and only backup, create the sql for the object. Just that you might have missed it. Johnf On Tuesday 08 September 2009 12:04:18 pm Jeff Johnson wrote: pgAdminIII was working fine. It was creating the public schema as well

[dabo-users] How to add a 'distinct'

2009-09-08 Thread John
Hi, Using standard Dabo bizObject and not using a UserSQL how can I add a 'Distinct' to the bizobj. select distinct b.pkid , b.lname,b.fname , d.name_1 from esattend a left join esclient b on b.pkid = a.clientid left join esenroll c on a.enrollid = c.pkid left join escourse d on d.pkid =

Re: [dabo-users] Design Question - Follow Up

2009-09-08 Thread Jeff Johnson
John: I did miss it! It would have saved me a lot of time, but I think my flogging helped me understand PostgreSQL better. Thanks! John wrote: I'm sure you already discovered that you can right click on any object and only backup, create the sql for the object. Just that you might have

Re: [dabo-users] How to add a 'distinct'

2009-09-08 Thread Paul McNett
John wrote: Hi, Using standard Dabo bizObject and not using a UserSQL how can I add a 'Distinct' to the bizobj. select distinct b.pkid , b.lname,b.fname , d.name_1 from esattend a left join esclient b on b.pkid = a.clientid left join esenroll c on a.enrollid = c.pkid left join

Re: [dabo-users] How to add a 'distinct'

2009-09-08 Thread Paul McNett
Paul McNett wrote: When do you need DISTINCT? I've written tons of SQL over the past 15 years and have never found the need for it. Specifically, what is the benefit of using DISTINCT over GROUP BY? Paul ___ Post Messages to:

Re: [dabo-users] Grid events- possible bug?

2009-09-08 Thread Ricardo Aráoz
Ed Leafe wrote: So the order of events is: - program starts - no records in bizobj or grid - grid is created and checks row position - error if PrevRow == -1 - bizobj requeries - data is now in bizobj and grid - user changes grid row - bizobj returns stale values

Re: [dabo-users] How to add a 'distinct'

2009-09-08 Thread John
On Tuesday 08 September 2009 02:57:29 pm Paul McNett wrote: Paul McNett wrote: When do you need DISTINCT? I've written tons of SQL over the past 15 years and have never found the need for it. Specifically, what is the benefit of using DISTINCT over GROUP BY? Paul How would re-write the

[dabo-users] Data source reference in the Class Designer

2009-09-08 Thread Ricardo Aráoz
Hi, according to page http://dabodev.com/wiki/HowToCustomizeCheckboxes : Questions for Ed by Luca: 1) What is the dabo way to get a reference to the bizobj from the class designer? ed: Just type the DataSource http://dabodev.com/wiki/DataSource of the bizobj you want. The framework handles

Re: [dabo-users] How to add a 'distinct'

2009-09-08 Thread Ed Leafe
On Sep 8, 2009, at 6:10 PM, John wrote: How would re-write the SQL I provided. select b.pkid , b.lname,b.fname , d.name_1 from esattend a left join esclient b on b.pkid = a.clientid left join esenroll c on a.enrollid = c.pkid left join escourse d on d.pkid = c.fk_escourse where a.sessionid =

Re: [dabo-users] How to add a 'distinct'

2009-09-08 Thread Paul McNett
John wrote: On Tuesday 08 September 2009 02:57:29 pm Paul McNett wrote: Paul McNett wrote: When do you need DISTINCT? I've written tons of SQL over the past 15 years and have never found the need for it. Specifically, what is the benefit of using DISTINCT over GROUP BY? Paul How would

Re: [dabo-users] How to add a 'distinct'

2009-09-08 Thread John
On Tuesday 08 September 2009 04:34:00 pm Ed Leafe wrote: select b.pkid , b.lname,b.fname , d.name_1 from esattend a left join esclient b on b.pkid = a.clientid left join esenroll c on a.enrollid = c.pkid left join escourse d on d.pkid = c.fk_escourse where a.sessionid = 4596 group by

Re: [dabo-users] How to add a 'distinct'

2009-09-08 Thread John
On Tuesday 08 September 2009 04:36:14 pm Paul McNett wrote: John wrote: On Tuesday 08 September 2009 02:57:29 pm Paul McNett wrote: Paul McNett wrote: When do you need DISTINCT? I've written tons of SQL over the past 15 years and have never found the need for it. Specifically, what is