Andrew
|
Posted: 11/03/2005, 11:43 AM |
|
I'm trying to work on a _very_ simple reporting site for one of my clients. I have a grid form (which works) and I want to link to another grid form which contains detail items. I am using CodeCharge 2.0.7 under ASP Win2K.
I link from the original grid page to the "child grid page" and the correct value is being picked up on the child page. But when I look at the WHERE CLAUSE that CodeCharge generated I found that CC had constructed a REDUNDANT THREE TABLE JOIN - the result is that no records appear in the grid.
There doesn't seem to be any way to stop CC from creating this rediculous join clause - no amount of editing or changing the grid form will get rid of it.
Anyone have any ideas? Do I need to just start over on that particular page?
|
|
|
|