• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Trouble with simple Find in FMP data base
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Trouble with simple Find in FMP data base


  • Subject: Trouble with simple Find in FMP data base
  • From: Chap Harrison <email@hidden>
  • Date: Fri, 23 Jan 2004 11:37:57 -0600

The following script generates an error on the find statement (FMP is running, LineItems DB is open, and InventoryCode is defined as text).

-- FMP error: Unable to coerce data to the desired type"

When I use literals ("T5840", etc) in the find statement, instead of variables, I get a syntax error:

-- Can't get "T5840" in cell "LineItemsID" of database "LineItems.db5". Access not allowed.

I need a clue! Anyone?
Thanks, Chap

-- start script
set myValue to "00002"
set myCell to "InventoryCode"
set myTable to "LineItems.fp5"

tell application "FileMaker Pro"
find myValue in cell myCell of database myTable
end tell
-- end script
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.

  • Follow-Ups:
    • Re: Trouble with simple Find in FMP data base
      • From: Gary Lists <email@hidden>
    • Re: Trouble with simple Find in FMP data base
      • From: Bill White <email@hidden>
    • Re: Trouble with simple Find in FMP data base
      • From: Andrew Oliver <email@hidden>
  • Prev by Date: Getting Attachments from Mail
  • Next by Date: Re: Trouble with simple Find in FMP data base
  • Previous by thread: Re: Getting Attachments from Mail
  • Next by thread: Re: Trouble with simple Find in FMP data base
  • Index(es):
    • Date
    • Thread