Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 8 of 8 total |
adding a graphic lookup field |
Thu, Nov 20 2008 9:49 PM | Permanent 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 AM | Permanent 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 AM | Permanent 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Aaron
For gifs the first 3 bytes MUST be GIF Roy Lambert [Team Elevate] |
Sun, Nov 23 2008 7:31 AM | Permanent 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] |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |