Yeah, APPEND GENERAL seems to do more than what you want, e.g. the CLASS
keyword and working with ActiveX servers. Here's a blurb from Hacker's Guide
on the CLASS keyword in APPEND GENERAL:
"The CLASS keyword allows you to specify programmatically which OLE object
is to be inserted into the general field. You can choose from the same items
available from the "Insert Object" menu pad when working interactively. The
trick to getting the right item is to determine what the class should be
called. You can find these in your documentation or in the Registry under
HKEY_CLASSES_ROOT. This clause can be used to override the default ActiveX
server if more than one is installed on your system (for example, if you
work with several programs that edit BMP files) or if the extension of the
file is not the standard extension (such as DOC for word processing
documents) used for the ActiveX server."
All this may seem overkill for what you want to do, which is something like:
if keycode = 423
append general myfield from c:\my.bmp
endif
I guess just try it on a test table and see what happens. You might also
want to search the list archives for "append general" or "append general
bmp" to see what has been said about it before.
Bill
> What I am want to do is place a bmp file into an existing table
> which has a General field based on the contents of a keycode field.
>
> That is I would like to place a 423m.bmp file into the General
> field bitmap if the keycode is 423.
>
> I am using 6.0 at home and 5.0 at work.
>
> TIA
>
> -----Original Message-----
> From: profox-bounces (AT) leafe .D.OT com [mailto:profox-bounces@leafe.com]On
> Behalf Of Bill Arnold
> Sent: Friday, May 30, 2003 9:00 PM
> To: ProFox Email List
> Subject: RE: How to update a General field
>
>
>
> Sounds like you want the Append General and Modify General commands.
>
> I haven't used general fields. I'd guess others haven't either, so venture
> to say we're interested in any feedback. My gut feeling is it
> will work just
> fine. If performance getting stuff in and out of general fields even
> approaches STRTOFILE() or FILETOSTR() speed, you'll be very happy
> with that
> too.
>
>
> Bill
>
>
>
> >
> > I have two General fields in my table.
> >
> > Now I would like to add the bmp info records based on a Keycode
> >
> > I tried Replace and was thinking about Update. How about Gather?
> >
> > How can I get the bmp images into an existing table?
> >
> > TIA
>
>
[excessive quoting removed by server]
©2003 Bill Arnold |
