You have found one of the limitations of DECS, the keys have to exist on
the Notes side for updates and deletes.  Another limitation is that the
data is only updated on form open, thus if you have data being kept in
Notes, it is only as fresh as the last time the document was opened.  We
found that the best way to use DECS was to have a form prompt you for a key
(which can be a lookup to a backend DB), then set that key in the form so
that DECS will act on it.

A way to get around some of these issues could be to utilize LEI (Lotus
Enterprise Integrator).  Although it is not free, it may be a better fit
for what you are trying to accomplish.


Dave Guerrero
Team Leader e-Business Solutions
Computech Resources, Inc.
1375 W. Main Avenue
De Pere, WI 54115
Phone:  920-336-1387 Ext. 264
Cell:  920-360-7225
Fax:  920-336-7728

                    "Richard B Baird"
                    <rbaird@esourceconsu        To:
          >                  cc:
                    Sent by:                    Subject:     help with DECS 

                    09/27/01 10:51 AM
                    Please respond to

[ Converted text/html to text/plain ]
Hi all,

I'm working on my web based domino ap using DECS to mirror an as/400 file
the notes ap.  I'm having several problems though.

Here are a few particulars:  The file I'm working with is a work file
generated and  modified by native as/400 applications - it is fairly
as far as record adds, updates and deletes.  the notes ap only updates
fields in the file.  The form that DECS monitors only has a few of the
with editing allowed.  the rest are "computed for display".   The DECS
activity is defined as "open, update"

I'm on os/400 V4R4 and R5.0.8.

1.  Records added to the file via native programs do not appear in the
2.  If I "initialize keys" the new records appear in notes, but it adds all
records from the file, even if they already exist. (duplicates).
3.  After I open, change and save a document, the as/400 file is updated,
the link to the form from the view is changed to "<blank>".

I could change my application to only allow notes to add records to the
database, but I was under the impression that DECS was two way street, that
records are added or changed in the table natively, the new documents would
available in notes.

Any ideas?  What am I missing?  any help here would be greatly appreciated.
Richard Baird

This is the Lotus Domino on the iSeries / AS400 (DOMINO400) mailing list
To post a message email:
To subscribe, unsubscribe, or change list options,
or email:
Before posting, please take a moment to review the archives

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.