hugonr
Posts: 17
|
| Posted: 09/08/2005, 11:16 AM |
|
(i seek this and didnt found, so, im asking here):
i have one page with one grid form into it.
this grid form have one store procedure as datasource (from ms sql).
all worked correctly, when i choose the store procedure, all its parameters are there in the parameters window, and i have success in configure each one but then i got this problem:
i have two parameters that i need to make in before the sp execution, so i posted two edits into my grid tags, and in the "before show" event of each edit i worked my code to make this information.
then, in the parameter window of my grid, i selected one of that parameters, and changed the parameter source from url to control, and then i choose my edit in the list of controls... looks really well, and i thinked that will work, but never worked...
looks like the grid take the information from my edit before the edit had the information itself, i tried everything and nothing works...
i have two ways to do this, one is put the value of the parameter in the grid during the execution, but i have no idea of now to do that (anything like grid->ds->where = "anything", but to one store procedure parameter)....
the other way is make that control work before the execution of the store procedure...
if anyone can help, i will be really glad!!!!
(sorry my really bad english)
|
 |
 |
Michael Mikkelsen
|
| Posted: 09/08/2005, 3:34 PM |
|
What?
|
|
|
|
hugonr
Posts: 17
|
| Posted: 09/09/2005, 12:18 PM |
|
Quote Michael Mikkelsen:
What?
i have one grid that runs a store procedure (ms sql), and one of the parameters of this store procedure its one edit control that have one select in the before show event, is supposed that the edit will take the information from this select and send it to the sp parameter and then the sp parameter will run and will show all the data, but this is not working because looks like the sp runs before the before show event from the edit.
i wish now is more clear.
(sorry again my bad english)
cheers
|
|
|
|
|
