Recent content by amberdextrous

Nevermind, I figured out how to perform the POST. :) The problem was with the URI. I did not have it formatted correctly...I didn't know the URI can only contain up to the question mark, and everything else must be contained in the POST body. I also found that even though my FM database has...

Nevermind, I figured out how to perform the POST. :) The problem was with the URI. I did not have it formatted correctly...I didn't know the URI can only contain up to the question mark, and everything else must be contained in the POST body. I also found that even though my FM database has...

No exception is thrown, but FileMaker generates an error that is returned to me in the String xml variable. This is the xml that is returned: <?xml version="1.0" encoding="utf-8" ?> <anyType xmlns:q1="http://www.w3.org/2001/XMLSchema" d1p1:type="q1:string"...

Warning, I'm an extreme newbie to this stuff, I'm actually an intern so I'm still learning. I wasn't sure who would be more likely to know how to help me, FileMaker experts or ASP.NET experts, so I posted in both forums. I am trying to send GET and POST requests to a web-enabled FileMaker...

Let me clarify...this is an ASP.NET web service. I also posted this in the ASP.NET forum to see if anyone there can help. I got my Find function working, and I am now able to run queries against the database using HTTP GET and the results are returned to me as XML. However, I am still having...

Oh man, I really hope someone can help me. I am an IS intern and I am very new to Visual Basic, very, VERY new. I guess you could say I'm self-teaching myself on the job, but I am taking a class next semester. Anyway, my company uses two FileMaker systems that integrate. When you click...

Found out we have FMConnector, and we can use that along with FileMaker's web companion to replicate data to SQL Server. Not sure about the inner workings, but it does work. :)

Ahh, I did some tinkering and got it to read the data in to the ArrayList and output to a text area. public void processSQLSelect(String sqlCommand) throws SQLException { view.getJScrollPane().setViewportView(view.getJtasqlResult())...

Thanks, but I couldn't get it to work. Here's the code I have now: public void processSQLSelect(String sqlCommand) throws SQLException { view.getJScrollPane().setViewportView(view.getJtasqlResult()); statement = connection.createStatement(); try { ResultSet resultSet =...

Hello all, I'm developing an app that connects to a database (in my case, an Access database) and can run SQL queries against it (select, insert, delete, etc.). I'm trying to read data from the database using a ResultSet so I can output it to a JTable. There are several tables in the database...

Correction: FileMaker Pro 6 is what the client machines use. FileMaker Server 5.5 is where all the data is stored.

Hello all, My company uses MS SQL Server 2005 and FileMaker Pro 6. I'm developing an application that needs to access FileMaker data, but it needs to get it from a SQL Server table. So, I need to be able to automatically replicate the data from a table in FileMaker to a matching table in SQL...

Thank you! I'm a VB newbie so I had never heard of this, but I did some research and it looks like it will work fine for my app. So I guess the problem was that a higher priority event was being processed before a lower-priority one? At first I was concerned because I read about the risks...

This is probably going to sound like a really dumb question. In my program, the user selects values from 3 drop-down lists and hits the "Export" button, and the values are passed as parameters to a SQL Server 2005 stored procedure. The results of the query are stored in a dataset, which is...

Ah, that does make sense. That may a better option. Thanks for all your help!