CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> ASP

 Exclude missing form fields/parameters from data updates

Print topic Send  topic

Author Message
bedollandres

Posts: 48
Posted: 02/28/2007, 2:15 PM

Anybody knows how this works?
Exclude missing form fields/parameters from data updates...

Once you set this up in the project settings, do I need to create my editable grid again? I did it before setting this option to true.
_________________
bedollandres
View profile  Send private message
mrachow


Posts: 509
Posted: 03/01/2007, 1:35 AM

I don't think so.

But you have to recreate your page containing the editable grid.
_________________
Best regards,
Michael
View profile  Send private message
bedollandres

Posts: 48
Posted: 03/01/2007, 9:07 AM

I did the page again, made the editable grid again, created the panels, etc. and it is still putting null values on the hidden (visible = false) components...
_________________
bedollandres
View profile  Send private message
bedollandres

Posts: 48
Posted: 03/02/2007, 7:25 AM

This feature doesn't work with checkboxes...

Quote :
Andres,
I looked into the page and I need to say that it seems that 'Exclude missing.. ' option works improperly because of Checkbox controls. Field is excluded from insert/update only if its value is empty, but checkbox always has a value: 1 if checkbox is checked and 0 if checkbox is unchecked. When Panels are invisible checkboxes get 0 values, that’s why they are not excluded from insert/update queries.
The solution is to use Listbox controls instead of checkboxes.

_________________
bedollandres
View profile  Send private message
wkempees


Posts: 1679
Posted: 03/02/2007, 5:11 PM

Please report this to support.
If you are right, and it needs mending, it will help us all.
Thanks.

_________________
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
AQUANANU


Posts: 107
Posted: 02/17/2008, 2:05 AM

i suggest that this should be for each record form, or editable form instead of being specified for the whole project.

Some time you need to update fields with default values which dont give rights to user to change, but need to be displayed while the record is being updated or added.

Yes team this shouldn't be a duanting task to incorporate the change.

Also the effectiveness of update option should be for all types of controls.
_________________
Navneet Kakkar
CEO
Positive Thinker's Inc.
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.