I now have most of the functionality I was shooting for - run the SQL code bellow to create 4 test db's and then various scenarios: no access, no table, no rows, 2 rows - then run the 'app' and you should get this:
http://pictures.personnelware.com/gallery2/main.php?g2_view=core.ShowItem&g2_itemId=3516&g2_imageViewsIndex=1 I need a UI for for this: user = 'testUserA' ci = dabo.db.dConnectInfo(DbType='mysql', Host='localhost', User=user, PlainTextPassword='pw' ) sqlCmd = """ select * from tbl1 """ and a button to call a form method that will 'do something', like pass all the text.value values to a BO method(s)? Carl K # mkTestdb.sql create database testdb1; create database testdb2; create database testdb3; create database testdb4; grant all on testdb1.* to testUserA IDENTIFIED BY 'pw'; grant all on testdb2.* to testUserA IDENTIFIED BY 'pw'; grant all on testdb3.* to testUserA IDENTIFIED BY 'pw'; create table testdb1.tbl1 ( ktbl1_pk int auto_increment primary key, cFid1 char(10) ); create table testdb2.tbl1 ( ktbl1_pk int auto_increment primary key, cFid1 char(10) ); insert into testdb1.tbl1 (cFid1) values ('abc'); insert into testdb1.tbl1 (cFid1) values ('def'); _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
