Andrew BInary large objects are images. You can handle them in one of two ways:
1. Store them in a column in a table - ie, your plants table could have an PlantPicture column which would be LONG VARBIT datatype (VARBIT in the RBDEFINE screen). 2. Store them on separate files on your disk and store just the name of the file in the database. Method 2 has the advantage of keeping your database size more reasonable and making maintenance tasks like PACK and RELOAD faster. Method 1 gets you somewhat faster access to the image. Let me know if you want more details David Blocker ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Monday, February 10, 2003 3:31 PM Subject: [RBASE-L] - BLOB assistance > The lowly student asking the masters..... > > I am using version 6.1 for windows and build 1.578x037Y on Win98SE am unable > to understand the mystery of Binary Large Objects. The help screen seems > awfully short as to what table they are stored in, how I can refer back to > them once I have forgotten the name of the variable they were loaded with, > etc. > > Any points would be appreciated. We are a small landscape company also > considering loading quite a few pictures of plants, etc. and was wondering if > there were any limitations to individual files sizes as well as total > quantity. > > I was kind of lost by Microrim when they dropped the OS/2 version and sent me > the new v6.1 for windows on floppy as a token, but no updated books, so all > of my printed reference is with v5.5. > > Thank you.... > > Andrew Skoog > >
