Search results for query: *

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!

Pure genius! This does indeed work! The only difference is I chose to use NULL in the ELSE statement, rather than a value. Then I know there's no possible way the invalid data could be returned to the user with inaccurate dates/times. Seeing as how this company wasn't even around in 1900, I...

These solutions are what I was thinking needed to happen. It seemed like a problem that needed to be fixed on the user application side, but a trigger would also make a lot of sense. Yes, the values are inserted via an application. The user populates most of the fields in the table via the...

Ok, I am pulling my hair out over this. I developed a VB program that has 3 drop-down lists: Agency/Client code, a start date & time, and an end date & time...the latter 2 are DateTimePickers. The user selects from these drop down lists and hits a button, which then passes the selected values...

Thanks guys, I talked to my manager and ended up going more with Bob's suggestion. I took the query out of my VB code, and instead made a stored procedure in SQL Server with it, and gave column aliases to all the columns. At least that way after we deploy the application, if we find that we...

I have a problem creating an XML file from a SQL Server 2005 table. This is all within a VB 2005 program I'm making. I run a query against the table and store the results in a dataset. Then I call objDataSet.WriteXML() Unfortunately, the table is poorly designed. All the columns have spaces...