×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Update multiple table data in the same form

Update multiple table data in the same form

Update multiple table data in the same form

(OP)
Well Im a clarion programer (beginner) so I need to update data from diferent tables using the same update procedure.

(In the same window can update costumer and detail for envoice)

Actually I can call the update procedure using a button, but i want in the same window.

If you can help, i really apreciate.

Jorge Garcia

RE: Update multiple table data in the same form

The basic FORM template updates only one table but that does not prevent you from embedding source code to do the remaining. If you are using ABC and you want the update of the Secondary files to take place after the Primary file update, the embed point is Window Manager --> Take Completed --> after Parent Call. The code would be like :

IF NOT ReturnValue  ! if primary file update was sucessful
   Relate:SECFILE1.Update()
   Relate:SECFILE2.Update()
   ...
END

If the the procedure is a basic WINDOW procedure, you could place the code in the EMBED of the OK button.

In your case the INVOICE would be the Primary File and CUSTOMER would be the secondary file.

RE: Update multiple table data in the same form

Hi,

A cool way to do what you want is to declare a VIEW. Look in the help it shows how to do it.

Valery.

RE: Update multiple table data in the same form

I think there will be a problem with a VIEW as it updates only the PRIMARY table and not the SECONDARY ones.

RE: Update multiple table data in the same form

(OP)
TNX Vpos and ShankarJ,,, I really apreciate your help.

And it works great.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close