v17.0; web area; 4D tags; Google Charts

2019-02-14 Thread Pierre Coulombe via 4D_Tech
I’ve used over the years 4D transformation tags (4DTEXT, 4DEVAL etc) to transfer data from 4D database to web server pages. Recently using 4D Lightning I had great success creating graphs by using $4DEVAL in javascript like this:

Re: 4D Client/Remote as Web Server

2017-08-13 Thread Pierre Coulombe via 4D_Tech
You could do a similar process using AppleScript. > On 13 Aug 2017, at 10:49 AM, Arnaud de Montard via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > >> I have 4D Client running as a web server on windows. I have the client >> write a text file every 45 seconds or so to disk. I then have a bat

Re: No, I don't want to open the structure in Read-Only mode in v.16 - so stuck I'm stuck

2017-05-02 Thread Pierre Coulombe via 4D_Tech
This happens to me when I try to edit databases from a different computer. Generally its a license thing. So, here I guess the question would be do you have the license enter in your system for v16 R2? R series require a Partners license. > On 2 May 2017, at 1:09 PM, David Hudson via 4D_Tech

Re: iNUG List "From" Change

2017-02-17 Thread Pierre Coulombe via 4D_Tech
That’s what I getting as well. > On 17 Feb 2017, at 11:54 AM, Tom Dillon via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Cannon, > > I'm getting From: 4D Tech and CC to the original poster. > > I've also noticed that some of my posts to 4D Tech list get bounced. I should > cut back on my wil

Re: v13 - C/S getting web server started

2016-10-13 Thread Pierre Coulombe
done that - but suere code to stop it would be > good :) > > On Thu, 13 Oct 2016 13:06:08 -0400, Pierre Coulombe wrote: >> Aso, depending on the OS, port 0 is configured automatically for >> Apache server. You have to stop that running before you can use 4D on >> port

Re: v13 - C/S getting web server started

2016-10-13 Thread Pierre Coulombe
Aso, depending on the OS, port 0 is configured automatically for Apache server. You have to stop that running before you can use 4D on port 80. Try port 8080. If you really need port 80, you can stop the apache server using Terminal. I can send you the coding. > On 13 Oct 2016, at 11:15 AM, Ch

Re: sql variables and 4D variables

2016-08-25 Thread Pierre Coulombe
Explains why Koen’s method works as well as his followup thoughts. It makes sense- so variables for data, and concatenation along with EXECUTE for structure work. Again thanks to both of you! Pierre > On 25 Aug 2016, at 1:05 PM, Timothy Penner wrote: > > It is my understanding that variabl

Re: sql variables and 4D variables

2016-08-25 Thread Pierre Coulombe
he << using the alternate memtion in the manual. This is in ver 15.2 TEST 2 For ($count;1;72) $sql:="alter table jotform add JT_"+String($count;"000")+" text not null" Begin SQL execute immediate :$sql; End SQL end for This works well! Thanks! > On 25 Aug 2016, a

Re: sql variables and 4D variables

2016-08-25 Thread Pierre Coulombe
Thanks, Lutz and Koen! > On 25 Aug 2016, at 9:23 AM, Epperlein, Lutz (agendo) > wrote: > > Look here: > http://doc.4d.com/4Dv15/4D/15.1/Overview-of-SQL-Commands.300-2686189.en.html > and then especially there: > "Referencing 4D expressions in SQL requests" > > That means, use : vfname > > HT

sql variables and 4D variables

2016-08-25 Thread Pierre Coulombe
I'm not very familiar with SQL, but enjoy using it to modify tables and add fields. I’m in the process of using JotForm as an intake device into a database. Its a very quick, fairly flexible, easy to use web form solution to gather data from web users. There is an API that eventually would allow