Home » Developer & Programmer » Forms » Copy (Forms 4.5)
Copy [message #573631] Tue, 01 January 2013 06:41 Go to next message
mdamjad
Messages: 45
Registered: May 2005
Member
I want to copy contents of cid.idate to id.idate . please give the code for the same /forum/fa/10571/0/
  • Attachment: copy.JPG
    (Size: 199.62KB, Downloaded 1106 times)
Re: Copy [message #573632 is a reply to message #573631] Tue, 01 January 2013 07:53 Go to previous message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
These are two different multi-record blocks. How are they related? What does "copy" mean? At what moment do you want to copy these values?

One option is to loop through all records in the CID block and update corresponding records in the ID block. You're in problem if these blocks do not contain equal number of records.

Another option is to perform UPDATE statement, just as you do that in SQL*Plus - it means that you have to know how these blocks (possibly, underlying tables) are related.

Then, there's the item Property Palette which - under the Data node - contains "Copy value from item" and "Synchronize with item" properties. Perhaps you could utilize these features.
Previous Topic: web colors on developer suite
Next Topic: how to programatically change relationship in master-detail block
Goto Forum:
  


Current Time: Wed Apr 24 00:36:45 CDT 2024