Echo wrote: > OK, I now see that I have gotten myself into more than I originally > thought. I'm not going to quit or anything though. I want to try to > solve the problem with not having the permission to create tables. > I can think of two ways to solve this in Dabo. > The first on is to have the db admin get into the program and on > some setup screen or something. On this screen, the db admin can enter > the user and pass for logging on to the database and creating the > tables then. > The other way would to create some sort of script sql in a file that > the db admin can run. > > For something like this to work, all the tables that are > needed(created if not existing) will need to be known to Dabo. I'm not > sure what would be the best way to implement it. I probably won't work > on this until I get table creation working with more databases(I'm > working on MySQL next) If anyone has any ideas of how to make Dabo > know about the needed tables, probably at start up, please let me > know. > > I would suggest that you try a more complicated Database first. In Firebird, DDL and DML are two things which should not be done in one connection. (Nor in multi user environ) DDL is the task for the db-admin whre DML is for everyone who has permission to access the db-objects. So in my opinion you should only spit out the scripts to help making DDL easy. Do not do this from the application level.
Uwe _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
