Error Error Go Away

[sheronne]

Error Error Go Away, I'm sure with Windows you'll be back another Day!

OLE errorcode 0x8000ffff: Catastrophic Failure

Have table named pictures? 2 fields (pictureID c(9), picture GEN ). Happening periodically when I issue
APPEND GENERAL picture FROM "picture.jpg".

Any Ideas?

Thanks In Advance! (Especially Ramani - been soooo much help!)

 

[ramani]

Oh sheronne, I wish I could be of some help to you

Just follow the link for an idea..

http://www.mediamap.com/sw_client_a...l.asp?IDQA=55&strPageInfo=4|FAQ|mm_title.gif|

Rememberto back up, in case you have to get back, may be in addition to registry backup.

Hope this is of some help to you. ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK

 

[ChrisRChamberlain]

sheronne

The search engine is not working properly at the time of making this post, hence the lack of links to previous threads of which there a number.

Embedding a graphics file in a general field is not necessarily the best way to achieve what you want - instead use a character field to store the path\filename of the graphics file.

You will find accessability and performance improvements as you will not be restricted to the default graphics editor for the file type and retrieval and printing will be much quicker.

If you decide to stay with the general field add LINKED to the command line argument.

This will prevent an instance of your graphics editer being added to the image you are appending. The graphics editor will be embedded in each and every record otherwise, which will give you huge files for no good reason.

As far as your error is concerned, I suspect it may be as a consequence of appending an instance of a graphics editor.

Try adding LINKED and failing that change the default graphics editor.

Best of all, implement the suggestion in the second paragraph.

Chris

 

[ramani]

Hi sheronne,

What Chris has suggested will surely improve the performance. Though initialy, you may have to modify the table a bit, this definetely make sense. Clap for Chris for suggesting this.

Probably, you can have a directory for all your jpg files, say.. myJpg. If the pictures are constant files and you dont add more of them... once the application is finished, you can think of adding them in the project. Otherwise, have them in a directory. The idea is to improve the performance.

Best of luck. ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK

 

[sheronne]

Yeah, I know this would be the best way to do it. I have a folder named "Pictures" in the directory already. This is the way I was using it initially. I was searching for a more "user friendly" approach to linking pictures with records. What I was searching for was something simple for a user. To store one image in a folder and then have the software just store that image with a click of a button and delete that file. This may not be the best idea. Any suggestions?

Thx Again

 

[ramani]

Hi,
You can still continue the samr way.. but with a little difference.
1. You can store the pictures instead of in the DBF, in a separate directory within your data directory. So you know exatly where to search and the path can be a stored in a variable say myImageDir. So whenever the image has to be read, you can read it as
defaultDir+"\"+myImageDir+"\"+myImageFileName
2. As for getting the image as upload by user, you can adapt the same strategy of allowing user to select the file from the UserImage directory, copy that into your myImageDir and delete it from the user image directory. (I assume that the user need to be freed from the jungle of images already stored).
So both the objective can be achieved.

This way of storing the image separately, will help you to resolve issues in case there is a DBF curruption. Also the DBF will be small in size (danger of 2GB limit!). All records reading will be faster etc. etc..
ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com

LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK