Normal Topic pop-up msg to advise user of 'No search results' (Read 606 times)
airjordan
Member
*
Offline



Posts: 13
Joined: Sep 11th, 2009
pop-up msg to advise user of 'No search results'
Mar 5th, 2010 at 12:24am
Print Post Print Post  
I am wondering, is there a way to configure a sesame database to pop-up a msg box whenever a user conducts a search and it returns 0 results?

I know the top bar displays how many records have been found as you can scroll through using F10, but is there a more eye catching method to advise that the search has returned no results?

cheers
AJ
  
Back to top
 
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: pop-up msg to advise user of 'No search result
Reply #1 - Mar 5th, 2010 at 2:10am
Print Post Print Post  
You could change some colors on the form depending of the mode you are in. This is documented in the July 2009 issue of Inside Sesame, under the title "Color Your Form for Different Modes".
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
lksseven
Full Member
***
Offline



Posts: 416
Location: Southwest
Joined: Jan 26th, 2009
Re: pop-up msg to advise user of 'No search result
Reply #2 - Mar 5th, 2010 at 2:03pm
Print Post Print Post  
On my forms, I make a command button that substitutes for the F10 key ("go find the records").  The code (below) pops up a MsgBox if and only if zero records are found.  It works fine.

CommandButton::OnElementEntry
var n as int
var vCnt as int

n = @SelectTreeItem("Search Menu!Search Commands!Retrieve New Results (F10)")
vCnt = @FormResultSetTotal("")

If vCnt = 0
  {
     @MsgBox("This SEARCH returned zero records","","")
  }
  

Larry
Back to top
IP Logged
 
airjordan
Member
*
Offline



Posts: 13
Joined: Sep 11th, 2009
Re: pop-up msg to advise user of 'No search result
Reply #3 - Mar 8th, 2010 at 12:31am
Print Post Print Post  
lksseven,

thanks for that. works a treat.

cheers
AJ
  
Back to top
 
IP Logged