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]
