Re: How to Modify a column using SQL
Thanks for the info John. I'm not planning on going to v18 until it is mature. I'm a little superstitious for even numbered versions! Cheers - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: ORDA RELATE MANY SELECTION
> RELATE MANY SELECTION is a convenient way to get a set of related many > records. > Is there a more succinct or efficient ORDA method than the following to do > the same thing? Just dot follow the relation name $clients:=ds.Client.query() $relatedmany:=$clients.ManyRelationLinkName This produces an entity selection of the related many Neil --- Privacy Disclaimer: This message contains confidential information and is intended only for the named addressee. If you are not the named addressee you should not disseminate, distribute or copy this email. Please delete this email from your system and notify the sender immediately by replying to this email. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. The Alternative Investments division of UMB Fund Services provides a full range of services to hedge funds, funds of funds and private equity funds. Any tax advice in this communication is not intended to be used, and cannot be used, by a client or any other person or entity for the purpose of (a) avoiding penalties that may be imposed on any taxpayer or (b) promoting, marketing, or recommending to another party any matter addressed herein. ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
ORDA RELATE MANY SELECTION
Hello,
RELATE MANY SELECTION is a convenient way to get a set of related many records.
Is there a more succinct or efficient ORDA method than the following to do the
same thing?
// get Contracts for a group of Clients
ARRAY TEXT($array;0)
C_COLLECTION($col)
$clients:=ds.Client.query("Name = :1";"@"+Self->+"@") // get the clients
$col:=$clients.toCollection("PriKey") // make a Collection of Client Primary
Keys ("PriKey";"..Value..";"PriKey...)
COLLECTION TO ARRAY($col;$array;"PriKey") // make it an array of Primary Keys
ARRAY TO COLLECTION($col;$array) // back to a Collection of Text
("..Value..";"..Value..")
EntSel:=ds.Contract.query("to_Client IN :1";$col) // search in the Collection
Thanks - Keith CDI
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
4D Integration with FormStack or similar commercial forms tool API?
Has anyone done a project with FormStack, which is a forms-creation tool? My understanding is that FormStack allows you to create a form and drop it into a frame on a website. When the customer fills out the form, FormStack can send the content to anywhere using its API's. I'm interested in: > What API did you use, and could you share any sample code? > What issues did you address to direct the FormStack API to the 4D database? > What firewall issues did you have to address to protect 4D? > Do you have a 4D database outside the firewall, for purposes of collecting > the data? If so, where is it hosted? Or - do you have any analogous solution you've created with a commercial website sending data to your 4D database? Many thanks for the sharing! Bob Miller Parker Hannifin Corp. ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
