-1

I want to know how to run FileMaker(FMP pro) database command in java. I have got the connection to database,but not sure how to execute below query.

Get(AccountPrivilegeSetName)

ref: http://www.filemaker.com/11help/html/func_ref2.32.4.html#1051898

mahesh
  • 1,523
  • 4
  • 23
  • 39

1 Answers1

1

You will need to add a calculation field in FileMaker to return as the result of the JDBC query. This is because you cannot call functions via JDBC, you can only retrieve field values.

Sam Barnum
  • 10,559
  • 3
  • 54
  • 60
  • HI Sam, how do I write a simple sql dummy statement that returns 1 from a table that works using JDBC? – mahesh Feb 28 '14 at 18:19
  • You'll need to query an actual table. If the table has no records, you'll get an empty response. You might consider creating a simple one-record table for this purpose, and just do `select dummyField from dummyTable`. – Sam Barnum Feb 28 '14 at 18:43
  • Thanks Sam Barnum for your response, I am query like below two queries but there is no response from the fmp(still running), if the query is wrong, it was perfectly saying syntax error. SELECT max(CUST_ID) FROM CUST_MARKER SELECT 1 FROM CUST_MARKER WHERE 1=1 – mahesh Feb 28 '14 at 19:08
  • i mean trying it from java stmt.executeQuery() – mahesh Feb 28 '14 at 19:08