[dabo-users] Dabo-users List Statistics for April 2013

2013-05-01 Thread List Administrator Account
== Dabo-users List Statistics April 2013 == Subscriber Count at End of Month: 293 == Total Posts: 69 (Up 50.0% from March 2013) Daily Message Counts for

[dabo-users] bizobj's more pedticular

2013-05-01 Thread John Fabiani
Hi, in 0.9.5 I could get away with self.addField("extract(year from age(born)) as studentage") without adding the "studentage" to the NonUpdateFields list. In 0.9.9 it is a requirement (maybe it should have been in the past too). But I was wondering if that was intended??? Johnf

Re: [dabo-users] bizobj's more pedticular

2013-05-01 Thread John Fabiani
That should have been "particular" in subject line. John On 05/01/2013 03:05 PM, John Fabiani wrote: Hi, in 0.9.5 I could get away with self.addField("extract(year from age(born)) as studentage") without adding the "studentage" to the NonUpdateFields list. In 0.9.9 it is a requirement (maybe it

[dabo-users] using a temp table

2013-05-01 Thread John Fabiani
Hi, In the past I was able to use a temp table doing the following: csql = 'a long create temp table statement with the name tempstudent' biz = dabo.biz.dBizobj(connection) biz.execute(csql) biz.DataSource = 'temptstudent' #the temp table name biz.KeyField = "pkid" biz.new() What is the correc

Re: [dabo-users] Problem with custom sql-statement and getDataSet() with version>0.9.3

2013-05-01 Thread Paul McNett
On 4/30/13 12:22 PM, Ed Leafe wrote: > On Apr 30, 2013, at 1:50 PM, Max Voß wrote: > >> That is strange, it is in fact a problem with the conversion of my >> float-fields when I change the db-fields from float to decimal-type, >> what is the better choice anyway, everything works like a charm. Bu

Re: [dabo-users] bizobj's more pedticular

2013-05-01 Thread Paul McNett
On 5/1/13 3:05 PM, John Fabiani wrote: > Hi, > in 0.9.5 I could get away with > self.addField("extract(year from age(born)) as studentage") > > without adding the "studentage" to the NonUpdateFields list. > > In 0.9.9 it is a requirement (maybe it should have been in the past too). > But I was

Re: [dabo-users] using a temp table

2013-05-01 Thread Paul McNett
On 5/1/13 4:16 PM, John Fabiani wrote: > Hi, > In the past I was able to use a temp table doing the following: > > csql = 'a long create temp table statement with the name tempstudent' > > biz = dabo.biz.dBizobj(connection) > biz.execute(csql) > biz.DataSource = 'temptstudent' #the temp table na

Re: [dabo-users] Problem with custom sql-statement and getDataSet() with version>0.9.3

2013-05-01 Thread Ed Leafe
On May 1, 2013, at 6:39 PM, Paul McNett wrote: > I just wrote some test cases to show that indeed, Dabo does convert float to > decimal. Of course; that's not the question. The question is why it throws an exception in Max's situation: [snip] File "/home/max/projekte/kolibrill/dabo/d

Re: [dabo-users] Problem with custom sql-statement and getDataSet() with version>0.9.3

2013-05-01 Thread Paul McNett
On 5/1/13 5:32 PM, Ed Leafe wrote: > On May 1, 2013, at 6:39 PM, Paul McNett wrote: > >> > I just wrote some test cases to show that indeed, Dabo does convert float >> > to decimal. > Of course; that's not the question. The question is why it throws an > exception in Max's situation: > >

Re: [dabo-users] using a temp table

2013-05-01 Thread John Fabiani
On 05/01/2013 04:43 PM, Paul McNett wrote: On 5/1/13 4:16 PM, John Fabiani wrote: Hi, In the past I was able to use a temp table doing the following: csql = 'a long create temp table statement with the name tempstudent' biz = dabo.biz.dBizobj(connection) biz.execute(csql) biz.DataSource = 'tem