Re: Calculated column in ALP v9
David:
I use the ALP 9.9.5 docs in PDF format. Look at the command
"AL_AddCalculatedColumn"
and then click the link on that page to get to "Calculated columns"
--
Douglas von Roeder
949-910-4084
On Tue, Oct 19, 2021 at 1:15 PM David Rose via 4D_Tech <4d_tech@lists.4d.com>
wrote:
> I am converting some older ALP code in a v17 database to the modern code.
> In the old code, if you have an area that is displaying fields, and you
> have a calculated column you would do this:
>
> $Error:=AL_SetFields ($Area_l;$TableNumber_i;4;1;0) //specifies the col
> as a calculated one
>
> Then this:
> AL_SetCalcCall ($Area_l;4;"MyCalcCallMethod")
>
> In the new code we set the fields like this:
>
> ARRAY POINTER(aPtr;4)
> aPtr{1}:=->[Vendors]ID
> aPtr{2}:=->[Vendors]Last_Name
> aPtr{3}:=->[Vendors]First_Name
> aPtr{4}:=?? (see below)
>
> $err:=AL_SetObjects ($Area_l;ALP_Object_Columns;aPtr)
>
> And the callback method like this:
> AL_SetColumnTextProperty ($Area_l;4;ALP_Column_Callback;"MyCalcCallMethod
> ")
>
> I didn't see in the docs what you assign to the aPtr array element for the
> calculated column. If I size the aPtr array to 3, then set a callback
> method for column 4, I get an error.
> Ditto if I size the array to 4 but don't assign anything to the 4th
> element.
>
> Pls advise.
> TIA,
> David
>
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> 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 Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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 <-> Development
I have asked a similar question over on the FORUM, and got two responses. I know more people than two have developed web pages and 4D applications working together. I really need to get into designing both. - The advantage I have is that I am starting from scratch with web development and 4D and the web. The 4D database linked over the web that I personally developed with HTML back in the early 90s are way out of date. I want to learn the new way of working, because that will future proof my skills, and the sites/Applications I develop. - The disadvantage I have is that I am starting from scratch. OK, having said that what tools do you recommend (and why)? There are so many web development tools, and so many web developers that want to gobble up the Database application behind it all (thus my work) as they ‘can do it all’. - I have seen talk about Angular, AngularJS, React ( Frameworks - correct). - There are new tools in 4D since back in the early 90s obviously. - Yes, REST is important, but what does that mean. A white paper from 4D on 4D v19 and the web and working together would be very nice to have. The web sites I developed way back then, everything was in 4D. I wrote all the static HTML and stored, and sent it out from 4D. That was then, but from what I understand now things can work better as the WebServer itself can interpret the JavaScript to execute code there - thus being faster. Of course scalability is important to. No use using a tool that cannot scale. I remember the first time I installed at a site with 150 concurrent users, and a 20 x 300 foot chart room that would be put into our system along with all new data. That scared me, but 4D 2004 did it. Any comments, thoughts, warnings, or drop by and say hello are all appreciated. Thanks Jody Bevan ** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com 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: 4D <-> Development
My 2¢ is that you should start with simple server side rendered html (i.e, use the 4D Transformation Tags in templates sent with WEB SEND FILE($t_responseToSend)). Don't worry about using front-end technology until you need it (and, you really only need it (and REST APIs) if some other system (an phone app, another web app) needs access to your data. I use Web Send File so that my file storage isn't 'revealed' by my urls. I.e. 'main/account/user_profile' doesn't necessarily map to my web folder template layout. On Wed, Oct 20, 2021 at 10:17 AM Jody Bevan via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I have asked a similar question over on the FORUM, and got two responses. > I know more people than two have developed web pages and 4D applications > working together. > > I really need to get into designing both. > > - The advantage I have is that I am starting from scratch with web > development and 4D and the web. The 4D database linked over the web that I > personally developed with HTML back in the early 90s are way out of date. I > want to learn the new way of working, because that will future proof my > skills, and the sites/Applications I develop. > > - The disadvantage I have is that I am starting from scratch. > > OK, having said that what tools do you recommend (and why)? There are so > many web development tools, and so many web developers that want to gobble > up the Database application behind it all (thus my work) as they ‘can do it > all’. > > - I have seen talk about Angular, AngularJS, React ( Frameworks - correct). > - There are new tools in 4D since back in the early 90s obviously. > - Yes, REST is important, but what does that mean. > > A white paper from 4D on 4D v19 and the web and working together would be > very nice to have. > > The web sites I developed way back then, everything was in 4D. I wrote all > the static HTML and stored, and sent it out from 4D. That was then, but > from what I understand now things can work better as the WebServer itself > can interpret the JavaScript to execute code there - thus being faster. Of > course scalability is important to. No use using a tool that cannot scale. > I remember the first time I installed at a site with 150 concurrent users, > and a 20 x 300 foot chart room that would be put into our system along with > all new data. That scared me, but 4D 2004 did it. > > Any comments, thoughts, warnings, or drop by and say hello are all > appreciated. > > Thanks > > Jody Bevan > > ** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com 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: Calculated column in ALP v9 [SOLVED]
That's it! Thanks, Doug. --- I use the ALP 9.9.5 docs in PDF format. Look at the command "AL_AddCalculatedColumn" and then click the link on that page to get to "Calculated columns" Douglas von Roeder ** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com 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: Calculated column in ALP v9 [SOLVED]
David: You're welcome. There's a lot in ALP now — wait till you see V11. :-) -- Douglas von Roeder 949-910-4084 On Wed, Oct 20, 2021 at 12:21 PM David Rose via 4D_Tech < 4d_tech@lists.4d.com> wrote: > That's it! Thanks, Doug. > --- > I use the ALP 9.9.5 docs in PDF format. Look at the command > "AL_AddCalculatedColumn" > and then click the link on that page to get to "Calculated columns" > Douglas von Roeder > > > ** > 4D Internet Users Group (4D iNUG) > New Forum: https://discuss.4D.com > 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 Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com 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: 4D <-> Development
I will add (others can fell free to differ) I have done a (very) small amount of work with/learning React (about 3 months). It is (to me) a VERY steep learning curve, and unless you NEED, I feel that simple Javascript is going to be a better friend. Chip > On Oct 20, 2021, at 1:17 PM, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I have asked a similar question over on the FORUM, and got two responses. I > know more people than two have developed web pages and 4D applications > working together. > > I really need to get into designing both. > > - The advantage I have is that I am starting from scratch with web > development and 4D and the web. The 4D database linked over the web that I > personally developed with HTML back in the early 90s are way out of date. I > want to learn the new way of working, because that will future proof my > skills, and the sites/Applications I develop. > > - The disadvantage I have is that I am starting from scratch. > > OK, having said that what tools do you recommend (and why)? There are so many > web development tools, and so many web developers that want to gobble up the > Database application behind it all (thus my work) as they ‘can do it all’. > > - I have seen talk about Angular, AngularJS, React ( Frameworks - correct). > - There are new tools in 4D since back in the early 90s obviously. > - Yes, REST is important, but what does that mean. > > A white paper from 4D on 4D v19 and the web and working together would be > very nice to have. > > The web sites I developed way back then, everything was in 4D. I wrote all > the static HTML and stored, and sent it out from 4D. That was then, but from > what I understand now things can work better as the WebServer itself can > interpret the JavaScript to execute code there - thus being faster. Of course > scalability is important to. No use using a tool that cannot scale. I > remember the first time I installed at a site with 150 concurrent users, and > a 20 x 300 foot chart room that would be put into our system along with all > new data. That scared me, but 4D 2004 did it. > > Any comments, thoughts, warnings, or drop by and say hello are all > appreciated. > > Thanks > > Jody Bevan > ** > 4D Internet Users Group (4D iNUG) > New Forum: https://discuss.4D.com > 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 Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
