Backups in v18

2020-08-05 Thread Aaron via 4D_Tech
Wondering if people have the same observation in 4D v18 vs v17 , regarding backups. Seems odd (to me) to backup a system based on the name of the App/Structure instead of the name of the database. Curious if other people saw this, or if there is a feature I'm unaware of? I do have an open

Re: Linefeed option not working for v16 emails

2018-11-02 Thread Aaron via 4D_Tech
Hi Janet Back in march we had the same issue. we opened case 138474 with 4D. Sort term: We just went back to using the (4DInternetsCommand) older plugin from v15.5 (it’s dated 10/20/17) with the v16 server. Though our long term plan is to convert all emails from CR to CRLF because that

Re: Zipping files

2017-07-28 Thread Aaron via 4D_Tech
Hi Have you considered this for zipping files? C_TEXT($command;$input;$output;$args;$err) $command:="zip /users/aaron/documents/log.zip /users/aaron/documents/log.txt" LAUNCH EXTERNAL PROCESS($command;$input;$output;$err) on windows you could install 7zip, and use that > On Jul 28, 2017, at

RE: 4D SQL Implementation

2017-04-17 Thread Aaron via 4D_Tech
You can parameterize with SQL Execute using "SQL SET PARAMETER" So any part that User enter should be using that. You cannot parameterize and array. I’m not aware that IN is parametrizable in MYSQL or MSSQL either (though I suppose I could be wrong) MYSQL/PHP for example only supports a

Re: 4D SQL Implementation

2017-04-17 Thread Aaron via 4D_Tech
> You still can't use local variables in a EXECUTE IMMEDIATE SQL statement in a > compiled application? Is it really that difficult to implement? alternatively you can use SQL EXECUTE to still be able to use local variables, and build your query dynamically sample: C_TEXT($sqlStmt)

Re: tab seperated text - what to use for Cr

2017-03-16 Thread Aaron via 4D_Tech
In my excel version a tab delimited file as long as the field has DoubleQuotes, then the tab delimited file can contain a LineFeed hex:0A in that field Then it will not cause a row break, it will instead contain a new line within the cell. If you don’t have the double quotes then excel will