Re: Witango-Talk: Filemaker Pro Syntax error

Alway read (and re-read) the FMI xDBC guide. The reserved words are in there, too. I work in SQL and FM databases every day. I need to re-read these docs frequently. :) Also, I don't use any of the query builders.

Re: Witango-Talk: Filemaker Pro Syntax error

Eureaka! Thanks Robert, I'm off and running now! I'll switch over the using JDBC and go from there. At least one thing was accomplished today. Thanks again! I'll let you know if something else odd occurs. Terry On 8/17/11 2:54 PM, "Robert Shubert" wrote: AH - you just hit it. Sorry I didn't

RE: Witango-Talk: Filemaker Pro Syntax error

AH - you just hit it. Sorry I didn't notice it sooner... "LAST" is a reserved work in ODBC. See here: http://sqlserver2000.databases.aspfaq.com/what-are-reserved-access-odbc-and-sql-server-keywords.html therefore you need to escape any such words if they are column names. Witango/TeraScript doe

Re: Witango-Talk: Filemaker Pro Syntax error

Robert here's what my manager discovered, if you request the data first then which column it located in, it works. SELECT * FROM PersonnelFile where 'Gadina' = "Last" We have to double quote the column name or it fails. Is this known in Filemaker? On 8/17/11 1:31 PM, "Robert Shubert" wrote:

Witango-Talk: Redirects

I have a client that has two domains. One is for Spanish version and one for english. Right now switching languages just takes you to the home page of whichever site. I did it that way because it was safer and easier. But I do have a URL variable in the string so I know the exact location they w

RE: Witango-Talk: Filemaker Pro Syntax error

Terry, Continue to evolve the Custom SQL Query until it matches the one that is giving the syntax error. You should bump into the problem. Also, if you can view the SQL statements in debug if you aren't already. Post any differences. Look for specific things like spaces, quotes and case. Rober

Re: Witango-Talk: Filemaker Pro Syntax error

OK this is the screwiest thing I've every witness. It worked! I can't understand why this worked and selecting the columns from the very table does not! On 8/17/11 1:05 PM, "Robert Shubert" wrote: Terry, Can you build a TAF with a Custom SQL Query and do some simple tests, like Sele

RE: Witango-Talk: Filemaker Pro Syntax error

Terry, Can you build a TAF with a Custom SQL Query and do some simple tests, like Select 1 Or Select count(*) from PersonnelFile Just try "stepping into" your statement to determine where the syntax error is. One of the biggest points of grief with FM is that their ODBC and JD

Re: Witango-Talk: Filemaker Pro Syntax error

Hi Robert, Exactly my point, I am getting a response from the server. We've double checked the drivers and they are the same on both sever and client. Directly from the FM updater_11.0.3.312. I'm querying the correct columns from the PersonnelFile table, which are displayed without a hitch

RE: Witango-Talk: Filemaker Pro Syntax error

Terry, Are you using FileMaker 11.3? Are the ODBC/JDBC drivers at the same version as the server? (this is critical) Is the SQL statement incorrect? (column and table named correct, etc) The good news is that you are getting a response from the server (or at least the ODBC subsystem). Robert

Witango-Talk: Filemaker Pro Syntax error

My first time attempting to run queries against Filemaker Pro via Witango 5.5 and Terascibe 6. I have successfully connected from Witango 5.5 and Terascribe to the Filemaker Pro DB using ODBC and JDBC, however when I run my DBMS query: SELECT Last,First FROM PersonnelFile WHERE Last='x' I