On 07/06/12 13:28, John Fabiani wrote:
> On 06/06/2012 07:26 PM, Simon Cropper wrote:
>> Just an update...
>>
>> Installing Dabo last night, which was not really a hassle. I could
>> probably set it up better but I am about to do a total system rebuild in
>> the next few days.
>>
>> I got Paul's program to work without any problems.
>>
>> I got the demo to work no problems.
>>
>> Tried to point Paul's program at another sqlite table and nothing worked.
>>
>> Found most examples outlined on the web did not work in my context. In
>> the end I think the problem was it is sqlite3 not sqlite2. I can access
>> the file with a normal connection but just could not get the whole thing
>> to work properly.
>>
>> It made me wonder though how do people program using Dabo? Do people use
>> the formdesigner then add code (like wxglade) or do they use an editor
>> and if so which?
>>
>> I also noted the lack of documentation - well documentation close to
>> hand (e.g. F1, help wxGrid). In the end I used PyDocs to extract the
>> bulk of the documentation in the package but even this baulked for some
>> modules (specifically wxGrid). After a bit of searching I found the same
>> type of data on the wiki.
>>
>> I'll be honest though, all the examples and peripheral information gives
>> you a distinct impression that the framework is designed to create a
>> data source then build a GUI to access this data source, not to be used
>> as 'programming language'. Yes, the objects and modules can be borrowed
>> from the framework and mingled with python and wxpython code but this
>> hybridization is something learned through trial and error but not
>> actually documented anywhere.
>>
>> John, you invited me back to give Dabo another go. Pointing me at the
>> wiki, in general, will not suffice. Are you aware of any resources that
>> help understand how best to 'feed' Dabo elements and successfully
>> integrated them with python+wxpython? Asking specific questions on the
>> forum on how to get this to talk with that, every step of the way of
>> creating a program will drive everyone to distraction.
>
> Your getting ahead of yourself. Now that you have Dabo running we can
> start designing a real program to access your sqlite databases. Notice
> I used 's' for the plural. Is that what you want to do is open any
> sqlite database and then open the tables for browsing? Or will you be
> opening only one database?
>
> Yes you are right you need to have a 'data source'. But that statement
> is true even if you use VFP or wxPython. That statement is also why I
> think you are getting ahead of yourself. First we need to create a
> form. In that form will will need to use the framework to find the
> database in the file system. Then we will open the database (using Dabo
> connections). Then we will get a list of the tables. Then we need to
> select a table to browse. None of this is different than VFP. VFP
> ->open a database (DBC), select a table, browse the table. The only
> real difference is the connection is automatic in VFP and not in Dabo.
> In Dabo you have create the connection (due to the fact we are
> supporting more than one database engine).
>
> You don't have mix anything - in this case you will just be using Dabo.
>
> How do people create programs using Dabo? There are three primary ways;
> 1. Hand code.
> 2. Use ClassDesigner
> 3. Use AppWizard
>
> I only hand code my forms. I find it to be simple and direct. It
> allows me the most control of the screen and actions.
>
> So the first thing to do is create a form that will allow you to select
> the database file.
> Please create a simple form. On the form place a simple dTextBox, and
> two buttons.
> Hints: Look at dFileDialog.py we will be using it to select the
> database. Then we will use a list box to display the tables (see
> bizobj.getTables). Once we have the table name we'll execute a sql
> statement and pass "DataSource" to browse().
>
>
> Johnf
>
>>
>
> _______________________________________________
> Post Messages to: [email protected]
> Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
> Searchable Archives: http://leafe.com/archives/search/dabo-users
> This message: http://leafe.com/archives/byMID/[email protected]
Paul / John,
Thanks for the replies. I have not gone away, I am busy finishing a job.
I'll get back in a short while. Obviously I have some reading to do so I
will do this before bugging you guys again.
--
Cheers Simon
Simon Cropper - Open Content Creator / Website Administrator
Free and Open Source Software Workflow Guides
------------------------------------------------------------
Introduction http://www.fossworkflowguides.com
GIS Packages http://www.fossworkflowguides.com/gis
bash / Python http://www.fossworkflowguides.com/scripting
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]
