Re: [dabo-users] Locale

2011-02-01 Thread K C Tang
Hi, Answers: locale.getlocale() (None, None) locale.getdefaultlocale() ('zh_HK', 'cp936') locale.getpreferredencoding() 'cp936' Not cp950 as reported when running Dabo. Would this help? It would be good if the possible reasons for LookupError: unknown encoding: A is suggested so that

[dabo-users] Dabo-users List Statistics for January, 2011

2011-02-01 Thread List Administrator Account
== Dabo-users List Statistics January, 2011 == Subscriber Count at End of Month: 241 == Total Posts: 254 (Up 24.51% from December, 2010) Daily Message

Re: [dabo-users] Locale

2011-02-01 Thread K C Tang
Hi, Correction: The last report was based on a different computer having a different system locale. To conclude after different tests: when Windows system locale = Hong Kong, codeset = cp950 when Windows system locale = China (PRC), codeset = cp936 but hehaviour the same in both cases: when

Re: [dabo-users] Locale

2011-02-01 Thread Ed Leafe
On Feb 1, 2011, at 7:54 AM, K C Tang wrote: when Windows language format = “[zh_CN]” or [zh_SG]” or “[zh_TW]”, translation error appears, but Dabodemo can run. when Windows language format = “[zh_HK]” or [zh_MO]”, translation error appears, “LookupError: unknown encoding: A” appears, and

Re: [dabo-users] Dabo Setup Questions

2011-02-01 Thread Henning Hraban Ramm
Am 2011-02-01 um 11:19 schrieb Uwe Grauer: On 02/01/2011 08:55 AM, Simon Cropper wrote: Paul, Generally not as painful as I thought.. - created the /opt/dabo/ directory then used svn co http://svn.dabodev.com/dabo/trunk dabo This created a subdirectory called dabo that I moved to

Re: [dabo-users] Dabo Setup Questions

2011-02-01 Thread Adrian Klaver
On Tuesday, February 01, 2011 6:23:54 am Henning Hraban Ramm wrote: BTW, instead of linking, the Python way would be a dabo.pth file in your site-packages directory, containing only the path to dabo's parent directory. Greetlings from Lake Constance! Hraban --- On Ubuntu,at least, with

Re: [dabo-users] Dabo Setup Questions

2011-02-01 Thread John Fabiani
On Monday, January 31, 2011 08:01:41 pm Paul McNett wrote: On 1/31/11 7:56 PM, Simon Cropper wrote: OK. I presumed it was an acronym but as Paul explained the name comes from the Dabo Girls of Star Trek / Deep Space Nine fame. http://memory-alpha.org/wiki/Dabo_girl It was Leeta. ;)

Re: [dabo-users] Dabo documentation not searchable - what about Sphinx

2011-02-01 Thread Paul McNett
On 2/1/11 12:19 AM, Werner F. Bruhin wrote: SVN revisions If you look at Andreas site, e.g. page http://xoomer.virgilio.it/infinity77/AGW_Docs/aui.framemanager_module.html#aui-framemanager you will see a SVN Revision graph. Would you like to see this in the Dabo doc? IMO it is scope creep.

Re: [dabo-users] Dabo Setup Questions

2011-02-01 Thread Paul McNett
On 2/1/11 8:57 AM, John Fabiani wrote: On Monday, January 31, 2011 08:01:41 pm Paul McNett wrote: On 1/31/11 7:56 PM, Simon Cropper wrote: OK. I presumed it was an acronym but as Paul explained the name comes from the Dabo Girls of Star Trek / Deep Space Nine fame.

Re: [dabo-users] How best to submit bugs?

2011-02-01 Thread Paul McNett
On 1/3/11 8:57 AM, John Fabiani wrote: On Monday, January 03, 2011 08:38:12 am Ed Leafe wrote: On Jan 3, 2011, at 11:31 AM, John Fabiani wrote: Therefore, I have decided to use the Dabo MySQL test database. But it seems others do not realize I'm doing so. The question is there a better way?

Re: [dabo-users] Requery Not Allowed error

2011-02-01 Thread Paul McNett
On 1/3/11 10:20 AM, Steve Rose wrote: I have a search page in an app that I'm working on that uses the addWhere bizobj method to build a query (MySQL backend). Everything works great until I manage to run a query that returns no records. Then, a message box pops up titled Requery Not Allowed

Re: [dabo-users] Catching KeyDown

2011-02-01 Thread Paul McNett
On 1/2/11 5:45 PM, OKB (not okblacke) wrote: Ed Leafe wrote: On Jan 2, 2011, at 8:29 PM, OKB (not okblacke) wrote: I can't seem to catch a KeyDown event (or any KeyEvents that I've tried). I have a class that subclasses dPanel, and in that class's afterInit I do:

Re: [dabo-users] Locale

2011-02-01 Thread Jacek Kałucki
Użytkownik K C Tang napisał: locale.getlocale() (None, None) locale.getdefaultlocale() ('zh_HK', 'cp936') locale.getpreferredencoding() 'cp936' Not cp950 as reported when running Dabo. Would this help? It would be good if the possible

Re: [dabo-users] Catching KeyDown

2011-02-01 Thread Paul McNett
On 1/3/11 11:18 AM, OKB (not okblacke) wrote: I'm now running into another issue, though, which looks like its more general. If I have a form set up, even if I don't bind any key events, holding down the enter key causes the form to flicker, with some controls seeming to flicker into

Re: [dabo-users] Changing the Menubar generated by AppWizard

2011-02-01 Thread Paul McNett
On 4/9/09 6:36 PM, Manoharan Durga wrote: How can we change the options in the menu bar that has been created using AppWizard? For example, I don't want the users to access the menu items 'command window', 'debug output window' and 'close window' options under the File menu. Setting:

Re: [dabo-users] Which database

2011-02-01 Thread Paul McNett
On 11/23/10 1:45 PM, John Fabiani wrote: If your requirements are very small you could use SQLite (which is built-in Python). I believe Paul uses SQLite in a commercial product he sells. But if you are thinking multi-user then currently you have Postgres, MySQL, FireBird, and maybe MsSQL

[dabo-users] Caught up

2011-02-01 Thread Paul McNett
Ok, I'm finally caught up with dabo-users, at the expense of a few otherwise billable hours this morning. If I've unintentionally missed anything still outstanding, please re-send your message. Thanks! Paul ___ Post Messages to: Dabo-users@leafe.com

[dabo-users] Handling Parent-Child-SubChild relationships

2011-02-01 Thread Nate Lowrie
I have a situation where I have following relationship in the database: - orders - order_line_items is a child of orders - order_line_item_options is a child of order_line_items When I create a new order, the following happens: 1) new orders records 2) Add a line item to

Re: [dabo-users] Handling Parent-Child-SubChild relationships

2011-02-01 Thread Paul McNett
On 2/1/11 12:02 PM, Jacek Kałucki wrote: I have many forms with even longer master-child chains and it works for me correctly. First, requery is issued for another parent cursor and second, the requeryAllChildren() doesn't requery modified children. What happens to you is probably related to

Re: [dabo-users] Handling Parent-Child-SubChild relationships

2011-02-01 Thread Jacek Kałucki
Użytkownik Paul McNett napisał: One thing that keeps me from wanting to do this is that you didn't make it a patch against a specific revision, but rather attached a whole dBizobj.py script file. That will make it tough to diff and just focus on what is changed to solve this specific

Re: [dabo-users] Dabo Setup Questions

2011-02-01 Thread Ed Leafe
On Feb 1, 2011, at 12:12 PM, Paul McNett wrote: OK. I presumed it was an acronym but as Paul explained the name comes from the Dabo Girls of Star Trek / Deep Space Nine fame. http://memory-alpha.org/wiki/Dabo_girl It was Leeta. ;) You dirty old man :-) She was hot!

Re: [dabo-users] Dabo Setup Questions

