If this is legacy code, you might want to insure that your printing is wrapped
with OPEN PRINTING JOB and CLOSE PRINTING JOB. I recently saw printing problems
that cropped up even though no code had been updated, but something changed on
the client side… and solved it by bookending the printing
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
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
into the relation, regardless of which
field the relation is drawn to.
cheers
Justin
> On 19 Nov 2019, at 6:50 pm, Justin Carr via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> Hi Chris
>
> Short answer is that if the many table is related to a field in the one table
> which is NOT
Hi Chris
Short answer is that if the many table is related to a field in the one table
which is NOT the primary key of the one table, the you should ***ABSOLUTELY NOT
USE ORDA*** to set the value of the many table field.
There is a horrible bug in ORDA where regardless of which field the
Hi All
Just a reminder that we are always on the lookout for new developers to join
our team here at Genie Solutions.
If you want to grow and unleash your passion for development in innovative and
interesting ways in a friendly, supportive and professional environment, then
look no further.
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
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")
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)
> On 28 Aug 2019, at 10:23 am, Mike Beatty via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> All-
>
> Running into an issue trying to get a v16.6 built application to run as a
> service, wondering if anyone has this in place before we ramp up the
> troubleshooting.
>
> A few notes — this is on
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:
You can move a license, I’ve done it. I forget the process but they are always
super-helpful. And I do have one instance where I’m using it with 4D client.
http://www.linkedin.com/in/justinleavens
On May 7, 2019, 3:12 PM -0700, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com>,
wrote:
> I’ve seen
Jeremy,
That's definitely one of the supported/encouraged behaviours as far as I am
aware.
cheers
J
> On 29 Apr 2019, at 6:05 pm, Jeremy Roussak via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> Is it safe to use the object returned by the Form command as a means of
> passing data back to the
Hi Chris
We use SET TIMER(-1) a lot for this purpose. It is ideal when you want to do
something as part of On Load but you need the On Load execution cycle to finish
first before you do the next thing, e.g. you need to know the size and position
of an object on a form before you take some
Hey Everyone
Ever dreamed of living and working in Australia? Better yet, in Australia's
sunshine capital Brisbane?
If so, this may be the oppourtunity you've been waiting for!
We are looking for an experienced and passionate 4D developer to join our great
team here in a full time permanent
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
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
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
**
On 22 Feb 2019, at 10:30 am, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com>
wrote:
>
> it sounds like you are over-thinking :)
>
> you could just do
>
> SET BLOB SIZE($bytes;4)
>
> $bytes{0}:=78
> $bytes{1}:=48
> $bytes{2}:=75
> $bytes{3}:=00
>
> then BLOB TO DOCUMENT.
>
> not need to go
On 14 Feb 2019, at 10:18 pm, Arnaud de Montard via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
>
>> Le 10 févr. 2019 à 18:41, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> a
>> écrit :
>>
>> Just to add a little more to this.
>
> Me too, forgot to mention CALL FORM: has a message queue, can
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:
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
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
On 13 Sep 2018, at 5:14 pm, Ronnie Teo via 4D_Tech <4d_tech@lists.4d.com> wrote:
>
> Hi David,
>
> Thanks for your tip.
> I have conducted the test as per your suggestion and from the results of the
> test, it does not appear to be a firewall problem.
>
> a) 4Dv15.5 (32-bit) - server app
On 28 Aug 2018, at 11:52 am, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com>
wrote:
>
> It does, but remember if you already have multiple transactions, you will
> have to keep track and may have to suspend that many times
I don't think that is true. When you SUSPEND TRANSACTION, the effective
On 28 Aug 2018, at 6:08 am, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com>
wrote:
>
> Hey guys - the very issue with the record counter is sketched out in the
> discussion about Suspending Transactions:
>
> http://doc.4d.com/4Dv16/4D/16.3/Suspending-transactions.300-3652126.en.html
>
>
> I
On 14 Aug 2018, at 2:18 am, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> wrote:
>
> Got an email about v17.0 HF1 being released. This fixed bug caught my eye:
>
>
> ACI0098368 A delayed processes do not wake up if paused and then resumed:
> it stays in pause mode.
>
> Could this be a fix
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
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
Just a a guess John, but is it possible the pictures that don't convert were
inserted in PICT format? Maybe you could select one of the letters with
troublesome images and convert one of those images in place to PNG (using
CONVERT PICTURE). Then try opening that letter again in 4D Write Pro.
On 21 Jun 2018, at 4:49 pm, Piotr Chabot Stadhouders via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Hi Justin, Pat,
>
> Using WP SELECT that is called in a method via CALL FORM seems to work,
> thanks for that!
>
> I must say, I can't believe it's 4D's intention that we constantly have to
>
On 18 Jun 2018, at 4:39 pm, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com>
wrote:
>
> Justin,
> I do use DELAY PROCESS but as I said it's only for a minute or two.
> And like I said maybe I've simply been lucky. As my business mentor used to
> say, "sometimes it's better to be lucky than smart."
On 18 Jun 2018, at 1:31 pm, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com>
wrote:
>
> according to the bug description for ACI0098368 ("Delayed processes do not
> wake up if paused/resumed while already delayed"),
>
> it's not that the DELAY P. has a problem resuming,
> the problem
On 15 Jun 2018, at 10:01 pm, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
wrote:
>
> Hi Piotr,
> I think you can use WP SELECT to do this -
> WP SELECT ( {* ;} wpArea {; targetObj} | {; startRange ; endRange} )
>
> Let me know if you can't get that to work and I'll take a closer look at it.
>
On 16 Jun 2018, at 12:20 am, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com>
wrote:
>
> I have never had an issue with DELAY PROCESS. Maybe I'm lucky. I don't
> think I've ever used it to delay something more than a matter of seconds,
> though. It would never have occurred to me to DELAY PROCESS
Building on Cannon's code, rather than calling codesign directly with the
--deep flag we use the shell script that is distributed in the 4D app bundle,
which takes care of the signing of all of the subcomponents for you. You still
need to remove the extended attributes first (with xattr -cr) as
On 24 May 2018, at 10:01 am, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com>
wrote:
>
> I think you need to first change the layout to inline (by UI or code), in
> order to delete an image.
>
> but the attribute "wk anchor layout" is not settable with WP SET ATTRIBUTES
>
> On 18 May 2018, at 11:21 pm, Piotr Chabot Stadhouders via 4D_Tech
> <4d_tech@lists.4d.com> wrote:
>
> How can I procedurally delete an anchored image in a 4D Write Pro document?
>
> I know how to select the image with
> WP SELECT(*;"WParea";$image_object)
>
> But then what?
Try:
INVOKE
suddenly start working when I connected to the Mac via screen
> sharing. The Mac was set not to sleep, but the display did sleep. On a
> whim, I set the display not to sleep and that seemed to solve the problem.
>
>> On Mar 12, 2018, at 4:19 PM, Justin Leavens via 4D_Tech &l
I've got a Mac server 16.3 (64-bit Merged) that periodically will hang when a
backup starts. In this case, the backup is being initiated procedurally from
one of the clients.
It seems maybe to be related to the server not being the front-most app,
because it will suddenly start backing up as soon
On 8 Mar 2018, at 1:46 am, Jeff Grann via 4D_Tech <4d_tech@lists.4d.com> wrote:
>
> I had the need to add find and replace to my 4D Write Pro areas. So I created
> a generic component. It easily shows and hides itself at the top of a Write
> Pro area and can resize itself automatically. You can
om>
wrote:
>
> Justin,
>
> Was it the volume of SOAP calls or the frequency that caused the crashes?
>
> We are clocking around 400 per minute at peak times.
>
>
>
> On Wed, Feb 28, 2018 at 9:39 AM, Justin Carr via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>
4D Tech mailing list wrote
> I was looking for something to do that, and Miyako did it. It is there:
>
> https://github.com/miyako/4d-tips-custom-url;
>
> Thanks so much, Miyako, to have done it! You’re really the angel of the 4D
> developers community! :)
>
> If someone is looking for the
4D Tech mailing list wrote
> 10.6.8 in a virtual environment?
>
> Actually server is very stable because of the lack of user interaction at
> least for v13. Not so certain about v11.
>
> Seriously look at the VM environment if you have problems though.
Thanks, Wayne. I'm running 10.6.8 right
If there's anyone else out there still running a v11 Mac server - I'm curious
to know what version of Mac OS X you're running under? I need to upgrade a
current 10.6.8 server machine with... something. thanks!
--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
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
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:
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:
On 1 Dec 2017, at 5:44 pm, Piotr Chabot Stadhouders via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Hi,
>
> I am trying to use the new Log Parser, but without success
>
> First of all, when I start logging I have 10 files of 10MB each within 1
> minute, but that's not the problem (or is it)
>
On 30 Nov 2017, at 10:41 am, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com>
wrote:
>
> to clarify:
>
> - command number
>
> the command number explained in this example corresponds to the right side of
> e.g. "3;1"
> and it can be derived from manifest.json inside the plugin bundle (v14
On 9 Nov 2017, at 10:19 am, Lee Hinde via 4D_Tech <4d_tech@lists.4d.com> wrote:
>
> On a Mac, when I want apache to front my 4D web server, I create a symlink
> in the Apache document directory to my web folder in the database directory.
>
> That way, I only have to install and maintain the web
On 9 Nov 2017, at 4:44 am, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com>
wrote:
>
> I have tried all of the offered suggestions:
> Start ?b
> running without a call to cmd
> \batchfilename\
> extended this to cover the file paths in the batch file
>
> none of these result in file copying
Keisuke Miyako wrote
> it seems correct that a number is mapped to real, according to JSON
> specification
> ...
>
> if you must exchange Int64, I think it is the responsibility of the sender
> to use string.
>
>> 2017/11/03 3:56、Justin Leavens via 4D_Tec
4D Tech mailing list wrote
> Yeah, if 4D isn't working, try NTK. In either case, if you can get at the
> value as raw text then you'll be able to find text --> 64-bit conversion
> code. The question in 4D at that point is how to store it. I know it's a
> field type, but can you touch it with
Is it possible to work with a 64 bit integer that's being returned to me in
an object from an HTTP call? I can't seem to avoid it being turned into
"-1.502644539978e+18". I also have a POST that requires me to pass back the
64-bit int value. I would use 4D or NTK for the object handling if it made
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:
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
**
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
On 31 Aug 2017, at 8:53 am, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com>
wrote:
>
> I’m having trouble with saving Unicode characters to a file. For example, the
> following code saves a file to disk:
>
> C_TEXT($tText;$tFilepath)
>
> $tText:=“©” //Copyright symbol
> $tFilepath:=System
On 21 Aug 2017, at 9:55 pm, Two Way Communications via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Using the old 4D Write, I loop through all the frames (frames 1-> 7), using
> ‘WR SET FRAME’ . Then I resolve the expressions.
> This way, all the references in the headers, text frames and footers
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"
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
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
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?
I did a 2014 Summit presentation (5 JSON Tips) which should be available
for download that demonstrated the benefits of using objects for key/value
pair cache lookups, but in the end it’s pretty easy to demonstrate. The
benefits start to show up with a few hundred keys, but at 100,000 it’s
easily
On 17 Jul 2017, at 5:03 pm, Robert Livingston <rlivings...@me.com> wrote:
>
>
>> On Jul 16, 2017, at 9:09 PM, Justin Carr via 4D_Tech <4d_tech@lists.4d.com
>> <mailto:4d_tech@lists.4d.com>> wrote:
>>
>> Are you able to provide a link to where t
On 17 Jul 2017, at 5:07 am, Robert Livingston via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> On Jul 14, 2017, at 5:10 PM, David Adams via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>>
>> I was just consolidating some old code and ran across something that I
>> wrote some time back called
On 1 Jul 2017, at 12:12 am, Stephen J. Orth via 4D_Tech <4d_tech@lists.4d.com>
wrote:
>
> I am getting an array range check error on the following line:
>
> If (Size of array(as_function)>=1)
>
> This is a compiled application, so how does this type of error even exist
> for this line?
>
On 28 Jun 2017, at 12:01 pm, David Adams via 4D_Tech <4d_tech@lists.4d.com>
wrote:
>
> On Wed, Jun 28, 2017 at 11:54 AM, Wayne Stewart via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> Hi,
>>
>> I did it with help from Dave Batton (so you can imagine how fresh this
>> solution is)!
>>
>> The
We do this all the time and don't see this issue. Mind you we never deployed
with v15. What works for us with at least v12-14 and v16R2 is to use an
internal webarea and open a blank URL first before opening the path to the PDF,
i.e.
WA OPEN URL(*;"webarea_name";"about:blank")
WA OPEN
Can someone please help me understand the mechanisms I would use if I wanted
to authenticate a user/password combination against an LDAP server? Do I...
1) use the user-supplied username/password to log into the LDAP server and
see if the login works?
or
2) use a system username/password to
If anyone has experience calling perl scripts from 4D on the Mac OS
environment, please contact me offline. I'm moving a server, and having
difficulty replicating the perl environment on the new machine. Thanks.
justin at jitbusiness dt com
thanks.
--
View this message in context:
On 5 Jun 2017, at 12:32 pm, David Adams via 4D_Tech <4d_tech@lists.4d.com>
wrote:
>
> On Mon, Jun 5, 2017 at 10:22 AM, Justin Carr via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> NOTIFY RESOURCES FOLDER MODIFICATION
>
> Thanks J. Hmmm. Added in V1
On 5 Jun 2017, at 9:50 am, David Adams via 4D_Tech <4d_tech@lists.4d.com> wrote:
>
> Grrr. Didn't figure out how to find this in the docs. There used to be a
> tickbox.
Could be but I don't think I ever used it. We just run a method with the EOS
bit checked which contains the NOTIFY RESOURCES
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
Can anyone suggest a straightforward approach to displaying a 4D object as a
browsable item - something like what you see in the debugger window, only in
a dialog form?
--
View this message in context:
http://4d.1045681.n5.nabble.com/Object-visualize-browse-tp5751523.html
Sent from the 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
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
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
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
jeffrey.k...@gmail.com>
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
I have a customer site with a mix of Windows machines and I need to get the
4D v15.4 app for use in client mode on to each machine. This is not a merged
server/client. What's the best way to get the 4D app installed on each
machine?
The 32-bit installer seems to want to install all of 4D
82 matches
Mail list logo
