When you concantenate as you suggest, then you have to know the length of
the binary offset to the beginning of a "individual file" and its' length
to retrieve it back as a separate file. The custom Function I was alluding
to would have to bury a custom marker EOF for each of the files, that
could be retrieved based on the marker rather than the binary offsets.
I just don't see an upside to the concept.
----- Original Message -----
From: "Alastair Burr" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, June 02, 2010 10:27 AM
Subject: [RBASE-L] - Re: Multiple Images
Can the images be concatenated outside R:Base?
Back in the "good old" DOS days you could use:
File1 + File2 = File3
I believe that still works but how could you move between images?
But then why would you really want to? In order to be reasonably
future-proof I would put the images separately into a table and link
specific groups together with group and sequence numbers. If you don't
want the images in a table you can still link filenames the same way. You
can get over having duplicate images that way as well.
On the other hand you can make images with a number of "pages" but it
still seems the harder way around. Sooner or later you'll meet the limit
for filesize somewhere as well. Or some other limit or problem.
It's one of those good ideas that you really can't fault but are more
trouble than they're worth in the long run. (And, believe, me, I've had
plenty myself until someone has "explained" to me why it might just be
better another way.)
Regards,
Alastair.
From: [email protected]
Sent: Wednesday, June 02, 2010 2:40 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Multiple Images
The Blob editor has a tab that allows multiple images to be added or
removed
from the field data. This editor is probably a program outside of
"Rbase" and
thus "MAY" not have the ability to use command line parameters. Again, I
am
assuming here and not stating I know for certain.
VARBIT variables do not allow any expressions, such as combining /
adding.
I.E. Set var vTest VarBit = (.vImage + .vImage1) is not allowed.
So I must assume that adding multiple images to a VARBIT type data field
via
an Rbase command is not available at this time. The reason it can be
done
via the Blob editor, is that the graphic file is loaded into a program
other than
Rbase and is manipulated. This program then saves the modified graphic
file
back into Rbase.
-Bob
----- Original Message -----
From: "Claudine Robbins" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, June 2, 2010 8:01:08 AM GMT -06:00 US/Canada Central
Subject: [RBASE-L] - Re: Multiple Images
Thank you Tony,
I concur with your analysis but this is for Jean-Marc Massé and I suspect
that this concerns technical drawings that may be small enough to not
load
the table down. He apparently has it working the way he wants to in terms
of
display. His question is for loading additional images into a field
where
images already exist.
Claudine
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of A.G.
IJntema
Sent: Wednesday, June 02, 2010 3:02 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Multiple Images
Hi,
I don't know how much images you like to load into your database, but in
most cases I prefer to store images outside the database and only create
a
link to them.
If it is organized in this way you are able to create a one to many
relationship. The many-relationship then contains the link to the
specific
image. If there are more pictures connected to the master table, you
are
able to show them in a form or a report
Even in the case you like to store pictures in the database itself you
can
make use of the one - many relationship
Succes
Tony
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Claudine
Robbins
Sent: woensdag 2 juni 2010 4:44
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Multiple Images
Thank you Mike.
Yes and yes, he using a varbit.
This is the code he uses to load one image:
SET VAR vimage VARBIT = NULL
SET VAR vimage VARBIT = ['\nomdelimage.JPG']
UPDATE tableX SET ChampPhoto = .vimage WHERE condition
Now, he would like to add additional images to the same field.
Claudine
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Mike
Byerley
Sent: Tuesday, June 01, 2010 9:35 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Multiple Images
Is it multiple images into the same field? BTW, it should be varBit not
varChar for images.
----- Original Message -----
From: "Claudine Robbins" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, June 01, 2010 10:22 PM
Subject: [RBASE-L] - Multiple Images
Hello,
Jean-Marc Massé is trying to automate the loading of multiple images into
a
varchar field.
Currently, he successfully adds images with the blob editor but would now
like to do it in code.
Does anyone have any suggestions for him?
TIA,
Claudine
--- RBASE-L
=======================3D=======================
D=
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
=======================3D=======================
D=
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
=======================3D=======================
D=
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
=======================3D=======================
D=
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
=======================3D=======================
D=
