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

 Grid Riddle!

Print topic Send  topic

Author Message
favc4

Posts: 30
Posted: 06/12/2006, 10:53 PM

Hi there, after many hours of failing I really give up on this one... I am trying to achieve a Master-Detail page where the Master is a grid control, set with a columnar layout and set to show only one row per page (record), my hassle is that no matter wich event I choose, I get an error when referencing either to the Grid.Recordset property, e.g. Grid.Recordset.Fields("IdLead").Value or like...
Dim oRs 'as object
Set oRs = Grid.Recordset ->gives an error... I am trying to retreive the primary key value of this unique shown row in order to append it to the URL as a parameter for the other components to use it in their ad-hoc sql and show the correct thata, but NADA!!! NOTHING! but frustation! If anyone has done a project with a kind of situation PLEASE SHOW ME! SHOW ME HOW TO DO THIS!!!

Many Many thanks for your kind help!

cHUCk
_________________
Programming win32 and went crazy...
View profile  Send private message
peterr


Posts: 5971
Posted: 06/13/2006, 3:52 AM

I suspect that you are trying to access that grid's value from another grid or form, which may not be possible. Your syntax also doesn't look right for CCS. And I'm not sure if you realize that appending a value to the URL would require refreshing the same page again.

Couple possibilities:
1. How do you determine which record should be shown in the 1st grid? Possibly the same criteria can be used to retrieve corresponding records for the other/detail grid.
2. Use the syntax shown in CCS docs and examples, like:
GridName.IdLead.Value
This should work in the Before Show Row event of the grid, and you could also create a session variable there, then use it in other grids.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
View profile  Send private message
favc4

Posts: 30
Posted: 06/13/2006, 6:18 AM

I solved the problem and works fine, just using before show row event and referencing to a control value instead of recordset.field value!

Thanks!


cHUKc
_________________
Programming win32 and went crazy...
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.

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.