dino Posted April 11, 2009 Share Posted April 11, 2009 Hi, Maybe I'm missing something basic here but i have made a container field and have placed it onto my layout with the Insert>Field command. But I can't see the field when i return to Browse Mode so naturally I can't use the Insert Picture command. What am I doing wrong? Thanks Dino Quote Link to comment Share on other sites More sharing options...
Weetbicks Posted April 11, 2009 Share Posted April 11, 2009 you'll need to turn borders on for the field. In layout mode, right click the field and choose field/control-> borders, and ensure top/left/bottom/right borders are on. Now with that on you can give the field some line width & colour to be able to see it. Also , if that does not work, ensure the field can be entered in browse mode. Again field/control -> Behaviour , ensure browse mode is ticked. Quote Link to comment Share on other sites More sharing options...
dino Posted April 11, 2009 Author Share Posted April 11, 2009 Thanks! That did it. This is my way of trying to get around FileMaker's non-support of BLOBs with external datasources, in my case MySQL. I assume that's the case with FMP 10? I have subject images as low res previews as a blob in a MySQL table and would dearly love to access those but can't. So I have to think of another way... I have the path to the image and the image filename so I'm hoping to be able to utilize that to go to the server and pick up the original image. I'm thinking I can make use of scripts for that. Any ideas? Quote Link to comment Share on other sites More sharing options...
AHunter3 Posted April 11, 2009 Share Posted April 11, 2009 If you have the path to the image, you do not NEED a script. Or at least you do not need a script unless you intend on importing the image itself (as opposed to merely displaying it) into the database. You can DEFINE a calculation field of result type = "container" with the field def being "imagemac://" or "imagewin://" plus the path. Quote Link to comment Share on other sites More sharing options...
dino Posted April 22, 2009 Author Share Posted April 22, 2009 Just a followup question on this... If I have a container field as described above I can certainly enter an image path and name as a full UNC network path eg imagewin://sideshow/SchoolImages/Mater-Cristi/100.jpg But I need to have a different path and image for each record because each record has a different photo. How can I do that? I know the path and image number because they are in a text field but I need the imagewin: formula to change for each record Thanks heaps Quote Link to comment Share on other sites More sharing options...
Weetbicks Posted April 22, 2009 Share Posted April 22, 2009 pretty much in the same way AHunter described above, calculation, result type of container, and the container is set to a calculated path. "imagewin://" & PathField & FileName Something like that…… Quote Link to comment Share on other sites More sharing options...
dino Posted April 22, 2009 Author Share Posted April 22, 2009 Yes I did that and I get one image in and it's the same for each record. I need each record's image to be different though. Basically I have a subject's table and in there is a field with the imagepath and filename which I can concatenate into one field - no problem there. But each record has a different path/filename so how I do I get that dynamic path into the one calculation? Sorry if I'm sounding thick!!! Quote Link to comment Share on other sites More sharing options...
AHunter3 Posted April 22, 2009 Share Posted April 22, 2009 PathField and FileName are two FileMaker Pro fields. They should have values that are different in each record, reflecting the path and the filename that are appropriate to that record. The calculation field is therefore also going to end up being different for each record. Quote Link to comment Share on other sites More sharing options...
dino Posted April 23, 2009 Author Share Posted April 23, 2009 Guys, Thanks to you both for your help. I really appreciate it. I have it working now thanks to you. If only Filemaker Pro supported BLOBS this would be so much easier! Dino Quote Link to comment Share on other sites More sharing options...
AHunter3 Posted April 23, 2009 Share Posted April 23, 2009 They've come a long way very fast in supporting SQL data sources as equal partners (after, admittedly, years of languishing away with FileMaker-4 / FileMaker-5 calibre functionality); maybe 10.1 or 10.5 will support BLOBs. Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.