No record found

[Glauco]

Assume there is no record satisfying my filtering criterias. By default,
AspDb displays the message "Error: no record found SELECT ..."
I would like it to behave in a manner similar to when it finds a record.
Let's say, I would like it to display a no records found message, in a customizable way, with (assume) the search and the add new buttons enabled.

I've found the property dbTestBlankSql which brings the browser in "append mode", but it is not what I would like to get.

The example you can find here
http://www.aspdb.com/properties/EMB-05.asp?ID=EMB-05
shows the use of dbRecordCount to display a custom message, but it clears
all the previously produced output: I show the grid in the middle of a
formatted page, and it would be far better to me, to avoid clearing the
page.
Is it possible to get AspDb to simply display a custom message instead of
the usual rows, and the proper navigation bar?
Thanks in advance.

[Mark]

Glauco,
It is not necessary to clear the screen. Just display your message. See example 13a at: http://www.aspdb.com/apps/
Mark.


------------
Glauco at 12/21/00 10:10:01 AM

Assume there is no record satisfying my filtering criterias. By default,
AspDb displays the message "Error: no record found SELECT ..."
I would like it to behave in a manner similar to when it finds a record.
Let's say, I would like it to display a no records found message, in a customizable way, with (assume) the search and the add new buttons enabled.

I've found the property dbTestBlankSql which brings the browser in "append mode", but it is not what I would like to get.

The example you can find here
http://www.aspdb.com/properties/EMB-05.asp?ID=EMB-05
shows the use of dbRecordCount to display a custom message, but it clears
all the previously produced output: I show the grid in the middle of a
formatted page, and it would be far better to me, to avoid clearing the
page.
Is it possible to get AspDb to simply display a custom message instead of
the usual rows, and the proper navigation bar?
Thanks in advance.

[Glauco]

Hi Mark,
thank you for the precious reference, it was exactly what I needed.
www.aspdb.com site, has several directories each containing many examples.
I know about them, just because you mentioned about them on this very
useful forum.
I remember of:
www.aspdb.com/properties/
www.aspdb.com/v2/
www.aspdb.com/apps/

Are there other directories? Unfortunately, I can't find any link to
such directories on the home page. Am I wrong? Imho, such links
would be really appreciated.

Best regards.

------------
Mark at 12/21/00 10:37:40 AM

Glauco,
It is not necessary to clear the screen. Just display your message. See example 13a at: http://www.aspdb.com/apps/
Mark.