Jump to content

  •  

Photo

Update Statement


  • Please log in to reply
1 reply to this topic

#1 Ocean West  I have an idea!

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

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