You can utilize the New WinUdf command that Razaak and the dream team
worked so hard to bring to you to accomplish everything you want, but you
will have to foray into VB/VBScript/JScript to accomplish it. There is an
example in the 6.5PPp3 that utilizes a script to create a properly parsed
file containing elements for a #List command preparatory for a Choose. You
could utilize this functionality to create a list that could be manipulated
using the SSUB function to not only insert the Blob data, but based on its
fully qualified Pathname, store that as well in the Database. These
examples are also posted on my website (www.byerley.net and click the
Bauerlie Development link). Further on the site is an ActiveX component
that contains among many things, a windows FileOpen Dialog box (This
component has extensive help file with it)to help you navagate to the
directory of your choice. All the code there is anotated whether or not it
has example RBase code to help you use it.
----- Original Message -----
From: "Phil (Direct Account)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 02, 2002 1:20 AM
Subject: RE: Storing Pictures (GIFs) in database - Razzak's Reply
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/
================================================ 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/
