Favourite SELECT at the startup

Hello,

I am trying to figure out how to have a search (SELECT) I had added to the favourite executed and the results displayed in the dataview at startup.

In Panorama, I performed a SELECT search and added it to the favourites, naming it ‘Pending’.

When I open the file, I want to see the results of ‘Pending’ at startup.

I had created .Initialize procedure to open ‘Pending’ at startup, but this is not doing the trick.

Thank you in advance for any guidance!

Without seeing what you put in your .initialize procedure, it’s difficult to understand what is or isn’t happening.

T’wer it me. I’d put a message in my .Initialize to assure the .Initialize is firing as expected. Then take it out because you know you’ve gotten that far.

Next, you can put your select statement directly in the .Initialize or, if it already a procedure, you can call the procedure from .Initialize. Which are you doin?

What is happening when the database opens?

@designer Thank you!
I added the SELECT statement in the .Initialize procedure as you suggested and it worked:

select «State» = "Pending"
message "Loaded Pending favorite at startup"

Thanks!

The Favorites in the Find/Select dialog are shortcuts to be used in this dialog only.

When you want to select data with a procedure, you use the actual selection criteria.