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 -> General/Other

 Editable Grid Operation sequence

Print topic Send  topic

Author Message
matheus

Posts: 386
Posted: 10/04/2006, 2:23 PM

Seems like the EditGrid do each operation with same sequence of line.

For example, if I send delete second line (checkbox checked) and update first line, it will before update and after delete.

This could result in error with table that have unique restrict or primary key editabled.

I mean that EditGrid need do all Delete before and then go to Insert or Update.

Can someone resolve this?

_________________
Matheus Trevizan

Dynamix Software Ltda.
Blumenau SC Brasil
www.dynamix.com.br
View profile  Send private message
mamboBROWN


Posts: 1713
Posted: 10/04/2006, 4:23 PM

matheus
You may need to contact support ( http://support.yessoftware.com ) and see if they can assist you in this matter.
View profile  Send private message
matheus

Posts: 386
Posted: 10/05/2006, 5:35 AM

The support tell that I'm right in operation sequence (it's by the line) and suggest use two Editable Grid, one to edit/insert and another with delete operation.

I will post in Wishes forums a idea for change operation sequence in EditableGrid.

If someone had a idea please post here...
_________________
Matheus Trevizan

Dynamix Software Ltda.
Blumenau SC Brasil
www.dynamix.com.br
View profile  Send private message
Tuong Do
Posted: 10/27/2006, 6:39 PM

Hi Matheus,

To get around the the problem would disable editing the primary key field on
existing record not on new record

That can be done by checking the row mode in the before show row event

If the data entry person want to change the primary key of the existing
record, he/she has to delete the record and create a new record (new records
always process last)

NOTE:



"matheus" <matheus@forum.codecharge> wrote in message
news:24524264fa4d01@news.codecharge.com...
> Seems like the EditGrid do each operation with same sequence of line.
>
> For example, if I send delete second line (checkbox checked) and update
> first
> line, it will before update and after delete.
>
> This could result in error with table that have unique restrict or primary
> key
> editabled.
>
> I mean that EditGrid need do all Delete before and then go to Insert or
> Update.
>
> Can someone resolve this?
>
> _________________
> Matheus Trevizan
>
> Dynamix Software Ltda.
> Blumenau SC Brasil
> www.dynamix.com.br
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>


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.