>Does anyone have a good method of querying lookup table data in a multi-datasession environment? We've been investigating methods of querying lookup table data at application startup and saving it in order to avoid having to requery it every time we need it (for populating combo boxes and whatnot). One method we've used in the past is to query the data (using views), and copy it to global arrays. In that way, the data would be available to all datasessions. Does anyone have a better idea?
>
>Any suggestions would be appreciated.
Why not to request lookup data when it's really necessary? If you data indexed properly it should go extremely fast.
Edward Pikman
Independent Consultant