RE: OK to Run 4D V13.5 on Windows 2016?

2021-07-14 Thread Justin Will via 4D_Tech
I've been running a fairly large 13.6 system on Win 2016 for about a year 
without issue.

Thanks
Justin Will
**
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: Looking for 3rd party SQL query tool

2020-03-30 Thread Justin Will via 4D_Tech
Tony

I personally use the SqlDbx professional but you could try taking a look at 
RazorSQL or DBeaver

Thanks
Justin

-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Tony Ringsmuth via 
4D_Tech
Sent: Monday, March 30, 2020 10:54 AM
To: 4D Nug <4d_tech@lists.4d.com>
Cc: Tony Ringsmuth 
Subject: Looking for 3rd party SQL query tool

Can anyone recommend a good 3rd party SQL query tool, to connect to 4D via 
ODBC, and perform general SQL queries?

 

I used to use “SqlDbx” free version, but the free version is 32 bit only.  
Their 64 bit version is a bit spendy.

 

Thanks,

--

Tony Ringsmuth

Business Brothers Inc.

763-420-8686

**
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: Component methods not properly recognized in parent database

2020-02-13 Thread Justin Will via 4D_Tech
Doug,

I recently had this and had to rename my components with sorter names with no 
spaces on the server.  Was it the shorter name or no spaces...I don't know I 
think it was removing the space but whichever it was it solved my problem.

Thanks
Justin Will
**
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: ORDA/Collections

2019-10-30 Thread Justin Will via 4D_Tech
I couldn't seem to get Selection To JSON with a template to do what I wanted 
to.   I ended up writing this and it fits the bill.

For each ($oRec;$oRecs)
$oComplex:=New object
$oComplex.key:=$oRec.ID
$oComplex.label:=$oRec.Name
$oComplex.open:=True
ARRAY OBJECT($aoFacilities;0)
$oFacilities:=$oRecs.Facilities
For each ($oFac;$oFacilities)
C_OBJECT($oChild)
$oChild:=New object
$oChild.key:=$oFac.ID
$oChild.label:=$oFac.Name
APPEND TO ARRAY($aoFacilities;$oChild)
End for each 
OB SET ARRAY($oComplex;"children";$aoFacilities)
APPEND TO ARRAY($aoComplexs;$oComplex)
End for each 
$vtReturn:=JSON Stringify array($aoComplexs)

Thanks
Justin Will
**
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
**

ORDA/Collections

2019-10-30 Thread Justin Will via 4D_Tech
I need a json object output in a particular format and 4D's new datastore and 
collections do this out of the box in 3 lines of code for me.  It's almost 
magical.

$oRecs:=ds.Complex.query("Domain_ID = :1";_Domain_ID)
$coll:=$oRecs.toCollection("ID, Name, Facilities.ID, Facilities.Name")
$vtReturn:=JSON Stringify($coll)

The problem I have is the Javascript libraries I'm using that requires the data 
needs the names of the JSON elements to be named in a particular way.  Is there 
a way to tell my collection rename ID to key and Name to label etc?

So 4D is currently outputting this.

[
{
"ID": 901,
"Name": "MP",
"Facilities": [
{
"ID": 1159,
"Name": "MP:North"
},
{
"ID": 1160,
"Name": "MP:South"
}
]
}
]



But what I need is this.

[
{
"key": 901,
"label": "MP",
"children": [
{
"key": 1159,
"label": "MP:North"
},
{
" key ": 1160,
"label": "MP:South"
}
]
}
]

I know I could just do a replace in string but this feels like the wrong way to 
go at this.

Thanks
Justin Will
**
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: Cache flushing did not complete... best practice

2019-10-25 Thread Justin Will via 4D_Tech
Thanks Miyako.  I will take a look.

Justin
**
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: Cache flushing did not complete... best practice

2019-10-25 Thread Justin Will via 4D_Tech
I agree with Tim.  This is a flag inside the datafile.

I wish a utility existed again to just clear the flag.I have tried to find 
this in the datafile a few times without luck.

Justin

**
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: Miyako Excel Component

2019-05-24 Thread Justin Will via 4D_Tech
Peter,

What version of 4D are you on?  I have a little component that works pretty 
good and makes basic xlsx files from a selection or from arrays but requires 
v17.

Thanks
Justin

**
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: Intel Optane P4800x Drives with 4D Server and Thermal Throttling

2019-03-18 Thread Justin Will via 4D_Tech
Chip,

HHHL and 375gb

Thanks
Justin
**
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: Intel Optane P4800x Drives with 4D Server and Thermal Throttling

2019-03-16 Thread Justin Will via 4D_Tech
In case anyone is wondering.  I just installed one of these P4800X drives in 
our backup server and ran a test conversion of our datafile from v13 to v17.  
The datafile is 67gb and the index is about 25gb.  4D has 120gb ram allocated 
and running on Windows Server 2016.

