home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.paradox      To crash or not to crash, asks Borland      9,834 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 8,137 of 9,834   
   Liz McGuire to Corey   
   Re: Copy OLE objects to directory   
   08 Feb 07 14:15:48   
   
   From: liz@paradoxcommunity.com   
      
   About the only thing I can find is to use a Binary type variable and the   
   binar method writeToFile(), but I don't know if that will work.   
      
   Liz   
      
      
   Corey wrote:   
   > Hi all.   
   >   
   > I wanted to know if there is a relatively straightforward way to scan a   
   > table and copy objects from an OLE field to a Windows directory.   
   >   
   > For example, say I have a table OLEDESC with two fields, IncidentNo and   
   > DescriptionOLE, and it has the following records:   
   >   
   > IncidentNo    DescriptionOLE   
   > 100001        (embedded Word file)   
   > 100002        (embedded Excel file)   
   > 100003        (embedded jpg file)   
   > 100004        (embedded pdf file)   
   >   
   > I ultimately want to put the embedded files in a directory   
   > C:\Attachments\Description.  Ideally, these files would have the IncidentNo   
   > as the filename (although this is not absolutely essential).  That would   
   > make the resulting output as follows:   
   >   
   >     C:\Attachments\Description\100001.doc   
   >     C:\Attachments\Description\100002.xls   
   >     C:\Attachments\Description\100003.jpg   
   >     C:\Attachments\Description\100004.pdf   
   >   
   > Can this be done? I can use writetoclipboard to write the embedded file to   
   > the Windows clipboard (and then manually paste the file), but how do I   
   > automatically paste that file to a Windows directory, using code?   
   >   
   > Thanks.   
   >   
   > - Corey   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca