matt
|
| Posted: 08/30/2005, 9:53 AM |
|
1) I build an editable grid form. The nature of the form is that it requires a custom insert (and update and delete). I start by building the form and ensuring that all of the search functionality is working.
2) I add a custom insert statement. The insert works fine, but the search capability quits working. I've tried both "table" and "sql" styles for the custom inserts with similar results.
Any clues?
|
|
|
 |
matt
|
| Posted: 08/30/2005, 9:55 AM |
|
Clarification - when I say that the search stops working I mean that none of the rows on the database are returned. I just get the one empty row for inserting a new row into the table.
|
|
|
|
DonB
|
| Posted: 08/30/2005, 12:35 PM |
|
Hard to say. But I suspect the parameters in the URL are being changed,
such that the grid selects zero records from the database following the
insert. Not a normal thing, so that leads me to suspect your page possibly
has some event code mangling the URL? Either that, or you are destroying
the data source sql/where properties along the way (maybe using the
connection to write some other data to the database, such as in an After
Insert event?)
--
DonB
http://www.gotodon.com/ccbth
"matt" <matt@forum.codecharge> wrote in message
news:543148f9829e64@news.codecharge.com...
> Clarification - when I say that the search stops working I mean that none
of the
> rows on the database are returned. I just get the one empty row for
inserting a
> new row into the table.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
matt
|
| Posted: 08/30/2005, 12:49 PM |
|
Don,
No such luck. This is a simple page with no custom code beyond the custom insert. The default behavior without the custom insert is for the first ten rows of the db to populate the grid with one empty row at the bottom. With custom insert turned on the initial rows never populate the db. I'm giving up and trying to find another way to skin this cat - probably by resorting to event code.
Matt
|
|
|
|
peterr
Posts: 5971
|
| Posted: 08/30/2005, 1:22 PM |
|
You could also try contacting the support about this.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
DonB
|
| Posted: 08/30/2005, 7:40 PM |
|
You can watch what happens to the grid's data source by putting this in the
Grid's Before Execute Select event:
$mygrid->ds->Debug = true;
(whatever your grid's name is in place of 'mygrid')
then the actual database query will be displayed each time the grid loads
some data, and you can see what's happening.
--
DonB
http://www.gotodon.com/ccbth
"matt" <matt@forum.codecharge> wrote in message
news:54314b83fadb88@news.codecharge.com...
> Don,
>
> No such luck. This is a simple page with no custom code beyond the custom
> insert. The default behavior without the custom insert is for the first
ten
> rows of the db to populate the grid with one empty row at the bottom. With
> custom insert turned on the initial rows never populate the db. I'm giving
up
> and trying to find another way to skin this cat - probably by resorting to
> event code.
>
> Matt
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
