OLE Notes

[dbigelow]

Can you use smartlist or crystal to search through the OLE notes?

Thank you,

Dan Bigelow

 

[winthropdc]

I seriously doubt it.

The OLE notes are stored in a folder as a container file, so the file itself must be opened before the objects inside can be looked at.

The name of the file is a 8 character Hexidecimal string representation of the 32 bit long integer 'Note Index' field that is the primary key for record notes.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer - Great Plains
Microsoft Dynamics Support - Asia Pacific

Micorosoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

 

[jazgeek]

I found a neat little addon to microsoft outlook called Lookout that can index and find words in just about any location that you point it at.

I index our ole notes directory and it searches all excel files, word documents, pdfs etc.

for instance, I want to find any reference to a PO#1234, it will give me a result (fairly quickly) with all references to that PO# in a format that I can click to open.

but like David says, ole's are outside the database and cannot be searched via a datasource.

why Microsoft didn't blob the ole containers I do not know. It would have made searching and reporting a lot easier.



-----------
and they wonder why they call it Great Pains!

jaz

 

[winthropdc]

Having the OLE notes external to the database are a legacy back to the pre-SQL beginnings of Great Plains Dynamics.

Btrieve and Ctree did not support BLOBs.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer - Great Plains
Microsoft Dynamics Support - Asia Pacific

Micorosoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

 

[jazgeek]

well since v 5 e-enterprise and then dynsql to have encorporated it.... after all that's a lot of versions to hold onto legacy...........




-----------
and they wonder why they call it Great Pains!

jaz