Author Topic: Check Query  (Read 1460 times)

VTuser

  • Member
  • *
  • Posts: 4
Check Query
« on: September 19, 2013, 12:10:02 PM »
I need to run check query, can anyone help please.

Thanks

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 470
Re: Check Query
« Reply #1 on: September 19, 2013, 01:22:43 PM »
The manual and the On Screen Reference (OSR) should provide a good starting point. The OSR is currently found at https://developer-static.intuit.com/qbSDK-current/Common/newOSR/index.html

If you have a more specific question, fire away....

Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852

VTuser

  • Member
  • *
  • Posts: 4
Re: Check Query
« Reply #2 on: September 19, 2013, 07:28:08 PM »
I have been through the OSR with no success.

What I want is to query check and pull all Check Written in QB, also if possible to run query using the COA references?

Attached is my script
 Error 1 always pop up.

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 470
Re: Check Query
« Reply #3 on: September 20, 2013, 06:57:04 AM »
When you say "Error 1" do you mean the result includes "Status Code: 1" in the result message?
If so, it means a query request did not find a matching object in QB.

What's the value of Main::gPull_FullName?
Does the value match a Name or FullName value in one of QB's Lists? (Vendor, Customer, Employee, Other)?

Are you running FileMaker Pro Advanced?
If so, are you walking through your script using the Script Debugger?

Are you getting a value in Main::gCountry?
If so, it narrows down the source of the error.

HTH!

Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852

VTuser

  • Member
  • *
  • Posts: 4
Re: Check Query
« Reply #4 on: September 21, 2013, 12:24:42 PM »
Thanks Geoffery,

Yes your are right with the Error 1 and I am using FM Advance to step through the script. I will check the values of field name request and get back to you.

Thank you for your support.
VTuser