Previously, I was converting the datafile on a HighPoint SSD7101A-1 NVMe M.2 
RAID Controller with 4x Samsung 960 Pro drives in Raid 0.  The conversion was 
taking about 130 minutes.  After swapping out this HighPoint RAID with a single 
P4800X drive and running the same conversion I was able to cut the conversion 
down to about 80 minutes.

I hope this is valuable to somebody else.

Thanks
Justin Will
**
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
**

Intel Optane P4800x Drives with 4D Server and Thermal Throttling

2019-03-14 Thread Justin Will via 4D_Tech
Anyone using these Intel 3D XPoint drives on their production servers?  I'm 
wondering if anyone is seeing thermal throttling with them like I see with my 
NVME SSD drives on sustained high throughput times.

Thanks
Justin Will
**
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: Coding/Development Style Guide?

2018-12-14 Thread Justin Will via 4D_Tech
Pat,

Love the j for object.  I had been trying to figure out what I wanted to do for 
that and hadn't yet.  Thanks for the idea.

Justin
**
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: v13 - how to manage not enough stack space error

2018-11-15 Thread Justin Will via 4D_Tech
Chip

I have some recursion stuff I do, sometimes it hit a bad data set that caused 
an infinite loop.  What I have done is, created a process variable that gets 
incremented at the top of the recursion process and decrements at the end.  I 
then put a check in my code to see if I'm more than say 30 levels deep.  If so, 
this means I have a data problem and I should gracefully exit the recursion and 
log the error.

I'm not sure if that will work for you but it solved a crash problem for me 
with stack space problems and recursion.

Thanks
Justin
**
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
**

Pictures Outside Datafile - Calculate Path

2018-10-04 Thread Justin Will via 4D_Tech
I have a picture field where I have the property checked that tells 4D to store 
the pictures outside the datafile.  The folder/file structure of these pictures 
is not apparent.  Is there a way to calculate where a picture for a particular 
table and field is within that structure?

Thanks
Justin Will
**
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: Server Monitoring...

2018-07-17 Thread Justin Will via 4D_Tech
Robert

I have been using the freeware version of PRTG with great success for about a 
decade now.  It has saved my tail many times.

Thanks
Justin
**
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: SQL Statement Assistance

2018-07-10 Thread Justin Will via 4D_Tech
Steve

Try removing the single quotes in your text variable assignment and retry your 
initial example.

Justin
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Document capture

2018-01-25 Thread Justin Will via 4D_Tech
Kenneth,

I have a system that tracks signatures and we get thousands of signatures every 
day.  We started storing these several years ago and we were originally storing 
all images in one place.  Our first attempt we stored the .png files as Image 
fields with the store outside the datafile setting on.  It was so easy to setup 
and we were off to the races but then we ran into problem.  Next we tried 
storing all of the images into one OS folder.  Once we got up over about 25k 
signature .png files in a directory we starting seeing problems.  The main 
problem here is if you ever need to browse to the directory manually and try 
and find/fix something the OS freezes for some time.  It gets worse as the 
number of files grow.  We currently have about 10 million signature images 
stored and we break it down by several groupings per day now with a few 
thousand images per directory.  This has solved the majority of our problems.

Regarding storing in the datafile (externally stored)don't do it if you 
have a high volume of documents.   Here's a few of the problems I have had with 
this method.

1.  Backup takes much longer to backup your data as it also has to backup all 
of your documents stored externally
2.  Your 4D backups can get HUGE
3.  Restoring your backup takes much much longer because it has to write out 
all of the externally stored documents to disk.  This really really hurt one 
day when our server crashed and the restore took several hours vs. about 25 
minutes since removing the images.  Our datafile is about 70gb of data not 
counting our signature images.
4.  If something happens and you get a corrupt document on disk or a corrupt 
directory 4D's compact/verify freaks out because it can't access an externally 
stored document it wants.  You then have to essentially loop through the 
datafile and attempt to load each document that is stored on disk and see if 
you get an error and if you do re-save the record with the document removed 
from the record.  Without this your compact/verify fails.

I highly recommend segmenting out your documents into smaller chunks of up to a 
few thousand files per directory.  I also recommend using something like Amazon 
S3 with geo redundant storage for storage and backup of those documents.  It's 
more work upfront but can make your life much easier over the long run.  The 4D 
Method user group had a presentation on using AWS a couple years ago that can 
help get you on the right track there.



Thanks
Justin
**
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: Electronic Signature Pads

2017-12-28 Thread Justin Will via 4D_Tech
It’s the same one I used.  Just a different way to link to it 😊

Justin

**
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: Electronic Signature Pads

2017-12-28 Thread Justin Will via 4D_Tech
What about using and html area and using the Signature Pad library?  I use this 
on a web app and it works great.

https://szimek.github.io/signature_pad/

Thanks
Justin

**
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: Convert 4D data MSSQL

2017-09-07 Thread Justin Will via 4D_Tech
Thanks Chuck, I'll give that a try.  Perhaps batches of 25k records as arrays 
will work and speed things up.

> You might try to use arrays to update and not individual records

Justin
**
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: Convert 4D data MSSQL

2017-09-07 Thread Justin Will via 4D_Tech
Jeffrey,

Thank you,  I was not aware of SQL EXPORT DATABASE.  I might be able to make it 
work by dumping to an intermediate SQL database and then converting the data to 
the slightly modified schema from there.

Thanks
Justin
**
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
**

Convert 4D data MSSQL

2017-09-07 Thread Justin Will via 4D_Tech
Does anyone have any advice on converting a 4D Database to MSSQL.  The database 
is quite large at 75+gb of data and doing the conversion with an SQL Login and 
looping the 4D records using Inserts into MSSQL is taking quite literally days 
to convert.

Any ideas are welcome.

Thanks
Justin Will
**
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: Batch file and 4DLink file on windows 2008 server

2017-08-17 Thread Justin Will via 4D_Tech
John,

I use this in a batch file successfully all the time.  Your code looked good to 
me.  Perhaps you could try moving the .link file to another location like the 
root of the C: drive and see if that makes a difference.

start "" "C:\Program Files\4D\4D v13.5 HF1\4D\4D.exe" "C:\mydblinkfile.4DLink"

Thanks
Justin Will
**
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

2017-08-11 Thread Justin Will via 4D_Tech
Randy,

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.  I also have software the monitors 
a page on the site and if the page is unavailable for more than a couple 
minutes starts sending emails and text messages etc so that someone can check 
it out.

Thanks
Justin Will
**
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: Encrypted Data at Rest

2017-08-02 Thread Justin Will via 4D_Tech
I don't believe that FileVault and Windows built in encryption is sufficient 
enough.  I need to comply with NIST Special Publication 800-57.  I believe it 
will have to be hardware based with some sort of special key management.  
Honestly it's all pretty foreign to me.

Justin

**
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: Encrypted Data at Rest

2017-08-02 Thread Justin Will via 4D_Tech
Jody,

Do you have a recommendation on a controller that does this well?

Thanks
Justin
**
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
**

Encrypted Data at Rest

2017-08-02 Thread Justin Will via 4D_Tech
I have had a request to have a system have all data at rest encrypted.  My 
understanding is that they actually want the 4D datafile and backups encrypted 
at all times.  Have others had to deal with this and if so what options did you 
find available and what did you choose as your solution?

Thanks
Justin Will
**
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 World Tour - Denver

2017-05-04 Thread Justin Will via 4D_Tech
David,

I completely agree!!!  Call Form and Call Worker are really more accurately 
named and described by your naming.

> As a quick heads-up, I think that the most accurate names for these commands 
> are respectively:
> 
> EXECUTE METHOD IN WINDOW
> EXECUTE METHOD IN WORKER

Thanks
Justin Will
**
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 SQL Implementation

2017-04-17 Thread Justin Will via 4D_Tech
Aaron,

> alternatively you can use SQL EXECUTE to still be able to use local 
> variables, and build your query dynamically

Using strings built into queries is prone to sql injection if the query has any 
input from the users and is considered a deadly sin in most cases.

Justin
**
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: How can I suppress the web server creating default index.html?

2017-04-14 Thread Justin Will via 4D_Tech
Kirk,

Turn off 4D's web server in the settings of MSC and start the webserver 
programmatically and the folder will not be created.

Like this...

WEB SET OPTION(Web Port ID;80)
WEB SET OPTION(Web HTTPS port ID;443)
WEB SET ROOT FOLDER("MyWebFolderPathHere";Is text))
WEB START SERVER

Justin

**
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 SQL Implementation

2017-04-14 Thread Justin Will via 4D_Tech
Bart,

I have to agree with everything you stated.  At one point in time I had a 
number of SQL calls in a web app that had some heavy use.  The day I rolled out 
the SQL code I had to roll it back to 4D Query code because performance was so 
bad the site became unusable.  At this point in time I avoid using 4D's SQL 
engine like it’s the black plague or something.  I just find it too unreliable, 
to slow and has abysmal SQL support beyond the most basic of syntax.

I sure wish they would make the SQL engine much stronger, but until it gets 
some real effort I will certainly avoid it.  It's a real shame too, because 
reporting and analytical tool options would really open up some fun new 
possibilities.

Thanks
Justin Will
**
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: CALL FORM and CALL WORKER ideas (Was: 4D World Tour - Get off the fence)

2017-04-06 Thread Justin Will via 4D_Tech
Dave,

There are certainly a few conceptual things covered regarding call form and 
call worker that were discussed and helpful to understand.

1.  The fact that you can have multiple forms within 1 context is a complete 
shift if thought processes.  Consider that you can have 2 forms sharing the 
same selection, process variables etc.  In one of JPR's demos, he has 1 form 
where you select the records, make setting changes etc. and it updates a second 
forms dashboard display without having to send a selection or really much of 
anything to the second window other than a call form telling the second window 
to "update" its display.  The display updates using the variables and selection 
from the first form.  Because both windows were started within the same process 
the share the context information.

2.  Call worker in my case is also going to be very helpful.  Right now I have 
some after-hours processes that take a long time to run and are fairly process 
intense.  Being able to just pass these off to multiple cores on the server is 
going to be extremely helpful to shorten the time of processing as I can slice 
the tasks to multiple cores.  I can't say that the World Tour event helped my 
understand this but it just showed more examples of performance differences 
using more cores.

3.  One more point regarding call form and call worker.  One of the tidbit 
pieces that I picked up at the conference was a tip for getting rid of IP 
variables.  As you well know in 4D we love our IP vars for setting up runtime 
constants.  JPR's recommendation for this is setup all your values in an object 
and just pass this object into each worker.  Certainly this is not as nice as 
just having the values at my disposal all of the time but it certainly is a 
workable solution.

Number 1 and 3 are really the concepts that were discussed that I had not yet 
considered and were very helpful tips on how I can take advantage of the new 
threading models 4D has provided.

HTH
Justin



-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of David Adams 
via 4D_Tech
Sent: Wednesday, April 5, 2017 4:49 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: David Adams 
Subject: CALL FORM and CALL WORKER ideas (Was: 4D World Tour - Get off the 
fence)

Thanks for posting about the show, it sounds like a really solid couple of 
days. Likewise to all of the other, similar posts here today.

I noticed as a theme a lot of excitement about CALL FORM and CALL WORKER.
I'm pretty stoked about them and would really appreciate hearing from people 
how they are using these tools, or how they're planning to use them.
I've been studying them closely for months and am pretty deep in the weeds on 
the detailsit's nice to be reminded about simple, effective uses.

Any comments welcome.
**
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 World Tour - Get off the fence

2017-04-05 Thread Justin Will via 4D_Tech
I highly recommend going to the 4D world tour.  There is always at least 1 
tidbit that you walk away from events like this that makes the whole trip 
worthwhile and JPR and Add are both fantastic presenters with tons of valuable 
content.

So if you are on the fence, get off the fence and sign up.  The UI tips and 
discussions about Call Form and Call Worker are worth your time and money and 
so are some of the side discussions to be had with other developers.

Thanks
Justin Will
**
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: Read Only 4D Server

2017-03-27 Thread Justin Will via 4D_Tech
Good idea. On the trigger.  I'll give that a try.

Thanks
Justin

-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Jeffrey Kain 
via 4D_Tech
Sent: Saturday, March 25, 2017 4:35 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Jeffrey Kain 
Subject: Re: Read Only 4D Server

Write a trigger that denies modifications and hook it into every table. Or 
allow your analytics only through SQL on the mirror and put that login into the 
read only schema. 

> On Mar 25, 2017, at 1:22 PM, Justin Will via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Does anyone know of a way to setup a Read-Only version of 4D server.  I am 
> considering setting up a mirror database for some analytic and reporting 
> functions and I only want to be able to integrate logs from a live server and 
> run some reports and queries against the read-only version of the system.
**
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
**

Read Only 4D Server

2017-03-25 Thread Justin Will via 4D_Tech
Does anyone know of a way to setup a Read-Only version of 4D server.  I am 
considering setting up a mirror database for some analytic and reporting 
functions and I only want to be able to integrate logs from a live server and 
run some reports and queries against the read-only version of the system.

My big concern here is that if it's not read-only the database could write a 
record accidentally of some sort and then the logs will no longer integrate.

Thanks
Justin Will
**
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: Web server: All page links appear as visited after update

2017-03-23 Thread Justin Will via 4D_Tech
Kirk,

I have seen something like a visited appearance on links on a page like this 
when I had an open A tag in my html before.

Thanks
Justin Will

-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Kirk Brooks 
via 4D_Tech
Sent: Thursday, March 23, 2017 10:26 AM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Kirk Brooks 
Subject: Web server: All page links appear as visited after update

I have 4D web server render a page. The page contains a date picker the user 
can use to pick a date. When they do the page makes a call back to 4D where the 
requested data are found and returned to the page as TEXT (stringified JSON). 
The web page then parses this data into a div. jQuery,
bootstrap4 and handlebars are the primary tools on the page.

The issue I'm up against is all the links on the page, in the new data and 
existing, now display in the 'visited' state. Can someone offer a little 
insight into what causes this?

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
**
**
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
**