Jump to content

  •  

UPGRADE DEADLINE - SEPTEMBER 26, 2014!
FileMaker Inc. has a deadline for users of version 10,11, 12 as Individual box or volume licenses (with expired maintenance).
If you don't renew your maintenance and upgrade to FMP 13 you will no longer be eligible to upgrade, at the discount pricing.

Volume Licensing upgrade pricing for FileMaker Pro 13, FileMaker Pro 13 Advanced and FileMaker Server 13 will be discontinued.
Individual upgrade pricing for FileMaker Pro 13 and FileMaker Pro 13 Advanced will increase after September 26, 2014.
As of 27-September-2014, FileMaker 10 products will no longer be available for purchase or support.

http://help.filemaker.com/app/answers/detail/a_id/13865


Photo

Update Statement


  • Please log in to reply
1 reply to this topic

#1 Ocean West  I have an idea!

Ocean West
  • Administrators
  • 2,779 posts
  • LocationSan Diego
  • FM Application:13 Advance
  • FMGo:iPhone / iPod Touch, iPad
  • Platform:Mac OS X Mavericks
  • Skill Level:Expert
  • Certification:7, 8, 9, 10, 11, 12, 13
  • Membership:TechNet, FileMaker Business Alliance
  • Time Online: 47d 2h 30m 14s

Posted 04 September 2011 - 03:26 PM

okay been banging my head on this for a while.

there are a dozen fields in TableA that I want to update in to TableB (name of fields are the same)
when the id's in both table match.

I am trying to use BaseElements plugin to do the ExecuteSQL
  • 0
Stephen Dolenski
FM Forums.com Founder, Administrator

#2 RalphL  Pooh-Bah

RalphL
  • Members
  • 1,750 posts
  • LocationSt. Louis, MO
  • FM Application:12 Advance
  • Platform:Mac OS X Snow Leopard
  • Membership:TechNet
  • Time Online: 2d 19h 47m 17s

Posted 10 September 2011 - 12:11 PM

The best I have been able to do is looping script that calls the SQL UPDATE for each row. I make 2 tables A & B, each has the field ID, F1 & F2. ID is number, F1 & F@ are text. I used different plugin but the SQL should be the same. The attached file has the script.

Attached Files


  • 0
Ralph




FMForum Advertisers