Help please with: Dblookup - "Entry not found in Index...." error?

[Steve Griff]

"Entry not found in Index or views Index not built" is returned when
executing a Dblookup function? This very same function of my database
has been working fine but I cannot fathom out what has gone wrong!!?
Once I go into 'Designer' and refresh the related 'lookup' view and
then return to the 'Notes' database, the same function works fine??
i.e. I appear to have to keep refreshing the view before the function
works.

The database has an 'Index' built and is set to update 'immediately'
N.B. the database is currently only 'sitting' on my hard drive via the
'local' server. ALSO, it is trying to lookup a view within the same
database.

Does any of this sound familiar to anyone? Any guidance/tips would be
greatly appreciated.

Ta

Steve
.......

[Mark Gregory]

What's the actual code Steve.
Mark

"Steve Griff" <sgrif...@js.renold.com> wrote in message
news:92b5d785.02031...@posting.google.com...

[Didier en Ingrid Van den Meersschaut - Bracke]

Steve,

If I get it right the database does not reside on a server.
In that case forget the automatic update of the index. That's a server
task.

"Steve Griff" <sgrif...@js.renold.com> wrote in message
news:92b5d785.02031...@posting.google.com...

[Stefan Deutzmann]

Hi Steve,

this message comes up when:
- your search key couldn't be found in the view (because no such entry
exists)
- your search key is not in _the first sorted column_ (it's a very common
fault doing @DBLookUp)
--
*********************************************
Cheers !

Stefan
stefan.d...@NO-SPAM-gmx.de
*********************************************

[Steve Griff]

Thanks for the responses.

I've yet to prove it but I believe the problem to be simply because my
database does not yet reside on a 'Server', hence the automatic update
of the Index will not be 'working'. Especially considering that all
functions work once I 'refresh' the relevent view within
'Designer'i.e. After creating a new document, if I then go into
'Designer'and 'refresh', the lookup function then works OK on my last
created document.

Thanks again

Steve.
.........

[Mark Gregory]

Why not get a lotusscript agent to refresh the view and then run the
@dblookup for you ??
Mark

"Steve Griff" <sgrif...@js.renold.com> wrote in message
news:92b5d785.02031...@posting.google.com...

[Karsten Lehmann]

Hi,

maybe you forgot to mark the first column(s) of the view in which you want
to search for documents as sorted. @DbLookup only works on sorted columns.

Karsten

"Steve Griff" <sgrif...@js.renold.com> schrieb im Newsbeitrag
news:92b5d785.02031...@posting.google.com...