Re: sql variables and 4D variables

[Pierre Coulombe]

As a follow up to my question, trying both suggestions, I get the following:

TEST 1

C_TEXT($fname)
$fname:="JT_070"
Begin SQL
ALTER TABLE JotForm ADD :$fname TEXT NOT NULL;
End SQL

This produces a parsing error at the ":$fname" It doesn't seem to like the : or 
the << 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, at 9:43 AM, Pierre Coulombe 
> <pierrecoulo...@day2daysolutions.com> wrote:
> 
> Thanks, Lutz and Koen!
> 
> 
>> On 25 Aug 2016, at 9:23 AM, Epperlein, Lutz (agendo) 
>> <lutz.epperl...@agendo.de> 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
>> 
>> HTH
>> Lutz
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4d.com/archives.html
>> Options: http://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: sql variables and 4D variables

[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 variables should only be used for the Data parts 
> of a SQL expression, not for the Structural parts.
> 
> I took a quick look at our examples for dynamically altering tables and it 
> seems that the examples use concatenation along with EXECUTE IMMEDIATE like 
> in this Tech Tip: Preparing for 4D v14 Journaling Code Samples - 
> http://kb.4d.com/assetid=76991 
> 
> -Tim
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: v13 - C/S getting web server started

[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, Chip Scheide <4d_o...@pghrepository.org> wrote:
> 
> THanks!
> 
> On Thu, 13 Oct 2016 15:08:11 +, Epperlein, Lutz (agendo) wrote:
>>> Box is:
>>> Mac Mini - so (thanks) but windows command line will not help much  :)
>> 
>> netstat -an | less
>> 
>> or
>> 
>> netstat -an | grep 80
>> 
>> or
>> 
>> netstat -anp | grep 80, than you can even see the process in question 
>> 
>> 
>> HTH
>> Lutz
>> 
>> --  
>> Lutz Epperlein  
>> --
>> Agendo Gesellschaft für politische Planung mbH
>> Köpenicker Str. 9
>> 10997 Berlin
>> http://www.agendo.de/
>> --
>> 
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4d.com/archives.html
>> Options: http://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D Client/Remote as Web Server

[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 batch 
>> script that runs every minute and looks for that file and deletes it.  If 
>> the file is not found it kills the 4D task and restarts 4D Client. 
> 
> Something similar on macOS, someone?
> 
> -- 
> Arnaud de Montard 
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[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: