Saving and Appending to searches

[wundrbee]

The ability to save searches would be nice.

The ability to append to a saved search from a search on another databas.

Say I run a search on my herb group database for rosemary and save that search. Then close the first database and search my recipe group for rosemary. I could then append the search results to the rosemary search from the herb group.

To be able to use the appended search have PGO open it like a database. Click on the message you'd like to access, and PGO could either shut down the appended search or best case scenario be able to open the database simultaneously. Shutting down the new database and opening another when another message in the search is clicked.

Would it be simpler to save search results to a new database and append to that database?

Ah pooh! It's late and I hope I'm making any sense. If not I will try to clarify tomorrow.

Tammi Upshaw

[Wilson Logan]

Alternatively... put both groups into the same database & search them simultaneously.

Yes / No ?

Cheers,

Wilson.

[wundrbee]

You mean merge the two databases? What if the two databases combined goes over 2 GB? If it were not for the two gig limitation I'd plop all my groups in one big database.

Actually, I got to thinking about it this morning and came up with the idea of exporting saved messages into a database. Even if one could not append to the database by exporting another search - they could still import all of the searches into one database. It seems like that would be the easiest thing.

Out of curiosity could PGO utilize the MS Access 2003 format? If I am correct it does not have the 2GB limitation. What about SQL? or would that require the user to know SQL also?

Tammi Upshaw

[Wilson Logan]

>You mean merge the two databases?

No, just put related groups in the same database.

>Actually, I got to thinking about it this morning and came up with the idea of exporting saved messages into a database. Even if one could not append to the database by exporting another search - they could still import all of the searches into one database. It seems like that would be the easiest thing.

You can save search results. Its an option in the Search dialogue.


>Out of curiosity could PGO utilize the MS Access 2003 format? If I am correct it does not have the 2GB limitation.

If you install PGO on an Access 2003 system it will use that by default.

>What about SQL? or would that require the user to know SQL also?

You would need to know SQL and you'd need a program to write it & execute it against the database .e.g a full copy of Access.

Cheers,

Wilson.

[wundrbee]

You can save search results. Its an option in the Search dialogue.

Okay, I see how I can do it now. DUH! It was so simple it was under my nose.

>Out of curiosity could PGO utilize the MS Access 2003 format? If I am correct it does not have the 2GB limitation.

If you install PGO on an Access 2003 system it will use that by default.

So, If I understand correctly If I have Microsoft Office 2003 (With Access 2003 installed, of course) Then I do not have a 2 GB limit for my databases?

Tammi

[Wilson Logan]

>So, If I understand correctly If I have Microsoft Office 2003 (With Access 2003 installed, of course) Then I do not have a 2 GB limit for my databases?

Thats the way I understand it.

As a test you could set up a database & import stuff till the pips squeek.

Yours intrigued,

Wilson.