RE: Witango-Talk: Filemaker Pro Syntax error

2011-08-17 Thread Robert Shubert
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

Re: Witango-Talk: Filemaker Pro Syntax error

2011-08-17 Thread Lipford, Terencia (NIH/CIT) [C]
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

2011-08-17 Thread Robert Shubert
tango-Talk@witango.com Subject: 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 corr

Re: Witango-Talk: Filemaker Pro Syntax error

2011-08-17 Thread Lipford, Terencia (NIH/CIT) [C]
ango/TeraScript server version and platform for me. Thanks, Robert -Original Message- From: Lipford, Terencia (NIH/CIT) [C] [mailto:lipfo...@mail.nih.gov] Sent: Wednesday, August 17, 2011 12:26 PM To: Witango-Talk@witango.com Subject: Re: Witango-Talk: Filemaker Pro Syntax error Hi R

RE: Witango-Talk: Filemaker Pro Syntax error

2011-08-17 Thread Robert Shubert
case. Robert -Original Message- From: Lipford, Terencia (NIH/CIT) [C] [mailto:lipfo...@mail.nih.gov] Sent: Wednesday, August 17, 2011 1:29 PM To: Witango-Talk@witango.com Subject: Re: Witango-Talk: Filemaker Pro Syntax error OK this is the screwiest thing I've every witness. It worke

Re: Witango-Talk: Filemaker Pro Syntax error

2011-08-17 Thread Lipford, Terencia (NIH/CIT) [C]
ific things like spaces, quotes and case. Robert -Original Message- From: Lipford, Terencia (NIH/CIT) [C] [mailto:lipfo...@mail.nih.gov] Sent: Wednesday, August 17, 2011 1:29 PM To: Witango-Talk@witango.com Subject: Re: Witango-Talk: Filemaker Pro Syntax error OK this is the screwiest thin

RE: Witango-Talk: Filemaker Pro Syntax error

2011-08-17 Thread Robert Shubert
rms. Robert -Original Message- From: Lipford, Terencia (NIH/CIT) [C] [mailto:lipfo...@mail.nih.gov] Sent: Wednesday, August 17, 2011 2:33 PM To: Witango-Talk@witango.com Subject: Re: Witango-Talk: Filemaker Pro Syntax error Robert here's what my manager discovered, if you request the

Re: Witango-Talk: Filemaker Pro Syntax error

2011-08-17 Thread Lipford, Terencia (NIH/CIT) [C]
-Original Message- From: Lipford, Terencia (NIH/CIT) [C] [mailto:lipfo...@mail.nih.gov] Sent: Wednesday, August 17, 2011 2:33 PM To: Witango-Talk@witango.com Subject: Re: Witango-Talk: Filemaker Pro Syntax error Robert here's what my manager discovered, if you request the data

Re: Witango-Talk: Filemaker Pro Syntax error

2011-08-17 Thread BEVERLY VOTH
l Message- > From: Lipford, Terencia (NIH/CIT) [C] [mailto:lipfo...@mail.nih.gov] > Sent: Wednesday, August 17, 2011 2:33 PM > To: Witango-Talk@witango.com > Subject: Re: Witango-Talk: Filemaker Pro Syntax error > > Robert here's what my manager discovered, if you request the dat