Harry Posted January 28, 2014 Share Posted January 28, 2014 Hello Board! I have an external MySQL db setup and working very well. All is OK, except, i'm trying to add another field into Filemaker. I have used the Sync button before and the field just pops straight up, no problem. Today, though, i've had a BLOB field added (so i can have a barcode.png file in that field and print it onto a Layout in FM that uses the external table). It doesn't show. Is this because of the field type? I've restarted FM but i can't restart the MySQL server. Any ideas? I'm stumped, it doesn't seem to be very complicated, it never has been. There doesn't seem to be many options. H Link to comment Share on other sites More sharing options...
Harry Posted January 28, 2014 Author Share Posted January 28, 2014 Just reading through a FM doc - 'External SQL Sources In Depth'. It says that BLOB fields are not supported! D'oh! Not sure how to approach this, then. I have a Production Table (MySQL) with a Production number field, Quantity and Stock code fields. I have a Layout for a Production Order that has other fields related to these three fields that are contained in FM tables. I need a Barcode to print out of the Production Number field, so it can be scanned and auto-entered. Do i need to copy the Production Table into an FM table? Can i do auto-import routines? Thanks, H Link to comment Share on other sites More sharing options...
Harry Posted January 28, 2014 Author Share Posted January 28, 2014 Base64Decoding, might help me? Anyone used this to build/retrieve .png files? Link to comment Share on other sites More sharing options...
Harry Posted January 28, 2014 Author Share Posted January 28, 2014 Can't get this function to work! I have an encoded string inside a field and am using a Calculation field to display what should be a Barcode: Base64Decode ( barcode_base64;"BARCODE.PNG" ) barcode_base64 is a text field with the encoded Base64 string in it and the "BARCODE.PNG" is a file name, although i really don't know what i should be putting in there. I've found a reference to having to have the file extension in, but that's it. Link to comment Share on other sites More sharing options...
Harry Posted January 28, 2014 Author Share Posted January 28, 2014 Erm, Do i still need a container field to set the Base64Decoding output to? Going round in circles here.... Can a calculation field display the result of the encoded field as a .png? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3738 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now