It is difficult to see but there is a quote " followed by an apostrophe '. ![]() You will see that it is used at the beginning of the ”. One more major thing of importance is the use of the single quote mark aka the apostrophe. Any additional formatting such as bold, italic, underlines, tables, etc will require you to know more HTML, but it’s really pretty easy stuff. HTML does not know about any carriage returns I may have typed into my text field, so I have to use to tell HTML when to perform a line break. You can also see that I use in the text above. If you do not, the evaluate() function cannot determine what is text and what is a calculation that requires evaluation. It is critical that you place all non calculation text within quotes “Like This”. The following is an example of what you could input into your text field: This text data must be formatted as a calculation because we will be using the evaluate() function to interpret it. To make this work you will need a text field to store your help text in addition to the container field(s) where you store you image(s). The next thing we want to do is to combine text data with images so that everything will show up together like is does in a regular web page. This means you can construct a dynamic web page on the fly which includes any filemaker field data you want to add. This is very cool for those of you not yet familiar with this concept. This instructs the web viewer to use any text which follows as your html web page. ![]() Notice the use of the “data:text/html,” string. The following example, if placed into the calculation area of a web viewer, will display an image stored in a container field. In the examples to follow, I will be using the BaseElements plugin version of the Base64 encode function. However, if you cannot use FileMaker 13-16 yet, there is still hope for you by using the fabulous free BaseElements plugin from Goya. If you are on the cutting edge, you already own a copy of FileMaker 13-16 which has Base64 encode and decode functions built right in. Why should you care about base64 encoding? Well, it allows you to convert an image into plain text which you can then embed directly into your html code and display the result in a Web Viewer! Not too much to ask right? I also wanted to store these images in a repeating container field along with the text and then reference them directly in the web viewer without having to export them or store them on a shared drive or web server somewhere. I wanted to have images embedded in the help so that they could be displayed within the context of the help. I wanted to create a help system for my clients using FileMaker’s web viewer. ![]() 8310 is a syntax error, something in the SQL is not correctly parsed.Įrror 8309 means you did pass wrong data type, like string for a number.I have released a new version of the sample file which demonstrates how to use this technique to embed video files as well. In general error 8309 is a semantic error, so something is wrong in your SQL. ![]() There is no way to determine if an update actually occurs unless you check the value again after the update occured. The Errors number s are the same ones as the ones retuned by Native FileMaker function "Get(LastError)" Examples: 1200 - Generic Calculation Error" 200 - "Access Denied" 106 - "Missing Table" Known Limitations: Record Locking Errors are Not Reported! This means you must exercise caution when using UPDATE. Set by FM.InsertRecord, FM.SQL.Execute, FM.ExecuteSQL, FM.ExecuteFileSQL or FM.ExecuteSQLOnIdle. Queries the last error code from an SQL call MBS( "FM.ExecuteSQL.LastError" ) Parameters
0 Comments
Leave a Reply. |