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

 editable grid : onValidate onValidateRow

Print topic Send  topic

Author Message
r1xliquid

Posts: 41
Posted: 05/22/2007, 8:48 AM

I am using an editable grid, i want to throw a custom error. I am doing some logic in the onValidateRow event.

I then use the info i gathered in the onValidateRow to throw an error in the onValidate event.

i am using the following line of code in my onValidate function:
claimSearchResult.Errors.AddError("CUSTOM ERROR")

I have used the above code on other editable grids and it has worked fine, for this page i am getting the following error:
Type mismatch (0x800A0421)
'Default' specification must also specify 'Public'
/betaportal/Classes.asp, line 3713

am i overlooking something? I have been looking at this for a few hours and cannot seem to get it right.

thanks for any info,
brian (codecharge 3.0)



View profile  Send private message
r1xliquid

Posts: 41
Posted: 05/23/2007, 12:09 PM

bump for help

the error is occuring in the
class: clsConverter
function: TypeToString()

the converter class is not instantiated in my asp page, so i really have no idea what class instantiates and calls the typeToString function

any ideas???
View profile  Send private message
Wkempees
Posted: 05/23/2007, 2:19 PM

I think it is in your SQL.
Check your SQL, to see if you are having:
- typo in fields
- type mismatch between SQL and Grid
Or something like that.
r1xliquid

Posts: 41
Posted: 05/24/2007, 9:10 AM

Quote Wkempees:
I think it is in your SQL.
Check your SQL, to see if you are having:
- typo in fields
- type mismatch between SQL and Grid
Or something like that.

Yes I think you are correct in your response, it has to do with SQL.
What i am actually doing is placing an editable grid on the screen, but not allowing any insert/update/delete. My reason for this is: I need a user to use a check box to check off rows. I then compare the rows and either allow/not allow the user to continue with the form submit.

If the user submits the form, they go to a different page where they will update the data.

Maybe i am taking the wrong approach here. Anyone got any ideas how i could get the desired result?
View profile  Send private message
wkempees
Posted: 05/24/2007, 3:18 PM

Although I cannot solve your problem, I have a suggestion.
Change the editable grid.
Create a small table something containing just the reference to the primary
key of your original table and a checkbox "IsSelected".
Make the EGrid run on the new small table, in the SQL linking in the data
you need from the original table.
So your EGrid displays a checkbox and the relevant data.

Now for the EGrid, specify no Insert No Delete, Custom Update
The Custom Update will only handle the checkbox.
Now you can do onValidate on the Checkbox.

I use a similar approach in a EGrid where I want to specify a product table
for a customer.
The grid runs on customer_products (containing FK_to main product,
IsSelected and Price)
The customer is presented with his product/pricelist while actualy viewing
products from the main table joined to his producttable
In administration we can check or uncheck the product and alter prices.

Success,
Walter


"r1xliquid" <r1xliquid@forum.codecharge> schreef in bericht
news:64655b8f886053@news.codecharge.com...
>
Quote Wkempees:
> I think it is in your SQL.
> Check your SQL, to see if you are having:
> - typo in fields
> - type mismatch between SQL and Grid
> Or something like that.
>
>
> Yes I think you are correct in your response, it has to do with SQL.
> What i am actually doing is placing an editable grid on the screen, but
> not
> allowing any insert/update/delete. My reason for this is: I need a user to
> use a
> check box to check off rows. I then compare the rows and either allow/not
> allow
> the user to continue with the form submit.
>
> Maybe i am taking the wrong approach here. Anyone got any ideas how i
> could get
> the desired result?
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.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.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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