Sign in to follow this  
Followers 0

Update Statement

2 posts in this topic

Posted

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

Share this post


Link to post
Share on other sites

Posted

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.

UpdateTest.pdf

0

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0