Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to store pictures data more efficiently?
Message
De
13/04/2001 04:25:32
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
12/04/2001 20:42:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00495154
Message ID:
00495228
Vues:
38
>Dear All,
> I store pictures in general field. First of all I copy the image to the clipboard. Then I paste into the general field(as bmp in PASTE SPECIAL). Is there any way to reduce the size if the memo file (fpt file)so that I can store more picture in the CD-ROM?
>
>Thanks in advance,
>
>Harry

Harry,
Since they're on CDROM they sound to be RO static images. If you don't have a good reason to keep in a general field (like printing via report) then in your table just store the file name and store image files as separate bmp, jpg, gif etc.
This doesn't mean you would save space but provides a more convenient way to store. To save space you still have to find a method like unzipping on the fly, storing as gif, jpg etc.
If your main concern is reducing the memo size than a different block size could help ('SET BLOCKSIZE').
With a value of 0 you could have the maximum saving or try a value greater than 32 (default 64). If you have made modifications (replace, delete) than 'pack memo' would save some space. If you would change blocksize do it like this :
NewSize=0
use myTable
set blocksize to NewSize
copy to myNewTable
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform