Re: sql variables and 4D variables

2016-08-25 Thread Pierre Coulombe
t;< 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! >

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

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,

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

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: