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 Studio -> Tips & Solutions

 Error in code generation - Insert, Update, Delete

Print topic Send  topic

Author Message
MaFi

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

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

Problem:
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".

Solution:
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
Martin
View profile  Send private message
eratech


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.

Thanks

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

Posts: 49
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.

Regards
Martin
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 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.