CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> CodeCharge Studio -> ASP

 Editable grid: Only update/insert selected records (checkbox)

Print topic Send  topic

Author Message
Chris__T


Posts: 339
Posted: 05/06/2008, 9:02 AM

I'm trying to select records from an editable grid that when you hit the button, only the records selected (check box, probably) are "update' or inserted (into a new table)

How would you go about making it update/insert based on the checked box?
View profile  Send private message
wkempees


Posts: 1679
Posted: 05/06/2008, 9:46 AM

This thread describes how to prevent a insert/update per row:
http://forums.codecharge.com/posts.php?post_id=91075&s_...=update+allowed
read it to the latest post though.....

Now I would have a checkbox in the editable grid, that you could either have as part of the (temporary) table or mimick the delete source.

Then per row check for the checked/unchecked value of that checkbox and set the insert/updateallowed propertie to its required value.

The above mentioned thread point to BeforeShowRow, but it might be (better) necessary to do this in the befere Insert before Update.

Not tested (yet)

Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)

if you liked this info PAYPAL me: http://donate.consultair.eu
View profile  Send private message
wkempees


Posts: 1679
Posted: 05/06/2008, 9:48 AM

Aha, as always your post has a catch.
I just noticed the (into a new table)
You would thus be using CustomInsert/Update.

Walter

_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)

if you liked this info PAYPAL me: http://donate.consultair.eu
View profile  Send private message
Chris__T


Posts: 339
Posted: 05/06/2008, 10:07 AM

That article will help. Thanks. I think from an ease-of-use standpoint, implementing the checkbox will be more user friendly to a non-computer user (which this will be used by)
View profile  Send private message

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.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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