Author Topic: Comparing outlook ID's  (Read 1042 times)

Bernard De Jonghe

  • Member
  • *
  • Posts: 17
Comparing outlook ID's
« on: January 03, 2016, 04:11:04 PM »
I have been observing a strange thing:
If I read out (PCEM_GetFirstRecord) an Outlook ID in a variable $OutlookID and if I use this variable to search for the corresponding record in Filemaker I do a "Perform Find" script step where the search flied is Contacts::Outlook_ID and the argument is $OutlookID.

Both values are very long strings in text format.

This search does not work, because filemaker selects all the contacts records that have a Outlook_ID. 
Normally only one record should be found.

I found a work around (temporary ?) by only taking the last 20 characters of $OutlookID in the variable and let preceed it by a *.
When I use this string in the perform find script step, it works.

But I don't feel confortable with it. 

Did someone else already see this behaviour, and is there another more reliable solution to this?

Thanks.
Bernard.

Paul Dacanay

  • Global Moderator
  • Member
  • *****
  • Posts: 47
Re: Comparing outlook ID's
« Reply #1 on: January 07, 2016, 05:28:16 PM »
You can use the entire string value, if you make your query "exact" by inserting two equal symbols to the beginning of your search criteria.

For example:

==000000002A2E0CB584189944A4B4BF0D1F1824E3070047B6FD465416134DB9A88F5B3311E35F0000000099280000050BF2D92AC1CA419580B67E59B49A8F00003C8B36FD0000

This should provide a find that isolates the specific record you are searching for. Try this and let us know how it works for you.

Thank you for using our plug-in!

Bernard De Jonghe

  • Member
  • *
  • Posts: 17
Re: Comparing outlook ID's
« Reply #2 on: January 09, 2016, 06:26:00 AM »
Paul,
This was the right answer.  Works perfectly.
Thanks for your help.
Bernard.