CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge -> Programming

 GridPage to GridPage link generates invalid WHERE clause

Print topic Send  topic

Author Message
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?

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.