Editable Grid Custom Update

CodeCharge Studio

Web Reports

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

YesSoftware Forums -> CodeCharge Studio -> PHP

Editable Grid Custom Update

Author

Message

precioso

Posted: 06/20/2004, 2:32 PM

using php

just a general question.
I have an editable grid and added my own checkbox to it (not the standard delete box) and want to perform a custom update on the records chosen (when the update_button is pressed)

I cant seem to get the correct syntax for the Where statement..
ie. 'where id=$...'

hope my question is clear enough
any help will be greatly appreciated

cheers

peterr

Posts: 5971

Posted: 06/21/2004, 10:45 AM

I'm assuming that the checkbox is not saved in the database and therefore there are no specific fields in the database to perform the Where statement on.
It could be better to:
1. Create a Checkbox with Control Source Type = "Code Expression" and blank Control Source.
2. In BeforeExecuteUpdate event add code that prevents record update if the checkbox is unchecked:

  global $FormName;  
  
  if(!$FormName->CheckBox1->Value) {  
      $FormName->ds->CmdExecution = false;  
  }

(this will work only starting with CCS 2.3 because CmdExecution was added recently)
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com

precioso

Posted: 06/22/2004, 2:33 PM

thanx peter.. it worked great..

best regards to your team

cheers

Deb

Posted: 10/04/2004, 2:48 PM

Quote peterr:
I'm assuming that the checkbox is not saved in the database and therefore there are no specific fields in the database to perform the Where statement on.
It could be better to:
1. Create a Checkbox with Control Source Type = "Code Expression" and blank Control Source.
2. In BeforeExecuteUpdate event add code that prevents record update if the checkbox is unchecked:
  global $FormName;  
  
  if(!$FormName->CheckBox1->Value) {  
      $FormName->ds->CmdExecution = false;  
  }
(this will work only starting with CCS 2.3 because CmdExecution was added recently)

I am doing something similar in ASP .Net VB and have had problems getting it to work ( I have a support request in but haven't heard back from the engineers). What I am getting is this error message:

C:\DOCUME~1\default\LOCALS~1\Temp\~HDSNet\components\PatientNewOrderFormDataProvider.vb(800) : error BC30451: Name 'CmdExecution' is not declared.

CmdExecution = True

My code in "BeforeExecuteInsert" is

If Item.SelectedForOrder.Value = True Then
CmdExecution = True
End If

Is there something I am doing wrong? Also I have the latest version of CodeCharge.
Thank you for your help!

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