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/
