On Wednesday 23 April 2008 08:00:47 am Nate Lowrie wrote: > Both make sense, and refactoring the > database directly helps with the O/R mapping. Dabo's limits are not > the problem. Not even really an issue, as you just need a third > lookup bizobj that joins the 2 tables for lookups and searches. > > The limitation is not in the tools. Dabo might not be able to do CRUD > operations on the 2 tables with a single bizobj, but you can certainly > do it quite easily with 2 bizobjs and a couple lines of code in the db > access layer... > > So, I am not saying that one table is wrong. It satisfied me up until > the point that I needed to add more functionality and then I > refactored to a better design. I am not really even fighting dabo. > If anything, I am fighting SQL and I can't change that...But, still as > long as you can accomplish what you need with your tools in a > reasonable manner, is there any reason not to refactor the db design > to be better
But of course now you don't have a 1 to 1 you have a 1 to many, many, many. Yes SQL is a tool that we again change designs for (depending on the SQL engine). Postgres uses a sort of cursor to prevent dirty reads and MsSQL does not. I have used both and they have caused me to change my table designs. Right now Larry is working on a project that combines dbf's and MsSQL which requires two different programs to deal with data. However, when you say Dabo has a way to deal with the situation then you missed the point I was trying to make. What if Dabo was one of the object database tools? Would you be required to even consider the relationships? (BTW I have never used an object database - so I could be way off here.) No the object would just be a customer. So adding information would just work. To be honest I really don't understand how. But I have read a little about it and the example is always the customer with all these 1 to 1 relations. My point is we change our designs, our programs to meet the needs of our tools. I would go out on a limb and say that our tools limit our thinking. -- John Fabiani _______________________________________________ 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]
