Attach a .dbf file into a Lotus Notes document programmatically?

[pxw]

Hi All,
Is it possible to attach a .dbf into a Lotus notes document using VFP6 programmatically?

Any help would be appreciated.


Peter

 

[danceman]

the way would be to use OLE. use of createobject is the start. there are samples of OLE in faq. have not worked with OLE with Lotus, but look to see if you have an object browser on your system. the one that comes with fox 6, is not very good. there is a good one that comes with Word, Excel. faq184-2215 will help with using the browser. Attitude is Everything

 

[pxw]

danceman,
Thanks for your response. Is it possible for you to give me some example codes? it seems I can't pick up a picture how to do.

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 VFP6 file, named TEST.DBF

What I want to use VFP6 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)

Your help would be greatly appreciated.

Peter

 

[danceman]

look in the FAQ section, there are plenty of examples of OLE coding. there may not be any for lotus, but you will get the general idea. Attitude is Everything