Is there a work around the SQL server 16 table limitation? Maybe temporary tables, Access, or even denormalization of the database tables? The database is large and very complex that I’m working with, so any ideas would help. I’m tring to remember “PowerBuilder is your friend” but I’ve hit a wall on this table limitation situation.
I have run into this problem in the past and was able to work around the problem by using child datawindows to do some of my joins.
For example if you where developing a sales report and needed to join to the office table to get the name of the office. You could just return the office code in the primary select, then in the report datawindow for the office code place a drop-down datawindow which was a list of all the offices. Then PB would automatically show the office description!
There would be no tab order on the report so the user would not be able to tell the difference and you save a join per code table.