Hi All,
Is it possible to attach a .dbf into a LN R4.6 document using VFP programmatically?
I am a VFP prorammer with some Notesscript knowledge. My case is;
- an existing LN database TEST.NSF,
- an form named TESTFORM in TEST.NSF,
- a date/time field, named D_date, and an attachment in TESTFORM,
- an existing VFP file, named TEST.DBF
With VFP, what I want to use VFP to do are,
1. Open TEST.NSF,
2. open TESTFORM,
3. Delete the existing attachment in TESTFORM,
4. attach TEST.DBF into TESTFORM,
5. replace D_date with today's date,
6. save TESTFORM,
7. close TEST.NSF.
(End)
Alternitively, it will be fine if an Notes agent can update the attachement with TEST.DBF.
Note I was adviced that Notes Forum should be better than VFP Forum for my problem.
Any help would be appreciated, especialy with Notesscript codes for the agent.
Peter
Is it possible to attach a .dbf into a LN R4.6 document using VFP programmatically?
I am a VFP prorammer with some Notesscript knowledge. My case is;
- an existing LN database TEST.NSF,
- an form named TESTFORM in TEST.NSF,
- a date/time field, named D_date, and an attachment in TESTFORM,
- an existing VFP file, named TEST.DBF
With VFP, what I want to use VFP to do are,
1. Open TEST.NSF,
2. open TESTFORM,
3. Delete the existing attachment in TESTFORM,
4. attach TEST.DBF into TESTFORM,
5. replace D_date with today's date,
6. save TESTFORM,
7. close TEST.NSF.
(End)
Alternitively, it will be fine if an Notes agent can update the attachement with TEST.DBF.
Note I was adviced that Notes Forum should be better than VFP Forum for my problem.
Any help would be appreciated, especialy with Notesscript codes for the agent.
Peter