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 ?
|
 |
|
Wolfgang
|
| Posted: 08/02/2005, 7:58 AM |
|
no, I used MS-ACCESS again 
|
|
|
|
|
