I am designing an app and trying to figure out what will go where. spec: user enters MySql Host/user/password/query, hits 'go.' app logs in, for each DB the user has rights to*, executes the query "in" that DB**, displaces the results*** in a grid.
* rights to - not 100% what rights, but for now will go with 'any.' ** in DB - use (db), execute query. *** results - either a child grid showing the cursor, or an error message. I like doing things right, even for something this simple. So I am trying to figure out: where do I put what? Host/user/password is easy - 3 textboxes, pass the values through the BO to the CO. that gets me the connection and cursor object I need. for each DB the user has rights to - that seems pretty DB stuff, so I guess add a method to a custom cursor class that returns a list of dbs. but returns the list to what? this is where I get lost. which normaly means I need some BO code. my guess is I need a for loop in some BO method. maybe the same BO methon that I passed the host/u/pw to? I could cram 'everything' into that method but that doesn't sound very elegant. anyone have any thoughts? Carl K _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
