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
|
|
|
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 |
|
|
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
|
|
|
|
|
|
|
|