Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 8 of 8 total
Thread adding a graphic lookup field
Thu, Nov 20 2008 9:49 PMPermanent Link

Aaron Taylor
i have table1 with a field contaning an id string.
i have table2 with a field contaning an id string and an image.

i doubleclick the table and create a new field,
name: Image, type: Graphic, type: Lookup, key fields: id, dataset: Table2, lookup keys: id, result field: image.

but when i open the table i get the error: Field "Image" cannot be a calculated or a lookup field.

i wish to add an image to table 1 when the id's match .

am i doing something wrong? tried dbisam 3,4 and paradox.
Fri, Nov 21 2008 2:20 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Aaron

Memory seems to say to me that you can't use a blob type field in lookup and possibly not calc fields.


What are you actually trying to achieve? Is it the display of an image, if so under what circumstances? Do you need a table or can you use a query and a JOIN?

Roy Lambert [Team Elevate]
Sat, Nov 22 2008 6:10 AMPermanent Link

Aaron Taylor
i have a table where the items use 1 of 4 images.
i didnt want to store multiple copies of the same image to keep the table small.

i could possible do it with a query, i havent tried.

thanx.

Roy Lambert <roy.lambert@skynet.co.uk> wrote:

Aaron

Memory seems to say to me that you can't use a blob type field in lookup and possibly not calc fields.


What are you actually trying to achieve? Is it the display of an image, if so under what circumstances? Do you need a table or can you use a
query and a JOIN?

Roy Lambert [Team Elevate]
Sat, Nov 22 2008 7:27 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Aaron


If, as I'm guessing, you simply want to display the images a lot will depend on the components used eg displaying in a dbgrid is more difficult than displaying in a TImage as the table is scrolled. What exactly are you trying to achieve?

Roy Lambert [Team Elevate]
Sat, Nov 22 2008 8:15 AMPermanent Link

Aaron Taylor
you answered the question, wast the answer i was hoping for though. thanx

i have found another way to do it but i need to know is there a way to
determine what type of image has been put into a blob field, jpg, png etc ?
Sat, Nov 22 2008 9:51 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Aaron


You can examine the file and see what it tells you. Each type should have a signature in the first few bytes. Unfortunately I can't remember what they are.

Roy Lambert [Team Elevate]
Sat, Nov 22 2008 10:51 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Aaron


For gifs the first 3 bytes MUST be GIF

Roy Lambert [Team Elevate]
Sun, Nov 23 2008 7:31 AMPermanent Link

Aaron Taylor
thanx


Roy Lambert <roy.lambert@skynet.co.uk> wrote:

Aaron


For gifs the first 3 bytes MUST be GIF

Roy Lambert [Team Elevate]
Image