Re: [dabo-users] Dabo! Everyone's answer to my question!

2012-06-05 Thread John Fabiani
On 06/05/2012 06:31 PM, Simon Cropper wrote: > On 06/06/12 11:22, John Fabiani wrote: >> On 06/05/2012 06:14 PM, John Fabiani wrote: >>> On 06/05/2012 05:47 PM, Simon Cropper wrote: >>>> On 06/06/12 10:28, John Fabiani wrote: >>>>> First let's con

Re: [dabo-users] Dabo! Everyone's answer to my question!

2012-06-05 Thread John Fabiani
On 06/05/2012 06:14 PM, John Fabiani wrote: > On 06/05/2012 05:47 PM, Simon Cropper wrote: >> On 06/06/12 10:28, John Fabiani wrote: >>> First let's confirm that you are setup correctly. Please provide your >>> platform, python and wypython versions, along wi

Re: [dabo-users] Dabo! Everyone's answer to my question!

2012-06-05 Thread John Fabiani
On 06/05/2012 05:47 PM, Simon Cropper wrote: > On 06/06/12 10:28, John Fabiani wrote: >> First let's confirm that you are setup correctly. Please provide your >> platform, python and wypython versions, along with the dabo version. > Platform: Ubuntu 11.10 > Python: 2

Re: [dabo-users] Dabo! Everyone's answer to my question!

2012-06-05 Thread John Fabiani
On 06/05/2012 05:24 PM, Simon Cropper wrote: > On 06/06/12 10:10, Paul McNett wrote: >> On 6/5/12 4:49 PM, Simon Cropper wrote: >>> Well I'm here. I am willing to be shown... >>> >>> So, I will throw up an apparently simple challenge. John, show me how

Re: [dabo-users] Dabo! Everyone's answer to my question!

2012-06-05 Thread John Fabiani
ity. > > I even point out that my correspondence with the developers indicate > that no major development to the code is likely. Still they say Dabo! Dabo! > > So while trying to find some code to understand how wxGrid works in > wxPython the same mantra permeated through my

Re: [dabo-users] Need "SetCellSize" in dGrid

2012-05-30 Thread John Fabiani
On Wednesday, May 30, 2012 10:13:13 PM Anton Hofer wrote: > Dear Community, > > a few month ago i have searched for a alternative programming > environment for Visual FoxPro and found dabo. In my little FoxPro-app i > have a grid where some cells overlap two or more columns. In the Visual > FoxPro

Re: [dabo-users] Dabo Class Designer other than Forms

2012-05-30 Thread John Fabiani
On Wednesday, May 30, 2012 03:47:43 PM Allan Brooke wrote: > Object Info > Editor Code > + Other window > Disappear I'm on openSUSE 12.1, python 2.7.x, wxPython 2.8.12.1, latest Dabo (svn). I do not see the anything disappear (that assumes that I am following your directions correctly). Johnf ___

Re: [dabo-users] Precision Value in Grid Column

2012-05-15 Thread John Fabiani
On Tuesday, May 15, 2012 12:14:25 PM John Fabiani wrote: > On Tuesday, May 15, 2012 11:46:05 AM John Fabiani wrote: > > On Tuesday, May 15, 2012 01:21:43 PM Ed Leafe wrote: > > > On May 15, 2012, at 1:18 PM, Ed Leafe wrote: > > > >> File "/home/johnf/dabo

Re: [dabo-users] Precision Value in Grid Column

2012-05-15 Thread John Fabiani
On Tuesday, May 15, 2012 11:46:05 AM John Fabiani wrote: > On Tuesday, May 15, 2012 01:21:43 PM Ed Leafe wrote: > > On May 15, 2012, at 1:18 PM, Ed Leafe wrote: > > >> File "/home/johnf/dabo/dabo/ui/uiwx/dGrid.py", line 1384, in > > >> _setPrecision>&

Re: [dabo-users] Precision Value in Grid Column

2012-05-15 Thread John Fabiani
On Tuesday, May 15, 2012 01:21:43 PM Ed Leafe wrote: > On May 15, 2012, at 1:18 PM, Ed Leafe wrote: > >> File "/home/johnf/dabo/dabo/ui/uiwx/dGrid.py", line 1384, in > >> _setPrecision>> > >> dabo.ui.callAfterInterval(50, self.Parent.refresh) > >> > >> AttributeError: 'NoneType' object has no a

Re: [dabo-users] Precision Value in Grid Column

2012-05-15 Thread John Fabiani
On Tuesday, May 15, 2012 10:59:24 AM John Fabiani wrote: > On Tuesday, May 15, 2012 12:29:57 PM Ed Leafe wrote: > > On May 15, 2012, at 9:33 AM, RUSSELL Thomas wrote: > > > My problem is that the data precision is correct but the data seems > > > to > > > be

Re: [dabo-users] Precision Value in Grid Column

