GeorgeS
Posts: 206
|
| Posted: 07/30/2004, 12:12 PM |
|
I'm passing parameters from a LINK control through a query string.
I have custom SQL insert statement (taken from CCS Help file) that suppose to insert a record into a table before any SQL select statements for the GRID (where this new record should be displayed) are built and executed.
I determined that events that I can use for custom SQL Insert are executed in the following order:
Page_AfterInitialize
Page_OnInitializeView
Page_BeforeShow
GRID_BeforeSelect
GRID_BeforeBuildSelect
In all events my custom SQL works BUT this new record is not showing up in the grid the first time page loads. I have to click a Refresh button.
Is it suppose to be this way?
_________________
GeorgeS |
 |
 |
DonB
|
| Posted: 07/30/2004, 12:58 PM |
|
Not sufficient details, but it sounds like the grid's recordset either
excludes the inserted record or is not being reloaded/refreshed once the
event code finishes the INSERT.
--
DonB
logging at http://www.gotodon.com/ccbth, and blogging at
http://ccbth.gotodon.net
"GeorgeS" <GeorgeS@forum.codecharge> wrote in message
news:2410a9dacdea1b@news.codecharge.com...
> I'm passing parameters from a LINK control through a query string.
> I have custom SQL insert statement (taken from CCS Help file) that suppose
to
> insert a record into a table before any SQL select statements for the GRID
> (where this new record should be displayed) are built and executed.
> I determined that events that I can use for custom SQL Insert are
executed in
> the following order:
> Page_AfterInitialize
> Page_OnInitializeView
> Page_BeforeShow
> GRID_BeforeSelect
> GRID_BeforeBuildSelect
>
>
> In all events my custom SQL works BUT this new record is not showing up in
the
> grid the first time page loads. I have to click a Refresh button.
> Is it suppose to be this way?
>
> _________________
> GeorgeS
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
GeorgeS
Posts: 206
|
| Posted: 07/30/2004, 3:06 PM |
|
Don,
I just want to know if a new record that was inserted in the GRID_BeforeSelect event should show up in the GRID because SQL Select code for the GRID buids after the GRID_BeforeSelect event?
For now I'm using response.redirect in Page_AfterInitialize event.
_________________
GeorgeS |
|
|
|
|
