PowerSystem

I have done some more test. If the table I try to access is a synonym name, I get a onl ERROR back with jdbcFieldNames ( $table ) and jdbcGetValue ( $columnName ) Is it a bug? the query looks like (which works perfect in DBVisualizer) select sample_name, amount, location, barcode from inventory where sample_name like 'aSampleName'; Markus

Hi, I try to access a Oracle database by the JDBC Plugin (using oracle thin jar). When I use a a table or a view in the same database the sql query it works fine. If I use a synonym I only get errors back. Is there a way to access synonyms? (I tested the sql query with DbVisualizer and the same java jar, the query is correct and works) Thanks for help Markus

Hi Andreas, sorry i hadn't the time till now to go deeper into it. It's still on my list ;-) For me its the same reason like yours Markus

Hi, is there a way to use MirrorSync to sync two Filemaker servers? Markus Reinhard

I try to use the powershell from windows in "Run shell script", because I want to do more on the system than cmd.exe is able to handle. I tried a modified version of "Rund shell script" where I replaced the cmd.exe by powershell.exe, or used the original script where I send a common like "powershell mode" but I don't get any results back. Filemaker always hangs. when I send the commands by Run from Start button and then it works but not in Filemaker. Any ideas why this does not work? Markus

Hello, has someone managed to work with rxtx comm for accessing serial ports? (rxtx.org) Any help appreciated. Markus

Thank you very much for the advice, now it works fine for all the code now looks like s = new Socket(host, Integer.valueOf( port )); s.withStreams { input, output -> output << "pingn" result = input.newReader().readLine() } s.close() Markus

Hi, I try to create a function in Scriptmaster where I can connect to a TCP Service by using Sockets and get an result back. The script in Scriptmaster looks like s = new Socket(host, port); s.withStreams { input, output -> output << "pingn" result = input.newReader().readLine() } s.close() I always get an error like. [color:red]groovy.lang.GroovyRuntimeException: Could not find matching constructor for: java.net.Socket(java.lang.String, java.lang.String) what is wrong? why did Scriptmaster not find the java classes or is there an other error? the same groovy file running local on the machine has no problem the client side is like host = "localhost" port = 8000 s = new Socket(host, port); s.withStreams { input, output -> output << "pingn" buffer = input.newReader().readLine() println "response = $buffer"} the server side is like import java.net.ServerSocket def server = new ServerSocket(8000) while(true) { server.accept { socket -> println "processing new connection..." socket.withStreams { input, output -> def reader = input.newReader() def buffer = reader.readLine() println "server received: $buffer" now = new Date() output << "echo-response($now) " + buffer + "n" } println "processing/thread complete." } } Thanks Markus