CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> Perl

 Problems updateing a DB2 database

Print topic Send  topic

Author Message
Posted: 07/07/2005, 11:03 AM


I want to change recordsets from a Grid. I habe implemented a Butten in each line of the grid to do a simple update. I took the code from the CodeCharge Studio Help "Execute Custom SQL" and executed it as custom code on the serverside "on click event" after I got the $ID with the "Save Control Value" action:
  $db = clsDBConnection1->new();  
  my $SQL = "update schema.table set field=0 where table_id=$ID";  
  $db->{sth} = undef;  
  $db->{dbh} = undef;  
I don't get any error massage when I click on the button, it just doesn't work. I've tried it with an updateable grid and with a normal grid, no difference. It seems like the code doesn't get executed at all, because I don't even get an error message when I use a wrong database connection (clsDBConnection1).


Posts: 1
Posted: 08/02/2005, 12:50 AM

have you found any solution to this problem ?
View profile  Send private message
Posted: 08/02/2005, 7:58 AM

no, I used MS-ACCESS again :(

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

PHP Reports

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

Home   |    Search   |    Members   |    Register   |    Login

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