Razzak, There are two things that I am trying to accomplish other than explain myself. 1. Doing one file at a time is solid. I can choose from a list or I can use the shift F10 and navigate to the GIF directory. Both of these processes will work fine for one file at a time. I have 300 animated GIFs that I would like to load into the database but not one at a time. I was thinking of a Load command where the "navigated to" directory was the source for the files. 2. I want to see the file name and path of the data stored in the blob. The value of column ImagData shows in the table as [GIF,53248,9862]. How can one extract the filename and path from this, if this is possible.
Phil Nolette www.ncsgrp.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of A. Razzak Memon Sent: Monday, December 02, 2002 12:42 AM To: [EMAIL PROTECTED] Subject: RE: Storing Pictures (GIFs) in database - Razzak's Reply Phil, You can also use the same CHOOSE command (see below), with CHKBOX or CHKBOX n option to specify the maximum number of selections a user can check. Then, you can parse the string (resulting text variable, separated by comma) to INSERT the row(s) accordingly. The #LFILES IN *.GIF displays all files in current directory in a pop-up list, unless the path IN filespec option is specified. You can save that path as a separate variable to use in INSERT values or define as a variable, for example ('\path\'+'filename.gif') to achieve the same goal. Hope that helps! Very Best Regards, Razzak. At 12:20 AM 12/2/2002 -0600, Phil Nolette wrote: >Razzak, >Thank you for the reply. Option 1 of your reply will do one file at a time. >Is there a way, like declaration of a cursor that you can have a list of >files that meet the criteria (sel filename from list where extension = gif) >and then do an insert until SQL = 100? Lastly, I am trying to get the path >and filename from the recorded Blob. Is there a way to get that out of the >stored row of data? > >Phil Nolette >www.ncsgrp.com > > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On >Behalf Of A. Razzak Memon >Sent: Sunday, December 01, 2002 11:10 PM >To: [EMAIL PROTECTED] >Subject: Re: Storing Pictures (GIFs) in database - Razzak's Reply > >Phil, > >01. You can write a command file or EEP to look for *.GIF files, using the: > > CHOOSE vFile FROM #LFILES IN *.GIF AT..TITLE..CAPTION..LINES..FORMATTED > and then use the INSERT command to load all VARBIT BLOB file(s) into > table > > Take a look at: > From the Edge: Storing Pictures or Graphics as BLOB > http://www.razzak.com/fte (Blobs) 07/05/1999 > > Using the Form, you can also use "Double-Click" on VARBIT field to load > BLOB data. > >02. The Glorious R:BASE 2000 (ver 6.5++) for Windows, does not support > animated GIFs. > > The Magical R:BASE 7.0 for Windows includes the built-in support for > ALL graphic files, including "Animated GIFs". > > Form Designer > Additional Controls > Animated GIF Control > > R:BASE 7.0 for Windows also includes a cool Note/Varchar/Blob Field > Viewer/Editor! > >Very Best Regards, > >Razzak. > >At 09:03 AM 11/30/2002 -0600, Phil Nolette wrote: > > >I finally have had enough time to create an image database based upon the > >document "Storing Pictures or Graphics as BLOB' > >I created the database table and will be using additional attributes to > >describe the type of file being used in my form edit window or in the > >report. > >I have however run into some "wonder" questions that I would like to ask > >this group if they have encountered this or how they would work around it. > > > >1. On the Add Form: I recognize that the best way to add an animated > >GIF (this is what I am starting with) is by using the Shift F10 so that you > >do not have to write in the entire path to the image nor do you have to >copy > >it into a manual key. My question or statement is: can you automate this > >Shift F-10 to scan an entire directory and look for any filename with an > >extension of GIF? If so, I imagine that it would come through a RMD file. > >True? Would you change directory to the target and then do a cursor with >an > >insert? What would be your terminator if you used a *.GIF from that > >directory? Can you use a cursor to select the filenames that met the > >criteria? > > > >2. When you display in the form the GIF, it does not animate. It >shows > >as a static picture. To cure this, I changed the file association in > >Explorer to associate Internet Explorer with the GIF extension. I can >then > >use the LAUNCH <PATH:FILENAME.EXT> and it will launch the GIF and show as > >animated. When you close it out, it returns back to Rbase. This is good, > >if I could get the filename into a variable from the column ImagData which > >shows in the table as [GIF,53248,9862]. Is there a way to get the filename > >and path from the VarBit so that I can use it? ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
