Re: An unknown error has occured...




Do you have lookup fields defined? If you do you will get an error like this
when you run out of the IDE with debug set to stop on errors.
There is a Try/Fail block in the Adodb code for lookups that generates this
error. If you set the LookupCache property to true you won't get the error



Ahhhh thanks. The LookupCache thing removed the errors. Question is, does it
have any drawbacks using a lookup cache? Usually there is a "cost" associated
with things like using a cache, how does the system know when to refresh the
cache for instance?

If the lookup data is static and the table isn't large you are better off using
lookupCache = true. You probably should not be using a lookup at all of the
lookup dataset is large.
The lookupcahe is loaded when the dataset is opened and can be refreshed with a
call to RefreshLookupList
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.



Relevant Pages

  • Re[3]: vn_fullpath() again
    ... How do you feel about small incremental improvements to name lookup? ... > - Don't purge intermediate but unused nodes from the name cache. ... since files can have hard links. ... > add a directory back-pointer to the parent of a file. ...
    (freebsd-hackers)
  • Re: [PATCH 00/37] Permit filesystem local caching
    ... The problem is that you have to do a database lookup of some sort, ... involving several synchronous disk operations. ... a fair bit better then BTRFS when the disk cache is cold. ... NFS, for example, wants to access a new inode, it first has to go to the ...
    (Linux-Kernel)
  • Re: [PATCH 00/37] Permit filesystem local caching
    ... CacheFiles does a disk lookup by taking the key given to it by NFS, ... a fair bit better then BTRFS when the disk cache is cold. ... Note that the get the filehandle, you have to do a LOOKUP op. ...
    (Linux-Kernel)
  • Re[2]: vn_fullpath() again
    ... - Don't purge intermediate but unused nodes from the name cache. ... that rapidly consume vnodes, this allows more vnodes to be recycled, so ... add a directory back-pointer to the parent of a file. ... valid (during the lookup), and of secondary importance after that. ...
    (freebsd-hackers)
  • Re: Table relations across datasets
    ... #3) If you use mutexes, ... I am fairly sure the ASP.NET cache does that. ... > want to store all the lookup tables at the Application level and the ... > business logic dataset at the Session level. ...
    (microsoft.public.dotnet.framework.adonet)