AnsweredAssumed Answered

Inserting Quicktime files into containers with JDBC

Question asked by user18884 on Feb 15, 2013
Latest reply on Feb 18, 2013 by user18884

I'm trying to insert an aif file into a Filemaker container using JDBC. The data is successfully inserted, but no player is shown on the UI. When I insert the same file using the Insert Quicktime dialog on the database the file is inserted and a player appers on the UI.


I inserted the file using this SQL statement:


sql = "Update OrdServ set "Contenedor Voz" = PutAs(?, 'aif ') where "Folio de Servicio" = '14' ";


Once data is inserted with JDBC, I get "Untitled" as container metadata (using SELECT CAST("Contenedor Voz" AS VARCHAR(100)) FROM OrdServ where "Folio de servicio" = '14'). When I insert the same data using the UI I get this "movie:test.aif moviemac:/Macintosh HD/Users/rodolfo/Downloads/test.aif"


How I replicate Filemaker's metadata with JDBC?