CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> Tips & Solutions

 Error in code generation - Insert, Update, Delete

Print topic Send  topic

Author Message

Posts: 46
Posted: 03/28/2014, 4:49 AM

Just in case that anybody have the same strange behavior in CCS 5.1.

Regardless what table is used in all recordsets, CCS generates the Insert, Update and Delete Code for a specific different table. E.G. Record for table XYZ, CCS generates "INSERT INTO ABC".

Backup the ccs file and look for entries in that file like:
sourceType="Table" dataSource="ABC" orderBy="ABCNr desc" numberCounter="1" _valueOfList="ABCvalue" _nameOfList="ABCname"
Remove this entries, open the project and regenerate code. It should work again.

Best Regards
View profile  Send private message

Posts: 513
Posted: 03/29/2014, 5:56 PM

MaFi - do you have some more background on the problem? It sounds like it's just generating incorrect SQL all the time - is that it?

Could you have a Custom Update, or have edited something in the code that causes later code-regens not to work?

I'm always on the lookout for 5.1 bugs and have found a couple of non-regen problems, but they are getting fixed as each new update comes through.


CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, Australia
View profile  Send private message

Posts: 46
Posted: 03/31/2014, 1:35 AM

Hi Eric,

no custom Updates, no fancy custom code in the project..
It looks like you can overwrite all database table connections with those entries in the .ccs project file.
I still have no idee how that can happen.

View profile  Send private message

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

Web Database

Join thousands of Web developers who build Web applications with minimal coding.

Home   |    Search   |    Members   |    Register   |    Login

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