Simplicty and flexibility!


New Function in 8 - MemoFind() - Returns the occourrence in a Memo of search. (Ver. 8.0.0.1038)

Started by DataEase
You will need to Sign In to be able to comment on the Blog!

New Function in 8 - MemoFind() - Returns the occourrence in a Memo of search. (Ver. 8.0.0.1038)

Such a simple function, but already such an important function.

This is the missing freetext search in DataEase.

As you know, you cannot search Memo fields in DataEase up and including 7.2, but then again Memo is just a Memo...for notes. Nobody want to search them anyway?

In 8, we see that almost 90% of the data in an application is now stored in Memos, simply because you can now save document sized objects, where you before was limited to 256 bytes in "useful" fields.

We quickly realised that we needed to be able to search across memo fields too.

The reason traditional DataEase search doesn't work in Memos, is because of the architecture. A traditional DataEase database is structured, when memos is stored outside the structure. To change the traditional functions to take Memo into account, would slow down the traditional functionality, when at the same time it wouldn't really be a good idea.

In 8 we rather add functions that change functionality, so this is what we did here too. We added MemoFind().

int MemoFind(MemoToSearch,Search)

We successfully use this in With statements in DQL, and in filters...works brill, and is the corner stone of search on this website, both in News and Help and...

Enjoy thinking different!


Written by DataEase 29/12/11 at 10:42:42 Dataease [{8}]FIVE