Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OLE Automation
Message
 
To
18/01/1999 10:30:42
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00177169
Message ID:
00177177
Views:
30
>My questions are:
>1. How do I link the documents to the table, versus embedding them?
>
There is a LINK parameter on the APPEND GENERAL command.

>2. When creating a form for the interface, do I use unbound or bound OLE object? I am not sure what the difference is between the two.

Use an OLE Bound control. The set the ControlSource to the GENERAL field. The Bound control will use your File Association for the type of file in the GENERAL field to fire off the appropriate program.

----
Overall:

My experience with doing this has not been pleasant. The GENERAL fields cause enormous FPT bloat. I've even seen the LINK keyword make it WORSE not better. In every case that I've needed to do something like this, I've ended up storing the file name in a character field and firing off the editor myself. Of course, this means that I have to do some file/directory wrangling, but that's been better than dealing with the huge FPT's that I've seen. When you PACK the database, the bloat goes away. But in a multiuser environment, PACK is expensive.

Hope this helps.

Marty
Marty Smith, CSQE
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform