

He’ll help you determine if we have the right program to fit your needs.


If you need guidance or coaching through a particularly complex topic, shoot an email to Jason Thomas. Have a quick question? Contact Greg Lane. More Informationįor more information about the file types that can be used with the GetAs() and PutAs() functions, see pages 40-42 of the FileMaker ODBC and JDBC Guide. You can also use the Cast() function to retrieve the name of the file that was inserted into a container field or a file path for a file that was stored as a reference. Import java.sql.* import java.io.* def url = "jdbc:filemaker://localhost/fmserver_sample" def driver = "" def user = "admin" def password = "" tProperty("jdbc.drivers", driver) connection = DriverManager.getConnection (url, user, password) statement = connection.createStatement () results = statement.executeQuery ("SELECT id, GetAs (img, 'JPEG') AS img FROM english_nature WHERE ID=23") if (results.next ()) connection.close()
