Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Rao Gorantla
  Where is Rao Gorantla?
 Toronto
 Canada
 Rao Gorantla
 To: onytoo
  Where is onytoo?
 Padang
 Indonesia
 onytoo
 Tags
Subject: RE: 'Error Creating OLE Object' Foxprow 2.6
Thread ID: 287936 Message ID: 288913 # Views: 30 # Ratings: 0
Version: FoxPro 2.x for Windows Category: Errors & Debugging
Date: Sunday, December 26, 2010 4:56:19 AM         
   


> > Hi There, I just joined the forum. Pls welcome me. I am new to these forums..I need help:
> >
> > I have a system that allows linking bmp files to a database. It works with Foxprow 2.6 on a system with Windows 98. The same code doesn't work with Windows XP. It gives an 'Error Creating OLE Object'. Can amy one help me?
> >
> > 1.I have a table (MEMBMPS) with the following structure
> > MEMBERNO Nmeric 6
> > PHOTOGRAPH General 10
> > SIGNATURE General 10
> >
> > 2.I am adding pictures PHOTOGRAPHs and SIGNATUREs after scanning and storing them in a folder and then appening ot a database:
> >
> > Do While MASTER.MEMBERNO <= m.to
> > ====== Create filenames ==========
> > fns = Alltrim(m.source)+"\"+AllTrim(Str(MASTER.MEMBERNO))+"S"+".BMP"
> > fnp = Alltrim(m.source)+"\"+AllTrim(Str(MASTER.MEMBERNO))+"P"+".BMP"
> >
> > ======= Tried with and without classes==========
> > Append General PHOTOGRAPH From (fnp)
> > *CLASS pbrush
> > * CLASS PAINT.PICTURE
> >
> > =========Tried with and without classes ========
> > Append General SIGNATURE From (fns)
> > *CLASS pbrush
> > * CLASS PAINT.PICTURE
> > Select MASTER
> > Skip In MASTER
> > Enddo
> >
> > 3. It replaces the PHTOGRAPH, gives error on the second Append statement as
> > Error Creating OLE Object at statement:
> > Append General SIGNATURE From (fns)
> >
> > 4. I selected Ignore, then the error comes for the next member at the same statement
>
> Hi Rao
>
> IMHO, it's better to save only full path to bmp file rather than save them as general type field.
> That method will give you a small dbf file size.
>
>
> Regards,
> Onytoo

Thanks Onytoo! But I don't understand the link between the full path and dbf file size to my problem. Can you please answer to my problem of 'Error Creating OLE Object' Rao

ENTIRE THREAD

'Error Creating OLE Object' Foxprow 2.6 Posted by Rao Gorantla @ 12/15/2010 7:52:02 PM
RE: 'Error Creating OLE Object' Foxprow 2.6 Posted by Yuri Rubinov @ 12/15/2010 9:38:25 PM
RE: 'Error Creating OLE Object' Foxprow 2.6 Posted by Ony Too @ 12/18/2010 5:39:08 AM
RE: 'Error Creating OLE Object' Foxprow 2.6 Posted by Rao Gorantla @ 12/26/2010 4:56:19 AM
RE: 'Error Creating OLE Object' Foxprow 2.6 Posted by Ony Too @ 12/29/2010 3:30:26 PM