troubleshooting Question

Can't seem to get around this SQL parse error 1200 in FileMaker Pro...???

Avatar of Andrew Angell
Andrew AngellFlag for United States of America asked on
DatabasesFileMaker Pro
11 Comments1 Solution432 ViewsLast Modified:
I'm trying to do some very basic SQL updates on this FileMaker DB I'm working with and for some reason I can't get around this parse error 1200.

The table I'm working with in FileMaker is called Gourock Invoice.  I'm getting parse errors every time I try and update via SQL and I can't figure out where my problem is.

Here's one example...

UPDATE Gourock Invoice
                         SET g_PayPal_Error_Code = 10002,
                                g_PayPal_Short_Message = 'Security error',
                               g_PayPal_Long_Message = 'Security header is not valid'
                         WHERE id_invoice = 133987

g_PayPal_Error_Code is a number field, as is id_invoice (although I have tried adding quotes around those values as well).  

Here's another...

UPDATE Gourock Invoice
                     SET Credit card Authorization = '8Y781148UU567701C',
                     Card Number = '************5916'
                     WHERE id_invoice = '133987'

Card Number is indeed a text field.  I'm getting parse errors on both of these.   Apparently I need another pair of eyes to help me figure out what I'm doing wrong here.  I work with SQL all the time and I simply can't find my problem.  

Thanks!
ASKER CERTIFIED SOLUTION
lesouef
lesouef

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros