Re: [dabo-users] Dabo Question

2011-11-06 Thread John Fabiani
On Sunday, November 06, 2011 06:14:34 am Jeff Johnson wrote: Ed: You worked on a project where the data was stored on a web site and the application downloaded to the desktop and connected to the data on the web. I forgot what it was called. Maybe Slingshot. I would like to look at that if

Re: [dabo-users] row locking

2011-10-31 Thread John Fabiani
On Monday, October 31, 2011 05:40:25 am Thomas Ganss wrote: Hi John, I recently scanned the code to get an idea of the changes necessary to implement a basic conflict resolution at least on time stamps. The code to delete back then AFAIR did not check if SQL-delete was successful. If my

Re: [dabo-users] row locking feature

2011-10-31 Thread John Fabiani
On Monday, October 31, 2011 09:43:49 am Vineet Deodhar wrote: John Fabiani schrieb: Hi Guys, I like to know the thinking on row locking within the context of the Dabo framework. We all realize that in some cases it is not desirable to have optimistic locking (or the MVCC locking

[dabo-users] row locking

2011-10-29 Thread John Fabiani
Hi Guys, I like to know the thinking on row locking within the context of the Dabo framework. We all realize that in some cases it is not desirable to have optimistic locking (or the MVCC locking of Postgres). For example shipping/closing a sales order but allowing a second user to modify

[dabo-users] new error from dDateTextBox

2011-10-27 Thread John Fabiani
This is new. I have a dDateTextBox in which I type a valid date string. I now get this printed on the console. 2011-10-27 16:44:08 - ERROR - !!! Data Type Mismatch: table=public.esenroll; field=enrolled. Expecting: type 'datetime.date'; got: type 'unicode' Reviewing the dCursorMixin.py I

Re: [dabo-users] new error from dDateTextBox

2011-10-27 Thread John Fabiani
On Thursday, October 27, 2011 05:24:00 pm Paul McNett wrote: On 10/27/11 5:10 PM, John Fabiani wrote: This is new. Since what revision? Paul I don't know at the moment. Trying to find it now. Johnf ___ Post Messages to: Dabo-users@leafe.com

Re: [dabo-users] new error from dDateTextBox

2011-10-27 Thread John Fabiani
On Thursday, October 27, 2011 05:27:17 pm John Fabiani wrote: On Thursday, October 27, 2011 05:24:00 pm Paul McNett wrote: On 10/27/11 5:10 PM, John Fabiani wrote: This is new. Since what revision? Paul I don't know at the moment. Trying to find it now. Johnf I have gone

Re: [dabo-users] new error from dDateTextBox

2011-10-27 Thread John Fabiani
On Thursday, October 27, 2011 05:44:20 pm John Fabiani wrote: On Thursday, October 27, 2011 05:27:17 pm John Fabiani wrote: On Thursday, October 27, 2011 05:24:00 pm Paul McNett wrote: On 10/27/11 5:10 PM, John Fabiani wrote: This is new. Since what revision? Paul I

Re: [dabo-users] log INSERT statements

2011-10-26 Thread John Fabiani
On Wednesday, October 26, 2011 09:21:40 am Ed Leafe wrote: When you have the dbActivityLog directed to the console, you should see all UPDATE, INSERT, SELECT, and DELETE statements. To do this, run your app, and then open up a Command Window. Run these commands: import logging

Re: [dabo-users] Multiple bizobjs for the same table

2011-10-12 Thread John Fabiani
On Wednesday, October 12, 2011 07:30:31 am Ed Leafe wrote: On Oct 11, 2011, at 4:48 AM, Jacek Kałucki wrote: One of the limitations of Dabo form data manager is inability to manage multiple bizobjs of the same data source. It's because the target resolution is based on DataSource property,

Re: [dabo-users] Annexure to my earlier post

2011-10-12 Thread John Fabiani
On Wednesday, October 12, 2011 07:41:36 am Ed Leafe wrote: On Oct 11, 2011, at 10:34 AM, Vineet Deodhar wrote: Excuse me, I missed one more point to ask in earlier post. In appendDataSet() method, updateInternals=False by default. For better understanding of dabo system, can I know why

Re: [dabo-users] Annexure to my earlier post

2011-10-12 Thread John Fabiani
On Wednesday, October 12, 2011 09:34:26 am Paul McNett wrote: On 10/12/11 7:56 AM, John Fabiani wrote: -1 If I recall this caused an issue with my code. Could you provide the commit number and I could check into it further. Let me svn that for you: {{{ mac:~ pmcnett$ cd dabo

Re: [dabo-users] Multiple bizobjs for the same table

2011-10-12 Thread John Fabiani
On Wednesday, October 12, 2011 03:45:35 pm Paul McNett wrote: On 10/12/11 3:23 PM, Ed Leafe wrote: On Oct 12, 2011, at 3:20 PM, Jacek Kałucki wrote: This is what I proposed years ago in #1318. Personally, I'm using this code in my business layer. If you agree, I can implement it.

Re: [dabo-users] Multiple bizobjs for the same table

2011-10-12 Thread John Fabiani
On Wednesday, October 12, 2011 06:34:05 pm Ed Leafe wrote: On Oct 12, 2011, at 5:59 PM, John Fabiani wrote: Tell me will this DataAlias property allow me to access the same datasouce and move the record pointer in one without changing the record pointer in the others? It will allow

[dabo-users] ODBC for MsSQL

2011-09-17 Thread John Fabiani
Hi, I have working code that uses the pyodbc.py as the connection module to MsSQL server. Unfortunately, I haven't the time to recode the other modules namely the CxnEditor, or the AppWizard (might not need to do anything here) to support the new pyodbc.py. Currently working on some qt

Re: [dabo-users] Class for saving unrelated related bizobjs in single transaction

2011-09-10 Thread John Fabiani
On Saturday, September 10, 2011 02:13:59 am Vineet Deodhar wrote: I am writing a script (actually a hack to Ed's code in http://leafe.com/archives/msg/379103) for saving un-related related bizobjs in single transaction (in web2py) code start- class DE(): class

Re: [dabo-users] (Why) saving unrelated related bizobjs in single transaction

2011-09-10 Thread John Fabiani
on the above given code (it is a work-in-progress). Thanks, Vineet To my eye I think it will work. Of course I wonder if the transactions (unrealtedT) are truly unrelated than why have them in the same 'try'? Johnf == John, In some cases, I require unrelated sets in single

[dabo-users] ClassDesigner broken

2011-08-19 Thread John Fabiani
Hi, I'm just playing and discovered on my systems (windows, linux) with the latest Dabo ClassDesigner is broken: From Linux and python 2.6 I get: The program 'python' received an X Window System error. This probably reflects a bug in the program. The error was 'BadMatch (invalid parameter

Re: [dabo-users] ClassDesigner broken

2011-08-19 Thread John Fabiani
On Friday, August 19, 2011 09:11:49 am John Fabiani wrote: Hi, I'm just playing and discovered on my systems (windows, linux) with the latest Dabo ClassDesigner is broken: From Linux and python 2.6 I get: The program 'python' received an X Window System error. This probably reflects a bug

Re: [dabo-users] Error in _getRecord() of dCursorMixin()

2011-08-18 Thread John Fabiani
On Thursday, August 18, 2011 06:34:37 am Vineet Deodhar wrote: Hi ! As stated earlier on this list, I am using standalone 'bizobj' class with 'web2py'. I imported the entire dabo folder in my app. Database server is MySQL DB. There is a parent bizobj named as 'statBizObj'; (it has a child

Re: [dabo-users] codepad pasted: Error in _getRecord() of dCursorMixin()

2011-08-18 Thread John Fabiani
On Thursday, August 18, 2011 09:39:47 am Vineet Deodhar wrote: Dear John other list-members, I have pasted the code on http://dabo.codepad.org/FBIoYWUe But it can't be run as it is. It requires web2py framework. Fortunately, its deployment is JUST copy paste. If the code lines pasted

Re: [dabo-users] I have blue lines

2011-08-18 Thread John Fabiani
On Thursday, August 18, 2011 11:19:05 am Jim Byrnes wrote: What happens if you change your theme? A while back I thought I had a problem with the datePicker not highlighting my selection. Then I changed my theme for a totally unrelated reason and I started to see the proper highlighting.

Re: [dabo-users] I have blue lines

2011-08-18 Thread John Fabiani
On Thursday, August 18, 2011 11:49:42 am Jacek Kałucki wrote: Użytkownik John Fabiani napisał: class HeaderToolBar(dabo.ui.dPanel): Base question. Why are you using dPanel instead of dToolBar control as tools container? I couldn't get the icon large enough (if memory serves me

Re: [dabo-users] I have blue lines

2011-08-18 Thread John Fabiani
On Thursday, August 18, 2011 12:05:35 pm Jacek Kałucki wrote: Użytkownik John Fabiani napisał: I couldn't get the icon large enough (if memory serves me) on the toolbar. Are you using icons larger than 32pix? I thought that dToolBar can handle any icon size, but I used 32 max. Yes

Re: [dabo-users] I have blue lines

2011-08-18 Thread John Fabiani
On Thursday, August 18, 2011 12:11:45 pm John Fabiani wrote: On Thursday, August 18, 2011 12:01:59 pm John Fabiani wrote: On Thursday, August 18, 2011 11:49:42 am Jacek Kałucki wrote: Użytkownik John Fabiani napisał: class HeaderToolBar(dabo.ui.dPanel): Base question. Why are you

[dabo-users] just fun - another Dabo

2011-08-18 Thread John Fabiani
http://gowalla.com/checkins/42704749 Johnf ___ Post Messages to: Dabo-users@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message:

Re: [dabo-users] I have blue lines

2011-08-18 Thread John Fabiani
On Thursday, August 18, 2011 03:01:29 pm Jacek Kałucki wrote: Użytkownik John Fabiani napisał: Yes they are larger - I have several clients that are having a hard time seeing the icons and in general the form (unless they enlarge the fonts etc.) So I used large icons. Here, you have

[dabo-users] I have blue lines

2011-08-17 Thread John Fabiani
Hi, I posted a picture http://imageshack.us/photo/my-images/59/daboheader.png/ I have these blue lines around one of the dBitmapButtons. Anybody know where they are coming from??? The code below is what creates the buttons: class HeaderToolBar(dabo.ui.dPanel): def afterInit(self):

Re: [dabo-users] a better way to find if a field has changed

2011-08-16 Thread John Fabiani
On Tuesday, August 16, 2011 04:36:40 pm Paul McNett wrote: On 8/15/11 12:38 PM, Paul McNett wrote: that's my point. I'd like to use the field as a flag as part of a series of flags (even considered a state machine). But now I need a field to tell me if there were any changes.

[dabo-users] a better way to find if a field has changed

2011-08-15 Thread John Fabiani
Hi, I need to know if a field has changed. I can't just use oldVal(). oldVal() is none if no change has occurred or if the starting value is None. I was thinking of bizobj._CurrentCursor.getDataDiff(False) and check to see if my field was there. Is there an easier way? Johnf

Re: [dabo-users] a better way to find if a field has changed

2011-08-15 Thread John Fabiani
On Monday, August 15, 2011 12:27:54 pm Paul McNett wrote: oldVal() returns the old value, before any changes. So if it returns None, that was the starting value that's my point. I'd like to use the field as a flag as part of a series of flags (even considered a state machine). But now I

Re: [dabo-users] BizObj, FK TempCursor

2011-08-12 Thread John Fabiani
On Thursday, August 11, 2011 11:09:45 pm Vineet Deodhar wrote: Another query in this regard -- How do I get all the records from 'dist' Here do you mean to say that - do not define any FK relation in bizoj; and handle all the DML stuff externally ?

Re: [dabo-users] 'LinkField' property causing strange behaviour

2011-08-11 Thread John Fabiani
On Thursday, August 11, 2011 04:33:10 am Vineet Deodhar wrote: Thanks John Paul. ### (excessive quoting is removed for readability) I looked at the RowCount of distBizObj. It is only 2. There are total 31 records in the 'dist' table in MySQL DB. Upon looking closely, I found

Re: [dabo-users] BizObj with FK: I almost got it right

2011-08-11 Thread John Fabiani
On Thursday, August 11, 2011 09:11:56 am Vineet Deodhar wrote: Another query in this regard -- How do I get all the records from 'dist' table? (without getting filtered by statid=somevalue?) Ouch! That question is somewhat harder to answer. The cause of the

Re: [dabo-users] BizObj with FK: I almost got it right

2011-08-11 Thread John Fabiani
On Thursday, August 11, 2011 10:06:57 am Thomas Ganss wrote: If you don't link the biz objects, you select unfiltered from the DB. View the link as Inner Join-operation on the database tables, or a relation in foxpro terms if you come from that area. Only problem is the updates, etc on tables

Re: [dabo-users] standalone BizObj with FK relation not saving into database

2011-08-10 Thread John Fabiani
On Wednesday, August 10, 2011 02:34:01 am Vineet Deodhar wrote: #create stat bizobj statBizObj = dabo.biz.dAutoBizobj(conn) statBizObj.DataSource = 'stat' statBizObj.KeyField = 'statid' statBizObj.NonUpdateFields = ['statid'] statBizObj.UserSQL = 'select * from stat' statBizObj.requery()

Re: [dabo-users] I tried class-based standalone BizObj : no success

2011-08-10 Thread John Fabiani
On Wednesday, August 10, 2011 09:44:40 am you wrote: @John, I tried with the class-based code as you have shown. seek() setFieldVal() are working for 'statBizObj' only. But it is not working for 'distBizObj'. 'Not Working' means, no value is fetched from the 'distBizObj' through seek

[dabo-users] OT - for those moving data into Postgres or MySQL

2011-08-08 Thread John Fabiani
Hi, If my chance you have a need to move data from MS SQL into Postgres or MySQL - here is a way to move the data into a TEXT file in seventeen lines of python. http://catherinedevlin.blogspot.com/2011/08/mssql-to-csv.html Johnf ___ Post Messages to:

Re: [dabo-users] Incorrect DataStructure

2011-08-07 Thread John Fabiani
On Sunday, August 07, 2011 11:30:41 am OKB (not okblacke) wrote: =?UTF-8?B?SmFjZWsgS2HFgnVja2k=?= wrote: UÅŒytkownik OKB (not okblacke) napisał: I tracked down the source of the problem. The issue is that dCursorMixin uses DataStructure to determine whether the

Re: [dabo-users] Application error

2011-08-07 Thread John Fabiani
On Sunday, August 07, 2011 11:46:17 am Adrian Klaver wrote: On Sunday, August 07, 2011 11:40:00 am bob k. wrote: I’ve been following the step by step guide. Everything has worked fine until I entered the following code in the dForm: def createBizobjs(self): conn =

Re: [dabo-users] Application error

2011-08-07 Thread John Fabiani
On Sunday, August 07, 2011 12:14:00 pm bob k. wrote: uhhh. I need to give my eyes a break. I actually have wing ide. it can be used with dabo? anything special I need to do? thank you, bob k. -Original Message- From: John Fabiani Sent: Sunday, August 07, 2011 2:50 PM

Re: [dabo-users] dBitMapButton

2011-08-06 Thread John Fabiani
On Saturday, August 06, 2011 01:09:04 pm bob k. wrote: is it possible to add an image to a bitmap button. The Object Info shows a ‘picture’ field but I’m unable to edit. bob k. dabo.ui.dBitmapButton(self, TabStop = False, RegID=btnSaveID,

Re: [dabo-users] 4 digit year

2011-08-05 Thread John Fabiani
On Friday, August 05, 2011 01:34:26 am Jacek Kałucki wrote: Hi. Personally, I use daboized wx.DatePickerCtrl class for date controls. I didn't publish it since I can't test it on OSX. If you wish I will send you the source. cool - you mean you have it working with the mix-ins? Johnf

[dabo-users] 4 digit year

2011-08-04 Thread John Fabiani
Hi, I believe I used to force a four digit year in dDateTextBox. But I can't recall how I forced it. Can someone remind me - please! Johnf ___ Post Messages to: Dabo-users@leafe.com Subscription Maintenance:

Re: [dabo-users] 4 digit year

2011-08-04 Thread John Fabiani
On Thursday, August 04, 2011 03:42:30 pm John Fabiani wrote: Hi, I believe I used to force a four digit year in dDateTextBox. But I can't recall how I forced it. Can someone remind me - please! Johnf I couldn't find anything so I wrote something that appears to work. However, it only

Re: [dabo-users] Getting the old field value in Bizobj validate method

2011-07-19 Thread John Fabiani
On Tuesday, July 19, 2011 10:24:15 am Jacek Kałucki wrote: Użytkownik Nate Lowrie napisał: I know I've asked this before but for the life of me I can't find it. In the validation method of the bizobj, how do I 1) see what fields are changed and 2) compare an old field value to the current

Re: [dabo-users] Postgres temp table as bizobj - solved

2011-07-19 Thread John Fabiani
On Friday, July 15, 2011 01:36:54 pm John Fabiani wrote: Hi, Has anyone ever used a postgres temp table as the data source in a bizobj? I'd like to create a postgres temp table - maybe in the createbizobj() then use it as a normal bizobj. But - I'm not sure exactly how I'd set it up. Does

[dabo-users] Postgres temp table as bizobj

2011-07-15 Thread John Fabiani
Hi, Has anyone ever used a postgres temp table as the data source in a bizobj? I'd like to create a postgres temp table - maybe in the createbizobj() then use it as a normal bizobj. But - I'm not sure exactly how I'd set it up. Does anyone have any suggestions. Johnf

Re: [dabo-users] What is the dbMsSql status

2011-07-13 Thread John Fabiani
On Wednesday, July 13, 2011 05:35:08 am pyt...@bdurham.com wrote: Ed, Is there a possibility of using one of the Python ODBC modules? For raw access, yes. But these are not dbapi-compliant My understanding is that some of the ODBC modules are db-api compliant. 1. pyodbc - Python

Re: [dabo-users] What is the dbMsSql status

2011-07-13 Thread John Fabiani
On Wednesday, July 13, 2011 08:32:34 am Jamie Adams wrote: John, Please keep us posted on your progress. The last time I tried to work with MSSQL and Dabo, I was unsuccessful, but it has been a couple years. I'm curious to know the current state of MSSQL in Dabo and in Python, what works

Re: [dabo-users] What is the dbMsSql status

2011-07-13 Thread John Fabiani
On Wednesday, July 13, 2011 10:27:03 am Paul McNett wrote: On 7/13/11 9:09 AM, John Fabiani wrote: I don't plan to really start for two weeks when I tackle moving AccountMate (FoxPro) MsSQL data to Postgres. I'll need a solid MsSQL interface to get it done. So I'm torn between doing

[dabo-users] What is the dbMsSql status

2011-07-12 Thread John Fabiani
Hi, Looks like I will need to access MsSQL again. I recall there were others who also had the need. So I'm wondering if the current Dabo tools to access MsSQL are working? If not what are the current issues. Thanks for the help. Johnf ___ Post

Re: [dabo-users] What is the dbMsSql status

2011-07-12 Thread John Fabiani
On Tuesday, July 12, 2011 04:19:37 pm Jacek Kałucki wrote: Użytkownik John Fabiani napisał: Hi, Looks like I will need to access MsSQL again. I recall there were others who also had the need. So I'm wondering if the current Dabo tools to access MsSQL are working? If not what

Re: [dabo-users] What is the dbMsSql status

2011-07-12 Thread John Fabiani
On Tuesday, July 12, 2011 04:31:51 pm pyt...@bdurham.com wrote: Is there a possibility of using one of the Python ODBC modules? Malcolm I'm sure there is one. However, I wonder how cross platform an ODBC driver would be? I know there is a type of setup for Linux but I don't know of

[dabo-users] More strnage 2.7

2011-07-09 Thread John Fabiani
Hi, I continue to get strange errors from 2.7. openSUSE 11.4, wxPython 2.8.11.0 latest Dabo. Here's a new one Traceback (most recent call last): File /home/johnf/dabo/dabo/ui/uiwx/dPageFrameMixin.py, line 47, in __onPageChanging self.Pages[oldPageNum]._saveLastActiveControl()

Re: [dabo-users] More strnage 2.7

2011-07-09 Thread John Fabiani
On Saturday, July 09, 2011 11:45:43 am Jacek Kałucki wrote: Użytkownik John Fabiani napisał: Hi, I continue to get strange errors from 2.7. openSUSE 11.4, wxPython 2.8.11.0 latest Dabo. Here's a new one Traceback (most recent call last): File /home/johnf/dabo/dabo/ui/uiwx

Re: [dabo-users] More strnage 2.7

2011-07-09 Thread John Fabiani
On Saturday, July 09, 2011 11:48:32 am John Fabiani wrote: On Saturday, July 09, 2011 11:45:43 am Jacek Kałucki wrote: Użytkownik John Fabiani napisał: Hi, I continue to get strange errors from 2.7. openSUSE 11.4, wxPython 2.8.11.0 latest Dabo. Here's a new one Traceback

Re: [dabo-users] More strnage 2.7

2011-07-09 Thread John Fabiani
On Saturday, July 09, 2011 12:06:03 pm Jacek Kałucki wrote: Użytkownik John Fabiani napisał: You could be correct but then why don't I see the error using 2.6.5? And thanks in advance for the fix. Fixed in r6689. Maybe you have UseSmartFocus set to False on 2.6? I just switched

Re: [dabo-users] More strnage 2.7

2011-07-09 Thread John Fabiani
On Saturday, July 09, 2011 12:19:38 pm Jacek Kałucki wrote: Użytkownik John Fabiani napisał: What is UseSartFocus I don't see it in Dabo? It's very strange if you don't know what it is, because it's set by default to False. So, there shouldn't be any exception at all. I have since

Re: [dabo-users] More strnage 2.7

2011-07-09 Thread John Fabiani
On Saturday, July 09, 2011 12:25:26 pm Jacek Kałucki wrote: Użytkownik John Fabiani napisał: Now I see 2011-07-09 12:05:56 - ERROR - The 'PageTabs' control must inherit from dPage to use the UseSmartFocus feature. Now I see. I missed something, should be fine after r6691. Thanks John

[dabo-users] water marks

2011-07-06 Thread John Fabiani
Hi, Does anyone know how to add a water mark to a report? Johnf ___ Post Messages to: Dabo-users@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This

Re: [dabo-users] water marks

2011-07-06 Thread John Fabiani
On Wednesday, July 06, 2011 10:37:32 am Paul McNett wrote: PageBackground Oh thanks Johnf ___ Post Messages to: Dabo-users@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives:

Re: [dabo-users] water marks

2011-07-06 Thread John Fabiani
On Wednesday, July 06, 2011 10:39:50 am John Fabiani wrote: On Wednesday, July 06, 2011 10:37:32 am Paul McNett wrote: PageBackground Oh thanks Johnf I'm getting the string 'xpr error' printed Does that mean reportwriter can't find the pic? Johnf

Re: [dabo-users] water marks

2011-07-06 Thread John Fabiani
On Wednesday, July 06, 2011 12:58:28 pm Nate Lowrie wrote: On 7/6/11 3:27 PM, John Fabiani wrote: On Wednesday, July 06, 2011 10:39:50 am John Fabiani wrote: On Wednesday, July 06, 2011 10:37:32 am Paul McNett wrote: PageBackground Oh thanks Johnf I'm getting the string 'xpr

Re: [dabo-users] Question: Calling a textbox field from the Bizobj

2011-07-01 Thread John Fabiani
On Thursday, June 30, 2011 06:41:20 am Ruffy Collado wrote: Hello, I have got a few questions and this may end up very long so sorry. I came from the Web Application development style using PHP, a few console programming in C but never had a full blown GUI Desktop application experience.

[dabo-users] evt.EventObject not seeing new value

2011-06-29 Thread John Fabiani
Hi, Lastest Dabo, Python 2.6.5, wxPython 2.8.11, openSUSE 11.3 (also happens on windows). I have a panel that is added to a panel - then both are added to a form. So I have self.Parent.Parent.control (dDateTextBox) I have the LostFocus event bound to the control. The problem is - the value

Re: [dabo-users] evt.EventObject not seeing new value

2011-06-29 Thread John Fabiani
On Wednesday, June 29, 2011 08:43:22 am John Fabiani wrote: Hi, Lastest Dabo, Python 2.6.5, wxPython 2.8.11, openSUSE 11.3 (also happens on windows). I have a panel that is added to a panel - then both are added to a form. So I have self.Parent.Parent.control (dDateTextBox) I have

Re: [dabo-users] bizobj question

2011-06-28 Thread John Fabiani
On Tuesday, June 28, 2011 01:19:27 pm Paul McNett wrote: My dApp subclass handles getting the connection, and saves it to an attribute of the App 'dbConnection'. Then when I instantiate a bizobj it is just 'self.bizOrders = Orders(self.Application.dbConnection)'. Paul How does this help?

Re: [dabo-users] bizobj question

2011-06-28 Thread John Fabiani
On Tuesday, June 28, 2011 02:14:18 pm Paul McNett wrote: On 6/28/11 1:53 PM, John Fabiani wrote: On Tuesday, June 28, 2011 01:19:27 pm Paul McNett wrote: My dApp subclass handles getting the connection, and saves it to an attribute of the App 'dbConnection'. Then when I instantiate

Re: [dabo-users] bizobj question

2011-06-28 Thread John Fabiani
On Tuesday, June 28, 2011 02:43:00 pm Paul McNett wrote: On 6/28/11 2:33 PM, John Fabiani wrote: By global I mean that the connect instance is available everywhere from anywhere. The way you are using it. Where as if the connection was created in createBizobj it is only used

Re: [dabo-users] bizobj question

2011-06-28 Thread John Fabiani
On Tuesday, June 28, 2011 03:07:46 pm Paul McNett wrote: What is negative about storing the connection in the application instance? Right not much - in fact it's really already there. Johnf ___ Post Messages to: Dabo-users@leafe.com Subscription

[dabo-users] set focus to a cell of a grid

2011-06-18 Thread John Fabiani
Hi, I guess I'm being dumb here (not the first time) but how can I set the (or change) the focus from one cell to another cell in response to an event. I'm using a grid as a way to edit values. In one column I have a bool (checkbox) and I want the focus to move a different column when the

Re: [dabo-users] bool grid column event

2011-06-18 Thread John Fabiani
On Thursday, June 16, 2011 06:10:09 pm John Fabiani wrote: Hi, Is there a simple way to determine a bool column (a checkbox) change ? Something like an event that will trigger a function. Maybe some example code? Johnf I am sub-classing dGrid and using the afterCellEdit hook to change

Re: [dabo-users] set focus to a cell of a grid

2011-06-18 Thread John Fabiani
On Saturday, June 18, 2011 08:19:47 am John Fabiani wrote: Hi, I guess I'm being dumb here (not the first time) but how can I set the (or change) the focus from one cell to another cell in response to an event. I'm using a grid as a way to edit values. In one column I have a bool (checkbox

Re: [dabo-users] bool grid column event

2011-06-17 Thread John Fabiani
On Thursday, June 16, 2011 06:32:31 pm Paul McNett wrote: On 6/16/11 6:10 PM, John Fabiani wrote: Is there a simple way to determine a bool column (a checkbox) change ? Something like an event that will trigger a function. Maybe some example code? I see that dEvents.GridCellEdited isn't

[dabo-users] bool grid column event

2011-06-16 Thread John Fabiani
Hi, Is there a simple way to determine a bool column (a checkbox) change ? Something like an event that will trigger a function. Maybe some example code? Johnf ___ Post Messages to: Dabo-users@leafe.com Subscription Maintenance:

[dabo-users] diff between self.Record[] and self. in Report

2011-06-09 Thread John Fabiani
Hi, Is there a difference between self.Record['course_pay_sched'] and self.course_pay_sched in the report writer Even if they both work which is the proper one to use? Johnf ___ Post Messages to: Dabo-users@leafe.com Subscription Maintenance:

Re: [dabo-users] diff between self.Record[] and self. in Report

2011-06-09 Thread John Fabiani
On Thursday, June 09, 2011 09:25:53 am Paul McNett wrote: On 6/9/11 6:26 AM, John Fabiani wrote: Is there a difference between self.Record['course_pay_sched'] and self.course_pay_sched in the report writer Even if they both work which is the proper one to use? self.Record['s

[dabo-users] a spinner in a grid cell

2011-06-07 Thread John Fabiani
Hi, I wonder has anyone placed a spinner into a cell of a grid. I believe it would take a special col.CustomEditorClass. Before I start this - I was wondering if anyone had already done it. Maybe provide some hints or code. Thanks in advance, Johnf

Re: [dabo-users] dataset/sqlite changes the data type

2011-05-16 Thread John Fabiani
On Monday, May 16, 2011 08:03:49 am Ricardo Aráoz wrote: select top 1 a, b, c ,d, ..., z where a is not null, b is not null, , z is not null If there is at least one record where no field is null this should work Yes I thought of that. But it does depend on a value being in the field

Re: [dabo-users] dataset/sqlite changes the data type

2011-05-16 Thread John Fabiani
On Monday, May 16, 2011 10:39:36 am Paul McNett wrote: On 5/16/11 9:14 AM, John Fabiani wrote: Adrian and I have been discussing the issue off line. We decided the best way was for the developer to supply either hints (select fieldname '[date]', ...) or change dDataSet to accept

Re: [dabo-users] dataset/sqlite changes the data type

2011-05-13 Thread John Fabiani
On Thursday, May 12, 2011 01:21:42 pm K Peters wrote: On Thu, May 12, 2011 at 12:00 PM, John Fabiani jo...@jfcomputer.com wrote: Hi, If I do something like the following a datatype is changed from date to string depending on the first record of the dataset. fields: mustenrollby

Re: [dabo-users] dataset/sqlite changes the data type

2011-05-13 Thread John Fabiani
John, SQLite is *very* different from other SQL databases in that it uses manifest typing (see http://sqlite.org/different.html) which can cause the effects you have been observing; I would assume that Dabo takes whatever SQLite reports as data type for fields

Re: [dabo-users] dataset/sqlite changes the data type

2011-05-13 Thread John Fabiani
On Friday, May 13, 2011 07:33:30 am Adrian Klaver wrote: Have Postgres return a dummy date whenever there is a NULL Yes I thought of that too. However, there is about 500 lines of code that is depending on the Null being present (the routine was depending on Postgres data at the start). So

Re: [dabo-users] dataset/sqlite changes the data type

2011-05-13 Thread John Fabiani
On Friday, May 13, 2011 07:44:03 am Adrian Klaver wrote: On Friday, May 13, 2011 7:26:35 am John Fabiani wrote: John, I don't see how it can be fixed. If the routine requires that a record be used to determine datatype then we are stuck with the results. Even if you had

Re: [dabo-users] dataset/sqlite changes the data type

2011-05-13 Thread John Fabiani
On Friday, May 13, 2011 08:08:19 am Adrian Klaver wrote: On the surface that sounds good but I could not figure out how to do it in a dynamic way. I ran into the same problem Dabo has. How can I determine the datafields and provide the fake data for the first record. You say you are

[dabo-users] dataset/sqlite changes the data type

2011-05-12 Thread John Fabiani
Hi, If I do something like the following a datatype is changed from date to string depending on the first record of the dataset. fields: mustenrollby = date referral = date first record mustenrollby = Null referral = '2011-04-10'::date second record mustenrollby = '2011-04-24'::date referral

Re: [dabo-users] dataset/sqlite changes the data type

2011-05-12 Thread John Fabiani
On Thursday, May 12, 2011 01:23:28 pm Paul McNett wrote: On 5/12/11 1:03 PM, Paul McNett wrote: Set DataStructure explicitly. Oops, you are talking about datasets not cursors. dDataSet uses a different method to track types. Try this patch and post the output to see if my hunch is correct

Re: [dabo-users] dataset/sqlite changes the data type

2011-05-12 Thread John Fabiani
On Thursday, May 12, 2011 02:16:41 pm John Fabiani wrote: On Thursday, May 12, 2011 01:23:28 pm Paul McNett wrote: On 5/12/11 1:03 PM, Paul McNett wrote: Set DataStructure explicitly. Oops, you are talking about datasets not cursors. dDataSet uses a different method to track types

Re: [dabo-users] dataset/sqlite changes the data type

2011-05-12 Thread John Fabiani
On Thursday, May 12, 2011 03:07:49 pm Paul McNett wrote: try: + retList.append(%s %s % (safekey, ds._typeDict[self.Cursor._types[safekey] + except (KeyError, AttributeError): +

Re: [dabo-users] dataset/sqlite changes the data type

2011-05-12 Thread John Fabiani
On Thursday, May 12, 2011 03:23:46 pm John Fabiani wrote: On Thursday, May 12, 2011 03:07:49 pm Paul McNett wrote: try: + retList.append(%s %s % (safekey, ds._typeDict[self.Cursor._types[safekey] + except (KeyError

[dabo-users] strange date change on windows

2011-05-10 Thread John Fabiani
Hi, A client is reporting a change in the way the date is displayed. I confirmed it. Has anyone else seen this? dabo.settings.dateFormat =%m/%d/%Y On windows suddenly I getting 6/7/2011' and on Linux I still get 06/07/2011 Of course the display is using dDateTextBox for the control. Both

Re: [dabo-users] strange date change on windows

2011-05-10 Thread John Fabiani
On Tuesday, May 10, 2011 10:04:20 am Paul McNett wrote: On 5/10/11 6:55 AM, John Fabiani wrote: Hi, A client is reporting a change in the way the date is displayed. I confirmed it. Has anyone else seen this? dabo.settings.dateFormat =%m/%d/%Y On windows suddenly I getting

Re: [dabo-users] Application set up - intelligence - Dabo book

2011-05-10 Thread John Fabiani
On Tuesday, May 10, 2011 10:24:13 am Stef Kariotidis wrote: Thank you all for your answers and the code, it sure is a good start to look. I also vote for a ready made UI component providing intelligence features if is possible. About a Dabo book - cookbook, Packt Publishing

Re: [dabo-users] Application set up - intelligence - Dabo book

2011-05-10 Thread John Fabiani
On Tuesday, May 10, 2011 11:18:58 am Paul McNett wrote: On 5/10/11 10:49 AM, John Fabiani wrote: I have noted that Hank Fay (VFP'er) has been blogging about Dabo. You mean this? : http://blog.prosysplus.com/2010/12/reset-tools-and-frameworks.html Paul He has been interested in Dabo

Re: [dabo-users] Application set up - intelligence

2011-05-09 Thread John Fabiani
On Monday, May 09, 2011 08:58:38 am Nate Lowrie wrote: On Sun, May 8, 2011 at 16:55, Stef Kariotidis st7fa...@hotmail.com wrote: Greetings to the list from a newbie and thanks for the creation of Dabo, This is my first time posting to the list so please bare with me considering the

[dabo-users] multi-calls to callAfter

2011-05-06 Thread John Fabiani
Hi, What happens when I make several calls to dabo.ui.callAfter(someFuction). If I call the same function each time - do they queue up and then fire one at a time. Or does the framework realize that the same function was called and fire it only one time??? Johnf

Re: [dabo-users] multi-calls to callAfter

2011-05-06 Thread John Fabiani
On Friday, May 06, 2011 08:44:02 am Ed Leafe wrote: callAfterInterval() is designed to catch identical calls that occur within the specified interval, and only make one call once the interval passes Thanks that's what I needed to know. I knew there was something out there that only fired

Re: [dabo-users] update causing flashing

2011-05-04 Thread John Fabiani
On Tuesday, May 03, 2011 10:02:51 pm Paul McNett wrote: On May 3, 2011, at 20:37, John Fabiani jo...@jfcomputer.com wrote: Specifically, what is flashing? Viewing the PDF in your PDF viewer? If so, what PDF viewer are you using and what version? Looking at the report

[dabo-users] no refresh or update for scrollpanel?

2011-05-04 Thread John Fabiani
Hi, I have need to create dynamic controls on a scroll panel. But I can not update the display with new controls - they are not visable. I have tried self.update() self.refresh() where self = the scroll panel If I update the form containing the scroll panel the display is not updated.

<    1   2   3   4   5   6   7   8   9   10   >