CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> Perl

 Problems updateing a DB2 database

Print topic Send  topic

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

Hello,

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->query($SQL);  
  $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).

Wolfgang
michi

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

have you found any solution to this problem ?
View profile  Send private message
Wolfgang
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 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.