2011-02-01 Thread Simon Cropper
John, I have been collating English-based resource material for gvSIG on my website. This would be a reasonable place to start. I have included links to other repositories. This will be where I publish my tutorials when they are completed. gvSIG although written by Spaniards has been

[dabo-users] dbase and VFP file capabilities

2011-02-01 Thread Simon Cropper
Hi, Just starting to play with Dabo App Wizard. Does anyone know how to make this work on dbase or VFP files directly? I know that files can be imported to SQLLite but some of these files are associated with spatial data in ESRI Shapefiles (that is, I can't change them). Essentially

Re: [dabo-users] dbase and VFP file capabilities

2011-02-01 Thread Paul McNett
On 2/1/11 4:46 PM, Simon Cropper wrote: Just starting to play with Dabo App Wizard. Does anyone know how to make this work on dbase or VFP files directly? Currently, there's no support for it. Best to convert dbase or VFP data to a supported database such as SQLite. I know that files can

Re: [dabo-users] dbase and VFP file capabilities

2011-02-01 Thread Adrian Klaver
On Tuesday, February 01, 2011 4:46:02 pm Simon Cropper wrote: Hi, Just starting to play with Dabo App Wizard. Does anyone know how to make this work on dbase or VFP files directly? I know that files can be imported to SQLLite but some of these files are associated with spatial data in

Re: [dabo-users] dbase and VFP file capabilities

2011-02-01 Thread Adrian Klaver
On Tuesday, February 01, 2011 5:10:17 pm Paul McNett wrote: On 2/1/11 4:46 PM, Simon Cropper wrote: Just starting to play with Dabo App Wizard. Does anyone know how to make this work on dbase or VFP files directly? Currently, there's no support for it. Best to convert dbase or VFP data

Re: [dabo-users] dbase and VFP file capabilities

2011-02-01 Thread Paul McNett
On 2/1/11 5:10 PM, Paul McNett wrote: Otherwise, we could look at wrapping one of the python libs to access dbase files directly. But you have to understand that wrapping DBF would actually be a lot of work, since I don't think any of the adapters available are db-api2 compliant (and Dabo was

Re: [dabo-users] dbase and VFP file capabilities

2011-02-01 Thread Simon Cropper
Hi Paul, Muy comments are inserted in the dialog On 02/02/11 12:10, Paul McNett wrote: On 2/1/11 4:46 PM, Simon Cropper wrote: Just starting to play with Dabo App Wizard. Does anyone know how to make this work on dbase or VFP files directly? Currently, there's no support for it. Best to

Re: [dabo-users] dbase and VFP file capabilities

2011-02-01 Thread Paul McNett
On 2/1/11 5:34 PM, Simon Cropper wrote: Query: If your grid is 10 rows deep, and your bixobj recordset is 100 rows. Does the grid allow you to scroll through the rows with the mouse wheel or up/down arrows? Yes, both ways are supported. It also has built-in incremental searching. Paul

Re: [dabo-users] dbase and VFP file capabilities

2011-02-01 Thread Simon Cropper
Adrian, On 02/02/11 12:16, Adrian Klaver wrote: On Tuesday, February 01, 2011 5:10:17 pm Paul McNett wrote: On 2/1/11 4:46 PM, Simon Cropper wrote: Just starting to play with Dabo App Wizard. Does anyone know how to make this work on dbase or VFP files directly? Currently, there's no

Re: [dabo-users] dbase and VFP file capabilities

2011-02-01 Thread John Fabiani
On Tuesday, February 01, 2011 04:46:02 pm Simon Cropper wrote: Essentially Shapefiles store all their attribute data in Dbase III format. External packages can readily access these files IF they don't change the file structure, field names or change the code page. I can access these files

Re: [dabo-users] dbase and VFP file capabilities

2011-02-01 Thread Simon Cropper
Hi Paul, It seems from this conversation one solution to accessing isolated xbase tables is convert them to SQLLite, manipulate them within dabo, then convert them back to a DBF file. The old file could be renamed, the SQLLite database 'hidden from view' and the file replaced with the

Re: [dabo-users] dbase and VFP file capabilities

2011-02-01 Thread John Fabiani
On Tuesday, February 01, 2011 06:03:52 pm Simon Cropper wrote: Hi Paul, It seems from this conversation one solution to accessing isolated xbase tables is convert them to SQLLite, manipulate them within dabo, then convert them back to a DBF file. The old file could be renamed, the SQLLite

Re: [dabo-users] dbase and VFP file capabilities

2011-02-01 Thread Simon Cropper
Adrian, Thanks for the links... dbfpy is relatively basic. I presume I could use this to import to an array then manipulate the data and dump it back to the file. Any idea if dabo can manipulate arrays in dGrid or would you need convert the array to an 'in memory' sqllite file? dbf looks

Re: [dabo-users] dbase and VFP file capabilities

2011-02-01 Thread Simon Cropper
Hi John, First, let me state that editing shapefiles is one of the many uses of VFP that I am trying to replicate. All FOSS4GIS provide shapefile attribute editing capabilities. Most are just simple viewers. On a regular basis I import data from shapefiles into VFP, manipulate the data with

Re: [dabo-users] dbase and VFP file capabilities

2011-02-01 Thread Simon Cropper
Hi John, Aside from the size issue (i.e. multiple datasets being merged into a central repository) this is the favoured and most stable option. Cheers Simon Simon Cropper Principal Consultant Botanicus Australia Pty Ltd PO Box 160, Sunshine, VIC W: www.botanicusaustralia.com.au On 02/02/11

Re: [dabo-users] dbase and VFP file capabilities

2011-02-01 Thread John Fabiani
On Tuesday, February 01, 2011 06:31:46 pm Simon Cropper wrote: Hi John, First, let me state that editing shapefiles is one of the many uses of VFP that I am trying to replicate. All FOSS4GIS provide shapefile attribute editing capabilities. Most are just simple viewers. On a regular basis

Re: [dabo-users] dbase and VFP file capabilities

2011-02-01 Thread Simon Cropper
Hi Everyone, Thanks for all the links and replies. They all have provided valuable insight into various options. I will endeavour to go away and play around with these things. Please accept that I am not being argumentative relating the options proposed (e.g. using PostgreSQL+PostGIS) it is

Re: [dabo-users] Dabo-users Digest, Vol 80, Issue 2

2011-02-01 Thread K C Tang
Hi, Latest results of executing C:\dabo\demodabodemo.py after doing a web update: If Windows language format = [zh_CN] or [zh_SG] or zh_TW] or [zh_MO], no translation error reported, but Dabodemo cannot proceed with the following message: C:\dabo\demodabodemo.py Traceback (most recent call

Re: [dabo-users] dbase and VFP file capabilities

2011-02-01 Thread Adrian Klaver
On 02/01/2011 06:46 PM, Simon Cropper wrote: Hi Everyone, Thanks for all the links and replies. They all have provided valuable insight into various options. I will endeavour to go away and play around with these things. Please accept that I am not being argumentative relating the options

Re: [dabo-users] dbase and VFP file capabilities

2011-02-01 Thread Simon Cropper
Adrian, 1. I am not sure but do you operate in Victoria, Australia. If not then the statement is not even applicable to you. 2. And, I stated that the relational database model had been scrapped by the state government for a flat-file model because THEY perceived that it was too confusing for

Re: [dabo-users] dbase and VFP file capabilities

2011-02-01 Thread Adrian Klaver
On Tuesday, February 01, 2011 8:48:34 pm Simon Cropper wrote: Adrian, 1. I am not sure but do you operate in Victoria, Australia. If not then the statement is not even applicable to you. Well when I was a child we lived in Sandringham outside of Melbourne for four years, but that was when

Re: [dabo-users] Locale

2011-02-01 Thread K C Tang
Re-sent with Subject corrected. Hi, Latest results of executing C:\dabo\demodabodemo.py after doing a web update: If Windows language format = [zh_CN] or [zh_SG] or zh_TW] or [zh_MO], no translation error reported, but Dabodemo cannot proceed with the following message: