Re: Question on 'journal' file

[Neil Dennis via 4D_Tech]

If you have backups turned on the .journal file records every transaction since 
the last backup.

This allows you to rolll the data forward from the last backup to any point in 
time.

If the file is huge it means that your data is not being backed up. Each backup 
will replace the .journal file with an empty copy.

Neil


> On Jan 18, 2024, at 3:13 PM, Lloyd Sigler via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am using 4D v18.64 and I have a file with .journal extension that is 
> several years older than the .4DIndx and .Match files.
> 
> Was the journal file dropped along the way at some point? Safe to delete it?
> 
> Thanks,
> 
> Lloyd Sigler
> 
> 
> 
> 
> **
> 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: logarithm

[Neil Dennis via 4D_Tech]

This just comes down to math:

You can calculate the log of any base if you have log of any other base.
4D has the command Log (which is a natural log based on e… 2.718 etc). We can 
use it to convert logs to any base.

If you want log base 10 do the following:

$x:=100
$log:=Log($x)/Log(10)
ALERT(String($log))

$log will be 2 as expected


If you wanted base 3 log

$x:=81
$log:=Log($x)/Log(3)
ALERT(String($log))

$log will be 4 as expected


Neil

> On Jun 29, 2022, at 3:09 PM, stardata.info via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi All,
> 
> I need to calculate a logarithm on base 10 of one number.
> 
> Someone know tha 4D Command that i can use?
> 
> Thanks
> 
> Ferdinando
> 
> **
> 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: Base64 Image

[Neil Dennis via 4D_Tech]

Look at the command BASE64 DECODE

https://doc.4d.com/4Dv18/4D/18.4/BASE64-DECODE.301-5233044.en.html 




> On Jun 4, 2021, at 5:40 AM, stardata.info via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi All,
> 
> I need to obtain an image from a base 64 string.
> 
> How i can do using 4D Commands?
> 
> Thanks
> 
> /Ferdinando/
> 
> **
> 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: How do you get a Vertical Splitter's Horizontal 'Move' Resizing Attribute to work?

[Neil Dennis via 4D_Tech]

> When pull the window wider, I'd like the text box on the left to grow, and 
> the splitter and text box on the right to move.

You might have to take control of this yourself… write 4D code to set the form 
objects sizes and positions based on windows size, then call this code on the 
windows size event.

Neil


**
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: Copy and Paste

[Neil Dennis via 4D_Tech]

> On Mar 23, 2021, at 1:42 PM, stardata.info via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 
> The problem is Copy and Past functions that after sometimes stop to work in 
> method editor.
> 
> So is not possible to Copy and Paste the rows of codes in 4D editor.
> 

When it quits working in the method editor, do the menu items still work 
(Edit:Copy Edit:Paste)?

One other thing you can try is do 3 or 4 control-C in the method editor before 
you paste.

Neil

**
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: PING of life...

[Neil Dennis via 4D_Tech]

> There is a dark mode setting in 4d discuss preferences. 

That seems to only work for the web and does not apply to email messages.

Neil
**
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: PING of life...

[Neil Dennis via 4D_Tech]

I set my settings yesterday day to mute non-English… it made me smile today 
when I opened up my email and could read every message :)

My last complaint, and it is minor is that I use dark mode on my computer. The 
new list insists on using a white background and black text, it is really 
bright compared to other applications. But is minor.

Neil

**
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: PING of life...

[Neil Dennis via 4D_Tech]

> Under Notifications/Categories on the left, select which categories you want 
> to watch and which ones to mute.

I just implemented the muted options, thank you for pointing these out :)

Neil

**
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: PING of life...

[Neil Dennis via 4D_Tech]

> Agreed.  That’s the main thing that puts me off.  I just want to see English 
> messages and not all the other clutter.

John commented on setting up your email only for the English forum… I may have 
missed this step, I wlll see if I can find it.

Neil


**
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: PING of life...

[Neil Dennis via 4D_Tech]

One think I do like about this group vs the other group is that, with very few 
exceptions, I can read all of the messages because I can understand the 
language.

I only speak two languages, English and Gilbertese… there are no Gilbertese 
messages. So I spend time on at the other place (not a lot but minutes) every 
day looking at message to see if I’m interested, the first think I do is try to 
read them, if they are in English I’m OK, if not it is wasted time.

I wish there was a filter so that I could only see messages in English.

Neil

**
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: PING of life...

[Neil Dennis via 4D_Tech]

> I must have missed an important episode here, because I don’t understand what 
> that statement means. Was there a controversy at some point? Was it recent? 
> Or years ago?

There was some heated debate recently regarding html vs pdf documentation… I’m 
assuming that is what is referred here.

Neil


**
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: PING of life...

[Neil Dennis via 4D_Tech]

I haven’t left

Neil

> On Jan 13, 2021, at 5:32 AM, Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> G’day,
> 
> Are here still enough dinosaur/old timers present to have some decent 
> discussions without that white noise and smart-arse newbies in the forum?
> 
> I’m following the lead of my neighbour David Adams and don’t participate in 
> the forum any more.
> 
> Question is, are there other oldies willing to participate WITHOUT feeding 
> anything into the forum(s) following the slogan “What happen in/on iNUG stays 
> in/on iNUG”?
> 
> 
> Cheers
> Jörg
> 
> **
> 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: Record locking woes

[Neil Dennis via 4D_Tech]

> I'd like to build a little test db to see if I can replicate it there... but 
> I probably won't.

I was able to replicate this years ago.

You could try leaving the automatic relation, but set the table in question to 
read only before the sort.

However it is best to just get rid of the automatic relations… they change 
current records a lot and cause locked records etc.

My coding practice is to use all relations manual, turn them on 
programmatically for things like selection to array etc. Then the relations 
only fire when I need them to and not everywhere. You can turn relations on and 
off on a field by field basis (unless you are using a really old version of 4d)

Neil

**
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: Record locking woes

[Neil Dennis via 4D_Tech]

> If anyone is out there...
> So is the email list obsolete?

A few people are still monitoring, I’m still here because I haven’t turned if 
off yet. But yes, I consider this email list obsolete.

I don’t think that the automatic relations loading a locking a record on a sort 
is a 4D bug. It has been this way for a while.

Neil
**
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: Hide Application Process

[Neil Dennis via 4D_Tech]

You can use the following on startup:

$l := Frontmost window
HIDE WINDOW ($l)


> On Nov 6, 2020, at 8:14 AM, David Rose via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Thanks, David. The checkbox for showing the splash screen has always been 
> unchecked.
> 
> 
> 
> From: David Ringsmuth [mailto:davidi...@gmail.com] 
> Sent: Friday, November 06, 2020 9:08 AM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: David Rose 
> Subject: RE: Hide Application Process
> 
> 
> 
> David,
> 
> 
> 
> In the Database Settings you can choose to hide the splash screen, so the Set 
> Window Rect may not be needed.
> 
> 
> 
> David Ringsmuth
> 
> 
> 
> From: David Rose via 4D_Tech  
> Sent: Friday, November 6, 2020 8:51 AM
> To: 4d_tech@lists.4d.com  
> Cc: David Rose  
> Subject: Hide Application Process
> 
> 
> 
> In a 4D v16 single-user interpreted application for Windows 10, this code in 
> the Startup method to hide the Application window has been executing 
> successfully with no problem:
> 
> 
> 
> SET WINDOW RECT(-10;-10;-10;-10)
> 
> //Win32API:
> 
> $WindowHandle_l:=gui_GetWindowFrom4DWinEx (Frontmost window)
> 
> $Error_l:=gui_ShowWindowEx ($WindowHandle_l;SW_HIDE)
> 
> 
> 
> I just installed the application on a new Windows 10 computer, and now the 
> Application window shows up.
> 
> 
> 
> How to fix?
> 
> 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 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: Trace Command in V18.3

[Neil Dennis via 4D_Tech]

Good suggestion

If you have the ability to edit the code then you should have the license to 
trace. If you are not able to edit the code you are not allowed to trace either.

Neil

> On Oct 28, 2020, at 11:35 AM, Spencer Hinsdale via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> check your license
> 
> 
> 
>> On Oct 28, 2020, at 10:20 AM, Dave Slayton via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> I just installed v18…the trace command doesn’t seem to be working….
>> anyone else having this issue or know of a work around ? 
>> TRACE
>> C_longint ($dave) 
>> $dave:=12
>> alert("dave = "+string($dave))
>> TRACE
>> 
>> **
>> 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 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: Trace Command in V18.3

[Neil Dennis via 4D_Tech]

I’m using v18R3 and trace works.

I’m assuming the sis code from a project method? And both traces are failing?

I think this is unique to you. Try it in a new database and let us know if you 
are still having problems.

Neil

> On Oct 28, 2020, at 11:18 AM, Dave Slayton via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I just installed v18…the trace command doesn’t seem to be working….
> anyone else having this issue or know of a work around ? 
> TRACE
> C_longint ($dave) 
> $dave:=12
> alert("dave = "+string($dave))
> TRACE
> 
> **
> 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: execute method

[Neil Dennis via 4D_Tech]

I don’t think this will work compiled. Try the command "Process 4D Tags”

If the version of 4D you are using has this command, you can put 4D code in 
text and execute it with this command (no need to create a method)

Neil

> On Jul 16, 2020, at 1:36 PM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Fedinado. yes it should work, but why not just try it and see for 
> yourself. It would have taken about 30 seconds to do that
> 
> Regards
> 
> CHUCK
> 
> Chuck Miller Voice: (617) 739-0306
> Informed Solutions, Inc. Fax: (617) 232-1064   
> mailto:cjmillerinformed-solutions.com 
> Brookline, MA 02446 USA Registered 4D Developer
>   Providers of 4D and Sybase connectivity
>  http://www.informed-solutions.com  
> 
> This message and any attached documents contain information which may be 
> confidential, subject to privilege or exempt from disclosure under applicable 
> law.  These materials are intended only for the use of the intended 
> recipient. If you are not the intended recipient of this transmission, you 
> are hereby notified that any distribution, disclosure, printing, copying, 
> storage, modification or the taking of any action in reliance upon this 
> transmission is strictly prohibited.  Delivery of this message to any person 
> other than the intended recipient shall not compromise or waive such 
> confidentiality, privilege or exemption from disclosure as to this 
> communication. 
> 
>> On Jul 16, 2020, at 2:34 PM, stardata.info via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Hi all,
>> 
>> Some one have experience with execute method command?
>> 
>> I've need to insert some rows of 4D commands in one text field of a table, 
>> and after to execture this rows of code as a method.
>> 
>> Can i create programmatically method and after execute this method using 
>> EXECUTE METHOD?
>> 
>> EXECUTE FORMULA have a limitated feature.
>> 
>> Thanks for your help
>> 
>> Ferdinando
> 
> **
> 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: More values into one field

[Neil Dennis via 4D_Tech]

There are three ways I know of in v16 to store multiple datapoint in a field, 
object, blob, text… I recommend an object.

Neil

> On Jul 11, 2020, at 2:17 AM, stardata.info via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi All,
> 
> I use 4D v16.
> 
> I've needed to save more values of the same type (more results for one test)
> 
> The number of values to save, must be variables based on test type, and all 
> values must be saved into the same record.
> 
> Until now I use one text field and separated from one character so: 
> val1;val2;val3
> 
> Does someone have a suggestion to improve this solution?
> 
> Thanks
> 
> Ferdinando
> 
> **
> 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: Native 4D code to convert numbers into text?

[Neil Dennis via 4D_Tech]

> I would do this a little differently. I would pass in number (real)
> convert to text using commas and decimal points
> build an array of each second so if you passed in and got the following string


Another option would be to use recursion, that is the one I use now, then you 
don’t need an array and to me it greatly simplifies the code.

When you come down to it, there are many different approaches, probably as many 
approaches as programers have tried it, even the crappy one I wrote in high 
school, that was not at all elegant, worked.

I personally like the recursion algorithm but there are many programmers that 
are not comfortable with it. Computers are really, really fast, so unless you 
are executing this literally millions of times any algorithm that works, works 
:) "No need to optimize to the femto second" (quote from Thomas Maul I think)

Neil

**
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: Long running reports to disk intermittently disrupted and fail

[Neil Dennis via 4D_Tech]

> The fastest way to build the output is probably with a pre-sized blob, and 
> using TEXT TO BLOB with the offset parameter. Pushing elements into a 
> collection and then using collection.join() is also pretty fast, but again 
> you’d have to test to see how large a text variable can actually be, and 
> whether the limit was large enough both interpreted and compiled. If you 
> don’t have enough RAM for a 1GB blob, smaller blobs may work with SEND PACKET.

I ran some speed tests using 4D v18 on Windows 10. The results were 
interesting… in times past it was much faster to run a report using an internal 
buffer of some sort such as a text or blob variable. My resent tests showed it 
was faster to use SEND PACKET without buffering anything.

Again I was testing with 4D v18 and results may vary.

I’m assuming you are using unicode on your app? I think you can still do that, 
but I’m not sure. If you are not in unicode you should switch.

With unicode on a text can be very large. For imports I just use Document to 
Text. When exporting, large text vars can slow down as the resizing of them 
becomes slow. You could try filling a blob, but like I said SEND PACKT seemed 
to me to be the fastest option.

As was mentioned be sure to build your document local in the temp folder then 
move it to its home on the network. Writing across the network to create a file 
is slow and prone to error.

Neil


--
**
4D Internet Users Group (4D iNUG)
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: Text Editor Which Knows 4D Tags?

[Neil Dennis via 4D_Tech]

I have played with Atom, it does allow adding 4D tags. Miyako sent out the tags 
add on awhile back, maybe at a summit? Anyway you can add custom tags.



> On Mar 26, 2020, at 3:22 PM, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I’m very new to 4D Web programming and I’m trying to get comfortable with the 
> tools. One thing that I’m challenged by is debugging HTML. 
> 
> For example, I’m getting an error on a web page that says “4DENDIF expected”, 
> so I’ve traced the html in Chrome using the Developer Tools and I have 
> identified the suspect html file. Now I am poring over that file in my text 
> editor, matching the 4DIF to the 4DENDIF tags. This works, but it is tedious 
> and time consuming and error prone. It would nice to have a tool that could 
> format it automatically.
> 
> I don’t know much about text editors, but I think what may be needed is a 
> custom lexer. I use NotePad++, which seems to support adding lexers, but 
> would be willing to consider changing to something else, if it could learn 
> about 4D Tags. Is there an Text Editor which knows about 4D Tags? Does anyone 
> know how to write a lexer for 4D Tags?
> 
> Or maybe I’m making this too difficult?
> 
> Tom Benedict
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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 Summit Virtual?

[Neil Dennis via 4D_Tech]

> We’re fine here in Chicago.  I’m still going.

If they have it, I will come… 

Neil

--
**
4D Internet Users Group (4D iNUG)
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 Application as a 3-tier System

[Neil Dennis via 4D_Tech]

As you already know a textbook three tier application would be web based…

HTML/Javascript/CSS - Front End
PHP/JS/ASP… many others - Middleware
MySQL, Oracle etc - Backend

The key points being:
Front end handles the presentation
Middle ware handles the business logic and application flow talks between the 
front end and any other resources needed
Backend a connection to permanent data usually through SQL

There is no reason that 4D couldn’t be used in all three, but it really doesn’t 
make sense…
Front End - 4D handling the presentation with screens (but no database nor 
tables) making calls to the middle layer… and accepting data and navigation 
from the middle layer (via REST or some other communication)
Middleware - Use 4D code to handle requests from the front end, validate data, 
handle the controller part (again no database nor tables)… make calls the 
backend (REST etc. or using v18 ORDA to make direct queries)
Backend - Use 4D structure with data but no code (expose with REST or ORDA)

A couple of possibilities maximizing 4D use:
Web Browser -> 4D middleware server -> 4D backend
Web Browser -> 4D Client -> 4D Server

Anyway in short I don’t know of a way to go three tier without a lot of work. 
And for a true 3 tier, web is a good way to do it.

Neil


> On Jan 27, 2020, at 8:48 PM, Tarawerkz via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi All,
> 
> I have an application running in a hospital environment for a number of years.
> In the light of the increasing awareness of data security, the client’s IT in 
> their own words are looking at "redoing the whole 4dcis database onto 2 or 3 
> tier system where there is a database separation from application layer”
> 
> The current setup is a v15 client-server application, with about 80 
> concurrent client licenses serving users located at 2 separate locations.
> 
> As it stands, a 4D application already has a 2-layer architecture being a 
> client-server application.  
> We could perhaps enhance it a little to make it a 2-tier environment by 
> moving the segregating the 4D Server software and the 4D structure files 
> (business logic) on to one server and the 4D data files (database) on to a 
> separate server.  Doing that however has no effect on the 4D database 
> architecture, it still remains a 2-layer database architecture.
> 
> Apart from re-developing the application into a complete web-based 
> application, how can a 4D application be refreshed into a 3-tier system?
> 
> I would like to tap on the collective wisdom of the forum to gather some 
> views on the plausibility of the above.
> Thank you.
> 
> Regards,
> Ronnie
> Tarawerkz
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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: HTTP Upload file size too low

[Neil Dennis via 4D_Tech]

> I wish. However as someone else pointed out some IT departments will not
> allow FTP.



Chuck,

FTP is not secure and is prohibited for data that needs to be secure. Back in 
the day when Mac had servers they removed from the FTP server, my guess is that 
it was for this reason. Do NOT use FTP unless the data is public.

SFTP is acceptable for sensitive date.


Neil






**
4D Internet Users Group (4D iNUG)
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: peer to peer app in 4D

[Neil Dennis via 4D_Tech]

> m writing a basic app that will find people who are physically close to
> you. Kind of like Uber. Can 4D do that elegantly?


There is nothing build in for geo locations, but 4D is a great language and can 
be expanded with plugins to do anything that can’t be done native.

You may not even need a plugin depending on how the data would be received. For 
example if you used a mobile application that send the geo location then use 4D 
to store and process, no plugin needed.

So a simple answer yes, 4D can do anything and elegance comes from the 
programmer :)

Neil



**
4D Internet Users Group (4D iNUG)
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 Web Server Security

[Neil Dennis via 4D_Tech]

>What port are you serving your web application on?

I’m not Lutz, but to be secure you will need https over port usually 443. You 
will need to create certs with an authority and have them installed.

Neil

—




**
4D Internet Users Group (4D iNUG)
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: Confused array type in an object

[Neil Dennis via 4D_Tech]

I don’t think 4D can type {additional_information:[Check / Money order]}… It 
can’t be text because it isn’t quoted, it can’t be a text array. A text array 
would be formatted like this ["Check / Money order”] so I’m not surprised that 
4D is returning null.

4D object are not JSON objects, just similar.

Neil


> On Aug 9, 2019, at 1:11 PM, Nigel Greenlee via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi.
> 
> I am looking for a better solution than what i currently have..this has 
> probably been encountered by others.
> 
> I am creating some code on 4D V17 but I can not really use collections or 
> .notation as this is going to get deployed on V16 and will not be upgraded 
> for at least a few months(and i am not sure that would solve this problem 
> anyway).
> 
> I am retrieving an object from a connected source(Magento FYI)... from the 
> object  we get a sub entity object and that sub entity may itself contain a 
> subentity etc etc(we are mapping data to go into our system). I am trying to 
> write something agnostic and generic so i am not expecting to ‘hard wire’ any 
> behaviour for a specific entity into the code that extracts the data.
> 
> So at each ‘entity’ level I get the attribute names and types. where the 
> attribute type is 38 or 42 this is a ‘sub entity’ so we are going to get that 
> object and call back into the same code to go down a level.
> 
> Now on V16 of course i wont get a type 42 but actually a type 42 SHOULD(as i 
> understand it) mean the object (element) contains an object and that object 
> SHOULD be a ‘complex’ object and my understanding is that should be an array 
> of objects(else it would not be a collection)? Have i misunderstood that? 
> 
> So i should be able to write(for a type 42 attribute)..
> 
> OB Get Array($ObjData;$attributeName;$aObjSubObject) //Where $aObjSubObject 
> is an Array Object
> 
> (and mostly that works)….
> 
> 
> However
> 
> I am finding a case where
> Attribute Type =42 
> Attribute Name=“additional_information"
> 
> ...and the object looks like this:-
> 
> {account_status:null,additional_information:[Check / Money 
> order],amount_ordered...
> 
> in that object ‘additional_information’ looks like
> additional_information:[Check / Money order]
> 
> which as any JSON/4D object fool can see(LOL) is an array type object(of text 
> in this case) not a collection of objects. When i retreive it as an array of 
> objects I get the correct number of elements(1) but the value of the 
> element(1) is NULL because its not [{…
> 
> 
> indeed if I write:-
> 
> 
> OB Get Array($ObjData;$attributeName;$aTextarray) //Where $aTextarray is an 
> Array of type text
> 
> This indeed gets the values from the object..which would be absolutely 
> fine(and a work around might be to get both, as neither error, and then look 
> at whether the values in the object array are null and if they are then its 
> an array of values).
> 
> So my question is this. What is a better way to find out what the type of 
> data in the attribute is? What am I missing in my understanding of the 
> structure of an/this object.
> 
> OB Get type returns 42(matching the attribute type of course!). It feels like 
> the attribute is Shrodingers Cat- existing as a collection of cats and not a 
> collection of cats at the same time. 
> 
> 
> Nigel Greenlee
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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: How to decode this text

[Neil Dennis via 4D_Tech]

Just base 64 decode it.

RG9lcyB5b3VyIGNvbXBhbnkgb2ZmZXIgaW5zdXJhbuKFvWU/
 
Decoded is

Does your company offer insuranⅽe?

Neil



> On Jul 30, 2019, at 12:28 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am playing with a method to extract the Body of emails to a plain 
> text file
> I am using a trash folder which contains a bunch of spam...
> 
> When I extract the subject I get the following text (as the subject):
> =?UTF-8?B?RG9lcyB5b3VyIGNvbXBhbnkgb2ZmZXIgaW5zdXJhbuKFvWU/?=
> 
> How do I go about decoding the above line of text.
> 
> Thanks
> Chip
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing 
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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: Relation naming for ORDA in v17? Best Practices anyone?

[Neil Dennis via 4D_Tech]

Given two tables:

[Invoice]
[InvoiceItems]


I went much simpler…

The many to one from InvoiceItems to Invoice I simply name invoice
The one to many from Invoice to Invoice Items I simply named invoiceItems

Then the dot notation comes out to be

Invoice.invoiceItems
InvoiceItems.invoice




Neil






**
4D Internet Users Group (4D iNUG)
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: V17 MSC Reports Orphaned Methods...

[Neil Dennis via 4D_Tech]

> So, any thoughts on how to get a clean bill of health from MSC…? I’ve deleted 
> all orphaned methods, repaired & compacted the structure. I’m running out of 
> things to try.


Try deleting the 4D.indy then do a repair. I had a similar problem and this 
seemed to work for me.

Neil



--
Neil Dennis
4D Developer since 1990


GreaText - Designing Software for the Way You Work
716 East 1850 N
North Ogden, UT 84414

mailto:npden...@greatext.com
http://www.greatext.com/



**
4D Internet Users Group (4D iNUG)
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: v16R and v16

[Neil Dennis via 4D_Tech]

> Are you suggesting it might be better to skip updating to and deploying v16
> and wait for v17?

Nope, there are tons of cool things in v16 :)

I didn’t wait, 4D keeps getting gooder and gooder (yes I just said gooder) :)

Neil

Sent from my iPhone

> On Jan 22, 2018, at 7:09 AM, Jim Dorrance via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Are you suggesting it might be better to skip updating to and deploying v16
> and wait for v17?
> 
> On Mon, Jan 22, 2018 at 1:45 PM, npdennis via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> 
>> Anything in the R releases are included in the next major version of 4D so
>> features in 16R2 will be in the first 17 dot release.
>> 
>> There are a lot of cool things coming up not only with list boxes, but 4D
>> Write Pro that I’m looking forward to in 17.0
>> 
>> --
> Jim Dorrance
> jim.dorra...@gmail.com
> 4...@dorrance.eu
> www.4d.dorrance.eu
> 
> PS: If you know of anyone that needs an experienced 4D programmer to add
> energy and experience to their team, please let me know. I have
> experience in many areas. Reasonable rates. Remote or Paris only.
> **
> 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: v16 Listboxes and the Control Array

[Neil Dennis via 4D_Tech]

I have not found a way to not use a process array here... even in v16

Sent from my iPhone

> On Sep 10, 2017, at 11:42 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I'm just starting to do some serious work with listboxes in v16. In
> previous versions I know that things like the hidden array - to control
> individual row visibility - had to be a process array even if the rest of
> listbox was all dynamic vars. I don't see anything in the docs (yet)
> stating if this is still true in v16.
> 
> I'm starting to experiment with it but can someone tell me if this is still
> the case?
> 
> Thanks
> 
> -- 
> Kirk Brooks
> San Francisco, CA
**
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 v15r5 vs 16

[Neil Dennis via 4D_Tech]

Just v16, however I don't use the integrated web.

Either I or 4D wrote the plugins I use... I have seen no issues there.

Sent from my iPhone

**
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 v15r5 vs 16

[Neil Dennis via 4D_Tech]

As for 4D v16, I have used it a lot... seems just as solid as v15.4

Neil

Sent from my iPhone

> On Mar 24, 2017, at 11:05 AM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> OK... so I'm a little dense with understanding the "R" releases yet.
> 
> Does v16 have goodies that 15 R5 doesn't?  - vice versa
> 
> Is v16 ready for prime time?
> v15 R5 ready for prime time?
> 
> Randy Engle
> XC2 Software LLC
> 
> 
> 
> **
> 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
**