2012-05-15 Thread John Fabiani
On Tuesday, May 15, 2012 12:29:57 PM Ed Leafe wrote: > On May 15, 2012, at 9:33 AM, RUSSELL Thomas wrote: > > My problem is that the data precision is correct but the data seems to > > be rounded in value instead of what the real value is. > I just committed a fix. Grab the latest from SVN an

Re: [dabo-users] Precision Value in Grid Column

2012-05-15 Thread John Fabiani
On Tuesday, May 15, 2012 08:58:52 AM John Fabiani wrote: > On Tuesday, May 15, 2012 08:45:14 AM Paul McNett wrote: > > On 5/15/12 7:45 AM, Ed Leafe wrote: > > > Oh, OK, I totally misunderstood the problem. I thought you were > > > not > > > able to see the

Re: [dabo-users] Precision Value in Grid Column

2012-05-15 Thread John Fabiani
On Tuesday, May 15, 2012 08:45:14 AM Paul McNett wrote: > On 5/15/12 7:45 AM, Ed Leafe wrote: > > Oh, OK, I totally misunderstood the problem. I thought you were not > > able to see the number of decimal places set in the Precision > > property. But it seems to be rounding the values wh

Re: [dabo-users] Dabo "Best" OS

2012-05-14 Thread John Fabiani
On Monday, May 14, 2012 12:15:44 PM Nathan Lowrie wrote: > So, my recommendation is if you are spinning up VM's for the class, then > spin up OS X VM's Off topic - have you been able to setup a VM on anything (other than a MAC) that will run Mac OS. If so which VM. Or are you saying use a Mac a

Re: [dabo-users] Precision Value in Grid Column

2012-05-14 Thread John Fabiani
On Monday, May 14, 2012 02:27:04 PM RUSSELL Thomas wrote: > Has anyone else loaded data into a grid with dabo that was more than 2 data > points past the decimal? > > I still cannot diagnose my issue or find a way to alleviate it without > really just redoing a grid myself in plain wx which is moo

Re: [dabo-users] Dabo "Best" OS

2012-05-14 Thread John Fabiani
On Monday, May 14, 2012 09:19:15 AM Allan Brooke wrote: > I am thinking of trying to run Python Classes for beginners similar to the > Boston Workshops but for all genders here in Cape Town. I use Ubuntu for my > python work. Most people are more used to windows (XP) and I know no one > with a Mac

Re: [dabo-users] Dabo on Ubuntu 12.04 64 bit

2012-05-11 Thread John Fabiani
On Thursday, May 10, 2012 04:45:42 PM Ed Leafe wrote: > On May 10, 2012, at 4:41 PM, Brandon Napier wrote: > > It is at the very top of the ChangeLog file that is in the root dabo > > folder. Glad to know that using Python 2.7 is not an issue. > > Paul, is there a specific reason you added t

Re: [dabo-users] postgres pkid before commit

2012-05-04 Thread John Fabiani
On Friday, May 04, 2012 03:06:30 PM Vineet Deodhar wrote: > Anyway, I am using MySQL and I am very much comfortable with it. > > -- Vineet\ Tell me how MySQL does it differently? Johnf ___ Post Messages to: Dabo-users@leafe.com Subscription Maintenan

Re: [dabo-users] Migration from dBaseIII+ & SQL/Client interaction

2012-05-04 Thread John Fabiani
On Thursday, May 03, 2012 08:07:00 PM Bill House wrote: > Thanks for taking a look at this guys. > > The file is sorted(indexed) md5sum + path + file_name > > Therefore the longer path name (and more deeply nested) will be the last > one and therefore the one retained. > (That was my plan anyway.

Re: [dabo-users] Migration from dBaseIII+ & SQL/Client interaction

2012-05-03 Thread John Fabiani
On Thursday, May 03, 2012 09:05:38 PM Ricardo Araoz wrote: > El 03/05/12 10:05, John Fabiani escribió: > > On Thursday, May 03, 2012 07:15:46 AM Ricardo Araoz wrote: > >> Don't know if I understood what you want. I think you want to get rid > >> of > >> dup

Re: [dabo-users] Importing data to linked tables

2012-05-03 Thread John Fabiani
On Thursday, May 03, 2012 11:05:23 AM Paul McNett wrote: > We were talking about retrieving the pk before biz.save(), which is before > the database knows anything about the new record. I was just commenting on your post not on Dabo. Postgres can provide the PK from a record before it is committ

Re: [dabo-users] Importing data to linked tables

2012-05-03 Thread John Fabiani
On Thursday, May 03, 2012 10:04:40 AM Paul McNett wrote: > You can't ask the database for the last insert id until the database has > inserted the record. The database won't insert the record until you call > biz.save(), which you don't want to do inside the loop. You also don't want > to guess at

Re: [dabo-users] Migration from dBaseIII+ & SQL/Client interaction

2012-05-03 Thread John Fabiani
On Thursday, May 03, 2012 07:15:46 AM Ricardo Araoz wrote: > El 02/05/12 11:37, John Fabiani escribió: > > On Wednesday, May 02, 2012 09:13:35 AM Bill House wrote: > >> Hello all, > >> > >> This is a generic question, but I am trying to learn enough abo

Re: [dabo-users] Problems with Ubuntu 12.04 and Class Designer

2012-05-02 Thread John Fabiani
On Wednesday, May 02, 2012 03:34:12 PM Allan Brooke wrote: > Hi my name is Allan > Thank you for a wonderful product it appears truly amazing from the videos > > I have just installed Ubuntu 12.04 as I was using 10.04 > > Details from Dabo about from Class Designer > > (could not copy and paste)

Re: [dabo-users] Migration from dBaseIII+ & SQL/Client interaction

2012-05-02 Thread John Fabiani
On Wednesday, May 02, 2012 09:13:35 AM Bill House wrote: > Hello all, > > This is a generic question, but I am trying to learn enough about Dabo > to use it and I need to understand how things work before I can > proceed. I am using postgresql 9.1 and psycopg2 2.4.5. and python 2.7 > on OpenSUSE

Re: [dabo-users] help with checkbox in dgrid

2012-04-17 Thread John Fabiani
On Tuesday, April 17, 2012 03:11:25 AM Cheryl wrote: > Cheryl writes: > > the datatype in Postgres is boolean > > the code that I should have posted originally datatype = "bool", but it > didn't work, so I tried "integer", but that didn't work either. > > def afterInit(self): > col = dabo

Re: [dabo-users] help with checkbox in dgrid

2012-04-16 Thread John Fabiani
On Monday, April 16, 2012 10:13:14 PM Cheryl wrote: > Cheryl writes: > > > I tried adding the following to the dGrid afterInit method. > > def afterInit(self): > col = dabo.ui.dColumn(self, Name="key_field", Order=10, > DataField="key_field",DataType="integer", Width=60, >

Re: [dabo-users] Add From Data Environment (Not Responding)

2012-04-12 Thread John Fabiani
On Thursday, April 12, 2012 01:32:34 PM John Fabiani wrote: > On Thursday, April 12, 2012 06:46:41 PM Cheryl wrote: > > I am a brand new user to dabo. > > First, I used the runtime installer yesterday, and then removed it and > > did the svn install on Windows XP. > >

Re: [dabo-users] Add From Data Environment (Not Responding)

2012-04-12 Thread John Fabiani
On Thursday, April 12, 2012 06:46:41 PM Cheryl wrote: > I am a brand new user to dabo. > First, I used the runtime installer yesterday, and then removed it and did > the svn install on Windows XP. > I have installed the latest svn version of dabo on Windows XP, along with > Python2.6, PIL1.1.7, psy

[dabo-users] the use of DataStructure

2012-04-06 Thread John Fabiani
Hi, As I understand it, the only overhead that occurs from NOT including the DataStructure for a bizobj happens the first time a query occurs against a table. The first time a bizobj query occurs - Dabo must query the database to determine the data types. Under what circumstances is a secon

[dabo-users] python datatype error rev 7119

2012-04-06 Thread John Fabiani
Starting at 7119 I'm getting an error from dCursorMixin -> _correctFieldTypes if isinstance(field_val, pythonType): # No conversion needed. return field_val self._types[field_name] returns None. Infact self._types shows that all fi

Re: [dabo-users] "Really" dynamic properties?

2012-03-31 Thread John Fabiani
On Saturday, March 31, 2012 04:04:24 AM OKB wrote: > John Fabiani wrote: > > I guess I'm simple minded here! What is wrong with binding the > > control? > > > > object.bindEvent(dEvents., self._function) > > or > > .Bind(wx., fun

Re: [dabo-users] "Really" dynamic properties?

2012-03-30 Thread John Fabiani
On Friday, March 30, 2012 11:26:21 PM OKB wrote: > Paul McNett wrote: > > On 3/30/12 2:26 PM, OKB (not okblacke) wrote: > >> It seems that the various Dynamic* properties are > >> only > >> updated when > >> > >> update() is called. I'm not sure exactly when this is.

Re: [dabo-users] "Really" dynamic properties?

2012-03-30 Thread John Fabiani
On Friday, March 30, 2012 09:26:39 PM OKB wrote: > It seems that the various Dynamic* properties are only updated when > update() is called. I'm not sure exactly when this is. But my question > is, is there any way to get "truly dynamic" (i.e., instant response) > behavior from these proper

Re: [dabo-users] Tip: Justified-alignment of 2 controls in a horizontal dSizer

2012-03-22 Thread John Fabiani
On Thursday, March 22, 2012 01:05:12 PM Ed Leafe wrote: > On Mar 22, 2012, at 12:57 PM, Paul McNett wrote: > > Simply append a horizontal spacer and set its proportion to 1 to tell it > > to take all remaining available space. I guess I'd missed that spacers > > could have proportion set. > W

Re: [dabo-users] dNumeric issue

2012-03-22 Thread John Fabiani
On Thursday, March 22, 2012 10:10:49 AM Paul McNett wrote: > On 3/22/12 9:00 AM, Jacek Kałucki wrote: > > Ok, I'll try to look deeper into this tonight. > > I added a test for the case so you can run dNumericBox.py and reproduce it > readily. Perhaps we simply haven't told wxPython about the corre

Re: [dabo-users] dNumeric issue

2012-03-22 Thread John Fabiani
On Thursday, March 22, 2012 08:55:26 AM Jacek Kałucki wrote: > Użytkownik John Fabiani napisał: > > OpenSuse 12.1, python 2.7, wxpython 2.8.11, latest Dabo. > > Hi. > > It's probably wxPython issue. > I don't have such problems on 2.8.12.1. > Can you upg

Re: [dabo-users] dNumeric issue

2012-03-22 Thread John Fabiani
On Thursday, March 22, 2012 08:55:26 AM Jacek Kałucki wrote: > Użytkownik John Fabiani napisał: > > OpenSuse 12.1, python 2.7, wxpython 2.8.11, latest Dabo. > > Hi. > > It's probably wxPython issue. > I don't have such problems on 2.8.12.1. > Can you u

[dabo-users] dNumeric issue

2012-03-19 Thread John Fabiani
OpenSuse 12.1, python 2.7, wxpython 2.8.11, latest Dabo. I get an traceback when I enter a number in the control. I'm trying to use the dNumeric to enter in integers using the below code. gs.append(dabo.ui.dNumericBox(self, RegID = 'outQtyID',AutoWidth = True, DecimalWidth = 0, Alignment = 'l

Re: [dabo-users] Subclass Dabo objects.

2012-03-07 Thread John Fabiani
On Wednesday, March 07, 2012 08:35:53 AM Paul McNett wrote: > I prefer the ** way because it is more Pythonic, shorter to write, and > easier to immediately understand. Yes easier to understand - but harder to follow. When I review my code where I have used **kargs I always have to remind my se

Re: [dabo-users] Subclass Dabo objects.

2012-03-06 Thread John Fabiani
On Tuesday, March 06, 2012 01:48:26 PM Ed Leafe wrote: > On Mar 6, 2012, at 1:27 PM, Paul McNett wrote: > > The examples you cite do not, in and of themselves, suggest making a > > subclass in Dabo, although they sure did in VFP. > > While it's certainly easier to do in Dabo, I tend to be la

Re: [dabo-users] Subclass Dabo objects.

2012-03-06 Thread John Fabiani
On Tuesday, March 06, 2012 11:07:33 AM STyler wrote: > This mode is also > recommended working with Dabo? I don't think so! I use Dabo controls directly all the time. There are times I have created sub-classes for a few special reasons. But generally I use Dabo's classes. Johnf

Re: [dabo-users] multiple result sets. Is it possible?

2012-03-03 Thread John Fabiani
On Friday, March 02, 2012 05:37:40 PM Adrian Klaver wrote: > On Friday, March 02, 2012 4:54:35 pm Ed Leafe wrote: > > On Mar 2, 2012, at 6:42 PM, Adrian Klaver wrote: > > > The query passed to the cursor would do the processing on the server > > > and return the filtered down results back to Dabo.

Re: [dabo-users] multiple result sets. Is it possible?

2012-03-02 Thread John Fabiani
On Friday, March 02, 2012 08:57:30 PM Ricardo Araoz wrote: > El 02/03/12 20:24, Paul McNett escribió: > > On 3/2/12 2:58 PM, Ricardo Araoz wrote: > >> Let's say your large SQL statement has millions of rows and you want > >> to > >> group those rows in one data set and you want a subset of those ro

Re: [dabo-users] multiple result sets. Is it possible?

2012-03-02 Thread John Fabiani
On Friday, March 02, 2012 07:31:42 PM Ricardo Araoz wrote: > El 02/03/12 19:09, Ed Leafe escribió: > > On Mar 2, 2012, at 4:06 PM, Ricardo Araoz wrote: > >> I need to send a user defined query to the dbms and recieve more than > >> one result set. In fox I would send the query and recieve "cursor",

Re: [dabo-users] Grid from SQLite Views

2012-03-02 Thread John Fabiani
On Friday, March 02, 2012 10:31:06 PM Dewald Jacobs wrote: > On Mar 2, 2012, at 10:22 PM, John Fabiani wrote: > > On Friday, March 02, 2012 10:12:55 PM Dewald Jacobs wrote: > >> On Mar 2, 2012, at 9:04 PM, Paul McNett wrote: > >>> On 3/2/12 10:55 AM, Paul McNett wr

Re: [dabo-users] Grid from SQLite Views

2012-03-02 Thread John Fabiani
", line > > 619, in __sortRows> > > self.__unsortedRows.append(row[kf]) > > > > KeyError: u'id' > > }}} > > > > I messed up writing the script and had the KeyField defined in the > > bizobj as "id" and not "Id&

Re: [dabo-users] Grid from SQLite Views

2012-03-02 Thread John Fabiani
On Friday, March 02, 2012 11:04:50 AM Paul McNett wrote: > On 3/2/12 10:55 AM, Paul McNett wrote: > > When confronted by things like this, I like to reduce them down with as > > few variables as possible, in a single, simple script. Please look at > > this script and run it, which seems to prove th

Re: [dabo-users] Grid from SQLite Views

2012-03-02 Thread John Fabiani
On Friday, March 02, 2012 12:35:51 PM Ed Leafe wrote: > On Mar 2, 2012, at 12:10 PM, Dewald Jacobs wrote: > > It is capitalized. Is that a problem? I have been working with this > > database for a while and my tables all work in dabo with capitalized > > columns. The two tables that I use for the V

Re: [dabo-users] Grid from SQLite Views

2012-03-02 Thread John Fabiani
On Friday, March 02, 2012 07:33:00 PM Dewald Jacobs wrote: > Hi, > > I tried that and I can now successfully choose a View from "Add controls > from Data Environment" in class designer. The column names also show up in > the grid. The app runs, but I get the following traceback: > > Traceback (mo

Re: [dabo-users] Grid from SQLite Views

2012-03-02 Thread John Fabiani
On Friday, March 02, 2012 07:27:41 AM John Fabiani wrote: > On Friday, March 02, 2012 01:56:16 PM Dewald Jacobs wrote: > > Hi, > > > > I have a SQLite database with a View (created with the command CREATE > > VIEW, just to be clear) that was created by combining 2 t

Re: [dabo-users] Grid from SQLite Views

2012-03-02 Thread John Fabiani
On Friday, March 02, 2012 01:56:16 PM Dewald Jacobs wrote: > Hi, > > I have a SQLite database with a View (created with the command CREATE VIEW, > just to be clear) that was created by combining 2 tables plus and an added > column to compute JULIANDAY. How would I go about adding this View in a >

Re: [dabo-users] Modifying field as part of verifyRecord or beforeSave?

2012-02-16 Thread John Fabiani
On Thursday, February 16, 2012 10:47:25 AM Adrian Klaver wrote: > I generally put this in the database. I use Postgres so I use a > combination of a default value and a UPDATE trigger. For MySQL there are > some builtins for timestamp that do this; > > http://dev.mysql.com/doc/refman/5.0/en/times

Re: [dabo-users] vfp CA & dabo

2012-02-15 Thread John Fabiani
On Wednesday, February 15, 2012 03:49:36 PM Vineet Deodhar wrote: > > Message: 8 > > > >> Date: Thu, 9 Feb 2012 10:50:56 -0600 > >> From: Ed Leafe > >> > >> On Feb 9, 2012, at 10:28 AM, Vineet Deodhar wrote: > >> > To make my question more clear, pl. consider the vfp cursor > >> > adapter. > >>

Re: [dabo-users] how to make dabo understand whether to delete/update/insert

2012-02-09 Thread John Fabiani
On Thursday, February 09, 2012 11:26:50 AM Dennis Lee Bieber wrote: > My apologies, I don't have any experience directly with Dabo (like > Django, it's too much of a moving target for someone to dabble with in > their spare time -- and unlike Django, it hasn't even the benefit of > rapidly

Re: [dabo-users] how to make dabo understand whether to delete/update/insert

2012-02-09 Thread John Fabiani
On Thursday, February 09, 2012 09:40:46 AM Ed Leafe wrote: > There already is a delete() method in the bizobj; you should not be > modifying that. Instead, take advantage of beforeDelete() and afterDelete() > to augment it as needed. Your right - I mis-spoke I do in fact use the afterDelet

Re: [dabo-users] how to make dabo understand whether to delete/update/insert

2012-02-09 Thread John Fabiani
On Thursday, February 09, 2012 07:58:21 PM Vineet Deodhar wrote: > Consider a setup like this: > > ParentTable: (parent_id, name, occu) > ChildTable: (child_id, parent_id, name, qual) > GrandChildTable: (gchild_id, child_id, name, age) > > Table data is like this: > >

Re: [dabo-users] Python 2.7

2012-02-06 Thread John Fabiani
On Tuesday, February 07, 2012 04:27:07 AM OKB wrote: > I seem to recall seeing some discussion a long time ago about how > there were problems using Dabo with Python 2.7. Is this still the case? > What is the official status of Dabo vis-a-vis Python 2.7? Works for me on windows and linux.

Re: [dabo-users] global (app) keyboard events?

2012-02-06 Thread John Fabiani
On Monday, February 06, 2012 04:19:42 PM Jacek Kałucki wrote: > Użytkownik John Fabiani napisał: > > Interesting code. What platform required the code? While working with > > barcode readers in the past (I have only used symbol) they just acted as > > a keyboard. I did not

Re: [dabo-users] global (app) keyboard events?

2012-02-06 Thread John Fabiani
On Sunday, February 05, 2012 08:33:38 PM Jacek Kałucki wrote: > Użytkownik Jacek Kałucki napisał: > > Here is link to sample code that handles barcode reader > > output:http://dabo.codepad.org/zx8I2NXN > Sorry, correct link here: http://dabo.codepad.org/XcamafIR > I missed dApp.UIAppClass property

Re: [dabo-users] global (app) keyboard events?

2012-02-04 Thread John Fabiani
On Saturday, February 04, 2012 05:48:38 PM Jacek Kałucki wrote: > I'm using this method to handle barcode reader output in my applications. That sounds interesting - if you don't mind tells more about what you are doing. Johnf ___ Post Messages to: Dab

Re: [dabo-users] how to determine if new record

2012-01-24 Thread John Fabiani
On Tuesday, January 24, 2012 10:09:13 AM John Fabiani wrote: > Hi, > With all the changes to isAnyChanged etc.. > I'm struck on how to determine if I've added an unsaved new record. > > Johnf I just updated and IsAdding is now returning true. S

[dabo-users] how to determine if new record

2012-01-24 Thread John Fabiani
Hi, With all the changes to isAnyChanged etc.. I'm struck on how to determine if I've added an unsaved new record. Johnf ___ Post Messages to: Dabo-users@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archiv

Re: [dabo-users] need Help

2012-01-23 Thread John Fabiani
On Sunday, January 22, 2012 10:54:59 PM Pankaj Yande wrote: > I am very new to python and dabo world. >I want to convert my vb6 database application to dabo frame work. using >OS: Windows XP >Python 2.6 >dabo framework >the problem is : >the dabo framework uses (app wiz or

Re: [dabo-users] Border around dLabel

2012-01-23 Thread John Fabiani
On Monday, January 23, 2012 05:35:24 AM OKB wrote: > Hi, I'm trying to create a dLabel that has a border around it. At > first I thought the BorderColor, BorderStyle, etc. properties would do > this, but they don't seem to work the way I'd hoped. The border seems > to be applied "inside" th

Re: [dabo-users] pycon 2010 tutorial - problem

2012-01-20 Thread John Fabiani
On Friday, January 20, 2012 08:53:22 AM Paul McNett wrote: > On 1/18/12 8:32 AM, cccomp...@gmail.com wrote: > > I'm using Ubuntu 11.04, GNOME 2.32.1, Python version 2.7.1, Dabo version > > 0.9.4 revision 7048, UI version 2.8.11.0 on wxGTK. > > Could you try UI version 2.8.12.x, and/or Python 2.6.x

Re: [dabo-users] DaboDemo traceback

2012-01-12 Thread John Fabiani
On Thursday, January 12, 2012 09:52:29 AM Ed Leafe wrote: > On Jan 12, 2012, at 9:16 AM, cccomp...@gmail.com wrote: > > Traceback (most recent call last): > > File > > "/usr/lib/python2.7/dist-packages/wx-2.8-gtk2-unicode/wx/_core.py", > > > > line 14636, in > > > >lambda event: event.call

Re: [dabo-users] sizer 1/2 line?

2012-01-10 Thread John Fabiani
On Tuesday, January 10, 2012 05:38:25 PM Paul McNett wrote: > This was my idea, too. You could also do it with absolute position within an > embedded vertical sizer: (untested) I did try the valign = 'top' and the other valign = 'bottom' not much difference. I ended up using fix positions for

[dabo-users] sizer 1/2 line?

2012-01-10 Thread John Fabiani
Hi, I actually don't really know how to explain this but say 1/2 line. I'd like to add a few controls (without using fix position) that are 1/2 a line a part (in vert) to a panel. I'm converting an old VFP form and client noticed that I had placed the controls on the same row/line on the Dabo

Re: [dabo-users] pymssql is it working?

2012-01-10 Thread John Fabiani
On Tuesday, January 10, 2012 12:00:25 PM pyt...@bdurham.com wrote: > Ed, > > > Is there a dbapi-compliant ODBC class? > > Yes. There are several. > > I think pyodbc is the way to go (dbapi compliant, MIT license, cross > platform, Python 2.x/3.2, etc) > > http://code.google.com/p/pyodbc > http:

Re: [dabo-users] pymssql is it working?

2012-01-10 Thread John Fabiani
On Tuesday, January 10, 2012 12:00:25 PM pyt...@bdurham.com wrote: > Ed, > > > Is there a dbapi-compliant ODBC class? > > Yes. There are several. > > I think pyodbc is the way to go (dbapi compliant, MIT license, cross > platform, Python 2.x/3.2, etc) > > http://code.google.com/p/pyodbc > http:

Re: [dabo-users] pymssql is it working?

2012-01-10 Thread John Fabiani
On Tuesday, January 10, 2012 04:13:38 PM Jacek Kałucki wrote: > Użytkownik John Fabiani napisał: > > If there happens to be a problem please explain the issues. I'll set > > something up and attempt to get it fixed. Of course if it's working > > I'll > &g

[dabo-users] pymssql is it working?

2012-01-10 Thread John Fabiani
Hi guys, A poster on "Universal Thread" (a VFP forum) has suggested that the pymssql is not working with Dabo. Can anyone confirm that there is a problem? I don't currently have access to a MsSQL server or I'd do it myself. If there happens to be a problem please explain the issues. I'll set

Re: [dabo-users] grid sizing

2012-01-05 Thread John Fabiani
On Thursday, January 05, 2012 02:19:01 PM Paul McNett wrote: > On 1/5/12 2:12 PM, John Fabiani wrote: > > Nobody has any thoughts on this - it is becoming an issue. As I expand > > the several of the columns the other columns contract. The scrollbar > > appears then

Re: [dabo-users] grid sizing

2012-01-05 Thread John Fabiani
On Thursday, January 05, 2012 11:14:20 AM John Fabiani wrote: > Hi, > My grids are normally created as follows: > class ProductGrid(dabo.ui.dGrid): > def afterInit(self): > self.super() > self.HeaderFontBold = True > self.R

[dabo-users] grid sizing

2012-01-05 Thread John Fabiani
Hi, My grids are normally created as follows: class ProductGrid(dabo.ui.dGrid): def afterInit(self): self.super() self.HeaderFontBold = True self.RegID = "productgridID" self.SelectionMode = 'Row' self.AlternateRowColoring = True self.MovableColum

Re: [dabo-users] Pass parameters to main form

2012-01-02 Thread John Fabiani
On Monday, January 02, 2012 07:16:24 AM Nate Lowrie wrote: > On 1/1/2012 9:00 PM, Ed Leafe wrote: > > On Jan 1, 2012, at 7:22 PM, OKB (not okblacke) wrote: > >>What you mention about passing information before the form > >>instance > >> > >> is created, though, makes me won

Re: [dabo-users] Report: Break group on more than one variable

2012-01-02 Thread John Fabiani
On Monday, January 02, 2012 06:45:38 AM Paul McNett wrote: > On 1/2/12 4:21 AM, Nate Lowrie wrote: > > On 12/30/2011 12:30 PM, Paul McNett wrote: > >> > On 12/29/11 11:57 AM, Nate Lowrie wrote: > >>> >> Also, can I repeat a certain group a set number of times > >>> >> based > >>> >> on a field?

Re: [dabo-users] Reports - one to many

2011-12-31 Thread John Fabiani
On Sunday, January 01, 2012 08:56:46 AM James Bull wrote: > Thank you for your help, > I have tinkered with grouping but never quite got what I was looking for, > probably not understanding groups properly. Have done as you suggested, > this results in an appropriate list for allergies, but the med

Re: [dabo-users] Reports - one to many

2011-12-29 Thread John Fabiani
On Thursday, December 29, 2011 11:59:18 AM James Bull wrote: > Thanks, I have created the sql manually and although not an experienced user > of sql think I am on the right track. The UI displays exactly want I want > by using a number of grids to display the child tables of allergies and > medicat

Re: [dabo-users] Reports - one to many

2011-12-28 Thread John Fabiani
On Thursday, December 29, 2011 11:10:10 AM James Bull wrote: > Wondering if I could get some pointers. > I have tables setup as > Parent(person) > -ChildA(many: medications) > -ChildB(many: allergies) > The report I am trying to produce aims to have Parent details

Re: [dabo-users] something wrong with bizobj.moveToPK()

2011-12-24 Thread John Fabiani
On Sunday, December 25, 2011 12:19:25 AM Jacek Kałucki wrote: > Użytkownik Jacek Kałucki napisał: > > What happens after saving it: > > self.pwvoyage.save() > > > > self.pwvoyage.moveToPK(KeyValue) > > > > ? > > I reposted proper code on codepad: http://dabo.codepad.org/FV231hK

[dabo-users] something wrong with bizobj.moveToPK()

2011-12-24 Thread John Fabiani
Hi, I was doing a little work today and discovered a bug (??) with moveToPK() - It appears that it does not completely retrieve all the data The table in question is a child and I'm trying to move to a record when the users select a different PK and refresh the screen with the new child dat

Re: [dabo-users] simple way to maintain form size

2011-12-22 Thread John Fabiani
On Thursday, December 22, 2011 08:13:21 PM Jacek Kałucki wrote: > Użytkownik John Fabiani napisał: > > Is there a simple way to maintain individual form sizes? > > Did you try to set individual Name property for each form? thanks - that did th

[dabo-users] simple way to maintain form size

2011-12-22 Thread John Fabiani
Hi, Normally, it is not a big deal. But a client has asked me to maintain the individual window/form size. What is happening is the user re-sizes one window/form and the closes it. When he re-opens the same form it's just fine. But when he opens a different form the size of the new form matc

Re: [dabo-users] drag and drop scheduler/calendar

2011-12-20 Thread John Fabiani
On Wednesday, December 21, 2011 01:03:48 AM Jacek Kałucki wrote: > Użytkownik John Fabiani napisał: > > Hi, > > It looks like I may have to develop a drag and drop scheduler/calendar > > for a client. Does anybody have something that will provide a starting > > point.

Re: [dabo-users] drag and drop scheduler/calendar

2011-12-19 Thread John Fabiani
On Monday, December 19, 2011 09:12:09 AM Ed Leafe wrote: > On Dec 19, 2011, at 9:06 AM, John Fabiani wrote: > > It looks like I may have to develop a drag and drop scheduler/calendar > > for a client. Does anybody have something that will provide a starting > > point. I jus

[dabo-users] drag and drop scheduler/calendar

2011-12-19 Thread John Fabiani
Hi, It looks like I may have to develop a drag and drop scheduler/calendar for a client. Does anybody have something that will provide a starting point. I just need to associate a name with a time slot - drag from the name list to the calendar. Thanks in advance, Johnf _

Re: [dabo-users] AppWizard Request

2011-12-08 Thread John Fabiani
On Thursday, December 08, 2011 03:24:44 PM Paul McNett wrote: > On 12/8/11 2:18 PM, Rand Batchelder wrote: > > I am using the appwizard with MS SQL. > > > > I would like to build an app from a View, but the appwizard only lists > > available tables. Is this doable ? > > Sure, we just need to fix

Re: [dabo-users] Production problem with granchild bizobj

2011-12-07 Thread John Fabiani
On Wednesday, December 07, 2011 08:07:22 AM Paul McNett wrote: > On 12/7/11 7:55 AM, John Fabiani wrote: > > On Wednesday, December 07, 2011 06:19:52 AM Paul McNett wrote: > >> On 12/7/11 5:44 AM, Nate Lowrie wrote: > >>>>> se

Re: [dabo-users] Production problem with granchild bizobj

2011-12-07 Thread John Fabiani
On Wednesday, December 07, 2011 06:19:52 AM Paul McNett wrote: > On 12/7/11 5:44 AM, Nate Lowrie wrote: > >> > self.VirtualFields["myfield"] = {"func": > >> > self.getMyField, "requery_children": True}>> > > >> > The second thing could be an unintended consequence of recent > >>

Re: [dabo-users] fastest way to determine if there's a change

2011-11-30 Thread John Fabiani
On Wednesday, November 30, 2011 11:40:22 AM Paul McNett wrote: > On 11/30/11 11:38 AM, John Fabiani wrote: > > Is it possible that there could a timing issue using the above method? > > It seems that return value is not always true after editing a value on > > the form. >

Re: [dabo-users] fastest way to determine if there's a change

2011-11-30 Thread John Fabiani
On Tuesday, November 29, 2011 07:19:08 PM Ed Leafe wrote: > On Nov 29, 2011, at 6:00 PM, Paul McNett wrote: > > class MyForm(...): > > def isAnyChanged(self): > > for biz in self.bizobjs: ## you need to manually put your > > bizobjs in here> > > if biz.isAnyChanged(): > >

Re: [dabo-users] fastest way to determine if there's a change

2011-11-29 Thread John Fabiani
On Tuesday, November 29, 2011 07:19:08 PM Ed Leafe wrote: > On Nov 29, 2011, at 6:00 PM, Paul McNett wrote: > > class MyForm(...): > > def isAnyChanged(self): > > for biz in self.bizobjs: ## you need to manually put your > > bizobjs in here> > > if biz.isAnyChanged(): > >

Re: [dabo-users] fastest way to determine if there's a change

2011-11-29 Thread John Fabiani
On Tuesday, November 29, 2011 02:59:14 PM Paul McNett wrote: > On 11/29/11 2:44 PM, John Fabiani wrote: > > Paul just posted 6991 getChangeStatus() > > > > What if I need to know if any biz object has changed? > > What would be the fastest way to deter

[dabo-users] fastest way to determine if there's a change

2011-11-29 Thread John Fabiani
Hi, Paul just posted 6991 getChangeStatus() What if I need to know if any biz object has changed? What would be the fastest way to determine if there were a change. Johnf ___ Post Messages to: Dabo-users@leafe.com Subscription Maintenance: http://leafe.

Re: [dabo-users] Workaround for "One Child : Many Parents" ?

2011-11-25 Thread John Fabiani
On Friday, November 25, 2011 10:25:07 AM Ed Leafe wrote: > This is standard relational database stuff. What is different about your > tables that prevents this from working? I agree, tells what you are doing you'll get better help. Johnf ___ Post Messag

Re: [dabo-users] Child doesn't relate to Parent

2011-11-23 Thread John Fabiani
On Wednesday, November 23, 2011 09:40:09 PM Dewald Jacobs wrote: > On 23 Nov 2011, at 4:57 PM, John Fabiani wrote: > > First welcome to Dabo! > > > > Add the controls you need to the form. Associate the control's > > DataSource and DataField that match the DataS

Re: [dabo-users] Child doesn't relate to Parent

2011-11-23 Thread John Fabiani
ate the correct DataSource and DataField. As you move from row to row on the grid the data in the textboxes will follow. It is best if you have a new question to start a new thread. Also did you sign up for the list? John ___ Post Messages to: Dab

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