RE: 4D Write Pro using expressions with XML merge file (or JSON)

2017-04-03 Thread Piotr Chabot Stadhouders via 4D_Tech
.@ac-consulting.fr> > Onderwerp: Re: 4D Write Pro using expressions with XML merge file (or > JSON) > > Hi Bruno, > > Because it is easy to use xpath in 4D and easy to generate XML in Oracle this > is exactly why I think this is a nice solution. > > I am glad you

Re: 4D Write Pro using expressions with XML merge file (or JSON)

2017-04-03 Thread Koen Van Hooreweghe via 4D_Tech
Hi Piotr, I haven't done that in 4D Write, but in a normal (template) text field which contains html tags and is run trough PROCESS 4D TAGS finally being sent as html e-mail body text. In that particular case we fill a 4D object field with some info data. So the user can add the info he likes

Re: 4D Write Pro using expressions with XML merge file (or JSON)

2017-04-03 Thread Koen Van Hooreweghe via 4D_Tech
Hi Bernard, Right. I should have written: 4D does not support dot notation (yet) natively in the OB Get and Set commands. But if I'm not mistaking, rumors say that it is coming... Koen Op 2-apr.-2017, om 13:53 heeft bernard--- via 4D_Tech <4d_tech@lists.4d.com> het volgende geschreven: > 4D

Re: 4D Write Pro using expressions with XML merge file (or JSON)

2017-04-02 Thread bernard--- via 4D_Tech
Koen, 4D does not handle dot notation (not quite true : see http://doc.4d.com/4Dv16/4D/16/QUERY-BY-ATTRIBUTE.301-3036512.en.html ) ; I have written a component published on jan 12 This component emulates 4D standard

Re: 4D Write Pro using expressions with XML merge file (or JSON)

2017-03-29 Thread Piotr Chabot Stadhouders via 4D_Tech
Hi Bruno, Because it is easy to use xpath in 4D and easy to generate XML in Oracle this is exactly why I think this is a nice solution. I am glad you think the same:-) I assume one can also use attributes in xpath in 4D. Gr, Piotr Op 29 mrt. 2017 21:37 schreef Bruno LEGAY

RE: 4D Write Pro using expressions with XML merge file (or JSON)

2017-03-29 Thread Piotr Chabot Stadhouders via 4D_Tech
already done this and saving me some pitfalls. Gr, Piotr > -Oorspronkelijk bericht- > Van: Koen Van Hooreweghe [mailto:bvbacomp...@telenet.be] > Verzonden: woensdag 29 maart 2017 11:25 > Aan: 4D iNug Technical <4d_tech@lists.4d.com> > Onderwerp: Re: 4D Write

Re: 4D Write Pro using expressions with XML merge file (or JSON)

2017-03-29 Thread Koen Van Hooreweghe via 4D_Tech
Hi Piotr, I would advise JSON or rather 4D objects. 4D objects and JSON are not exactly the same, but very closely related. JSON is actually a text representation of a 4D object. The 4D debugger handles objects nicely too. You can store your data into a 4D object and then retrieve the values

4D Write Pro using expressions with XML merge file (or JSON)

2017-03-29 Thread Piotr Chabot Stadhouders via 4D_Tech
Hi All, We are using 4D Write for about 20 years now. With 4D v16R2 we think it is time to migrate to 4D Write Pro. One thing we use a lot is expressions to merge data with document templates. We don't use 4D records but we use 4D for OCI to connect to an Oracle database. 20 years ago we didn't