I need to be able to be in a DB a do a lookup of all customer names based on a location number. So Would I be better off using LEI, DECS, or LCLSX? All connections need to be based on the server.
Subject: RE: LEI, DECS, or LCLSX?
You can probably do this using DECS. Create a collapse/expand metaconnection and use that as the source connection. This will return the customer name as a multivalued field.
Subject: RE: LEI, DECS, or LCLSX?
Actually they are all aspects of the same thing iirc.
LCLSX directly accesses the Lotus Connector DLL’s that are used by both DECS and LEI. Kind of like the Lotus equivalent of directly usiing ODBC drivers. Its a bit more low level, but not too bad.
Personally I like the LSX as it gives me reliable fast db drivers (compared to ODBCLSX for example) and a lot of power without the overhead of setting up the LEI/DECS environments. That’s often a hammer to crack a nut.
Subject: RE: LEI, DECS, or LCLSX?
I’m a fan of the LC LSX also. For the particular problem stated, it’s probably simpler to use DECS, however, since that’s handled by the server. To use LC LSX you would have to install the database client software on every user’s computer, or use RunOnServer to make the server do the lookup, or do batch updates and just store a copy of the information in Notes. And DECS is not all that difficult to set up.