Re: Client communication

An old trick I used to use in days gone by was a BLOB field in the table whose trigger needed the extra info. I'd use VARIABLE TO BLOB to put in all the information needed just before calling SAVE RECORD on the table. Then the trigger has the field and can use BLOB TO VARIABLE to unpack what it

Re: error 9922 o SQL Execute? what does that mean?

Julio, http://forums.4d.com/Post/EN/27095796/1 https://bugs.4d.com/fixes?version=16_R2 shows ACI0095714 ODBC driver returns error #9922 if last character in a word is a diacritical sign as è,é or ä (using fields). You would think your version is not susceptible to that because it was

Re: [EXTERNAL] Re: Run v15.4 in demo mode

Brad, I have most of the older installers if you need something. I can PM you dropbox links for what you need. I have versions of v15 up to v15.5 HF1. Version 16 to 16.2HF1 … I think I skipped a few versions of this one and went into v17. Something I do for these situations is to have virtual

Re: Collection

I’ve started using object fields for stuff like this to avoid all the parsing. Object fields can be queried now so it really is nicer to use, as well as easier to debug. Randy -- Randy Jaynes Senior Programmer and Customer

Re: Any Success Running 4D v13.6 on Win 10 Pro?

Depending on where you have the built application installed, Windows may be moving the app into a ‘protected folder’ as the application is starting up, effectively pulling the carpet out from under your application. I would suspect something like this if it’s in one of the Program Files

Re: V18 plugins not showing as Notarized?

I’ve found that you also have to be careful when copying your development structure from 1 machine to another. When you copy or unzip a version on the Catalina machine, it invalidates the notarization of the plugins and you get the alerts when opening the database that the plugins are damaged.

Re: WAN vs LAN Cache

Well that sucks. That really helped out in some tricky situations over the years. Admittedly, been a couple months since I last tried it. I swear it was with a v17 R version, but I can definitely see it’s not working anymore with R6 or v18.1 Sitting down. Head hung. Randy

Re: WAN vs LAN Cache

I believe you can still put a folder named ‘clientlocal’ in the same path as the 4D.exe(windows) or 4D.app (mac). This lets you keep the cache for a specific 4D application right in the same folder as the application itself. The only potential downside to this is if you use the same app to

Re: New Notarization Issues

Jeremy, I won’t tell you how many day's worth of hours it took me to get my stuff through the process. I was cursing Apple frequently and for the first time in 20+ years (did I really say that?) seriously considering becoming a Windows only programmer. Randy

Re: New Notarization Issues

For that one I was able to replace it with the php-fcgi-4d from the recent release of 4D v18. Randy -- Randy Jaynes Senior Programmer and Customer Support http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane

Re: New Notarization Issues

Jeremy, I would RUN to Miyako’s buildApp (https://github.com/miyako/4d-utility-build-application ) I found on the Catalina build machine that I’m using, I have to constantly sign the entire plugins folder. This database has been nothing

Re: 28 character file name limit for binhex encode SMTP_attachments?

Oh, yeah…that too! Randy -- Randy Jaynes Senior Programmer and Customer Support http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • Palisades, NY 10964 Please send all email contacts to

Re: 28 character file name limit for binhex encode SMTP_attachments?

Yes. This is a long-standing problem with 4D internet commands. It goes back to at least v6. I know it’s still present in v13 for sure, and you are confirming it’s in v16.4R4. If I remember, I think it may also be limited to 256 total characters in the full path on Windows (maybe Mac too), so

Re: Drop User NOT working (after client disconnected using Force Quit)

In some situations where the 'drop user’ was failing, I have been able to switch over to the list of processes and abort each of the user’s processes. The user was dropped when the last process successfully aborted. I can say that this hasn’t succeeded every time, but it has worked for me.

Re: Multiple instances of 4D Client

n Apr 2, 2020, at 12:36, Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> Create a folder named ‘ClientLocal’ in the folders where the 4D.exe is (the >> one being used as a client). >> >> Randy >> >> ---

Re: Multiple instances of 4D Client

Create a folder named ‘ClientLocal’ in the folders where the 4D.exe is (the one being used as a client). Randy -- Randy Jaynes Senior Programmer and Customer Support http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57

Re: Windows XPS Document Writer Preview problem

XPS Viewer is not installed in Windows 10 by default any more. https://www.tenforums.com/tutorials/109719-add-remove-xps-viewer-app-windows-10-a.html I would follow Option 1 to add it. Randy

Re: v17 immediately quits on launch

Sounds like the GateKeeper behavior on Mac when it’s not installed with a signed DMG or application. Randy -- Randy Jaynes Senior Programmer and Customer Support http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57

Re: Sending Text Messages From 4D

Jim, Have you tried using the PostMan application (https://www.getpostman.com/postman ) to work out the proper form of sending these requests? I found it helped a lot in trying to figure out how to build the request to a couple REST APIs a last year. It

Re: Migrating 4D Write Pictures to 4D Write Pro Objects

John, Not sure about the component you mention, but you most likely have to run this in a 32bit version of v17 in order for it to work. I worked through this by creating a method in my v13 structure doing this:

Re: CSV import with version 13

Chuck, Try this: https://kb.4d.com/assetid=50956 Charlie Vass wrote this Tech Note years ago (v11 era). I adapted it to make a generate CVS_ParseLine utility in my database and it’s come in handy several times over the last few years. HTH, Randy

Re: CONVERT PICTURE v17

You have to be careful about the transparency, though. After doing this conversion with transparency, I found that some of our pictures in the picture library (and static pictures on forms) need white in some areas to be meaningful. So we had to carefully look at each one to be sure that

Re: Switching from FTP to Dropbox

Tim, I would think you could use their API with the HTTP Request command, and maybe some cURL calls for the actual file downloading. The API looks similar to other REST APIs we’ve had to work with, so it _looks_ like it should work similarly. Randy

Re: Crash on startup, v17.1 merged app

d the > files up. I created a signed installer with DropDMG and now it's OK. > > That'll teach me to be lazy :) > Pat > > On Thu, 28 Feb 2019 at 16:00, Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com > <mailto:4d_tech@lists.4d.com>> > wrote: > >> 1) Permis

Re: Crash on startup, v17.1 merged app

1) Permissions issue on the folder on the Mac. 2) Did you install it using a signed installer or DMG so that OS X Gatekeeper recognizes it as a registered program. This sounds more like #2 to me, but in the past I’ve solved #1 by creating an Applications folder inside the user’s home folder,

Re: Comparing two structures...

I would open copies of the 2 structures in v17R3 and use the export function from that so you get all the form objects and everything. Then a diff tool (I use DeltaWalker) can compare everything for you. Randy -- Randy Jaynes

Re: Sales Tax Solutions for 4D

Jason, Try setting up the REST call using the PostMan app at https://www.getpostman.com It will be much faster to debug how to get your API calls set up properly. It was very helpful last month for me to get my REST calls for a Web2Print site set up properly. My calls were generally like

Re: looking for example of REST calls

Chuck, I’m in the process of finishing REST calls to the Pressero web2print API. The majority of the methods I had to write are quite similar and go something like this: ARRAY TEXT($aHeader_Name;0) ARRAY TEXT($aHeader_Value;0)

Re: Anybody running v17 server on Windows 2008r2?

Pat, We have a couple users still using Windows Server 2008r2. The only thing we ran into was an issue trying to use PHP Execute to unzip some files. We found this tip http://kb.4d.com/assetid=77608 There is a note at the bottom that says In order to

Re: Explorer bottom toolbar not displaying...

First guess is to quit 4D and throw out the folder "4D Window Bounds v15” in your 4D folder. On Mac, this is ~/Library/Application Support/4D/4D Window Bounds v15/ In Windows it’s somewhere in the C:/ProgramData folder I think. Randy

temporary folder command returning empty

A customer just turned up a case running 4D Server v17HF2 on a Windows Server 2012 box where the 4D command ’Temporary folder’ is returning an empty string. Has anyone ever seen this before?? The command is being executed in a method with the ‘Execute on Server’ checkbox selected in the

Re: Mac Mojave and v17?

4D (v17 and all the way back to v13.5) is having some issues with an internal MacOS drawing routine that is causing funkiness in: 1) ALP plugin drawing vertical text, the separator lines get a little “squiggle” to them 2) ALP drawing checkboxes in a boolean column 3)

Re: Cross-platform Migration v15 App

I did a move like this 10+ years ago. The biggest thing I can remember is file path issues. There were places in the database where files were being saved with file names generated from the user data, so the code was only checking for path naming issues relevant to the Mac OS. > On Oct 30,

Re: What causes a record to be Locked but Locked By has no info?

My first thought is transaction in another process somewhere. Randy -- Randy Jaynes Senior Programmer and Customer Support http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • Palisades, NY 10964 Please

Re: Notes on converting pictures to v17

Chip, Try this: I know v13 doesn’t have the Transparency constant, so not sure which version of 4D it comes into play, but this was part of one of the conversion routines I ran into a while ago when I had to do this: TRANSFORM PICTURE($Pict_G;Transparency;0x00FF) //convert the WHITE to

Re: Notes on converting pictures to v17

Kirk, There is an easier way. If you open a copy of your database in v17, and run MSC > Verify Application on it, it will point out all the bad form objects for you. The log file will show you entries like this in the sections where it is checking your project forms and table forms:

sql server unavailable

What does it mean when a method suddenly starts getting a runtime error in a compiled database that says Remote SQL Server is not available The line number it gives is the End SQL line in the method. The SQL code is a simple SELECT field1, field 2 from table where (field3 =

Re: Anyone using FTP_Receive under 64-bit?

Allan, Here is a zip file with 4 methods to send and receive using callbacks for optional debugging messages and using the progress bar component for the uploads and downloads. https://www.dropbox.com/s/ey2600zfie7o42i/cURL_FTP.zip?dl=0

Re: Anyone using FTP_Receive under 64-bit?

Yes it does. I have it implemented if you’d like a copy of the method I can email it directly to you. It’s fairly generic, but I can strip out the application specific stuff and comment it before sending. Randy -- Randy

Re: startup progress on server

> On Aug 6, 2018, at 12:39 PM, Timothy Penner via 4D_Tech <4d_tech@lists.4d.com > > wrote: > > Regarding the menu bars on server - > >> Calling SET MENU BAR during On Server Startup >> - this crash will occur in a test database with only this line of code in

Re: startup progress on server

SET MENU BAR has never actually done anything to change the menu bar on the server, so I think it’s just been ignored all these years. It’s never been a problem until v16R6 Server. Of course, this is the first time we’ve had 64bit on Mac, so it may be related to that. Either way, starting a

Re: startup progress on server

There could be, sure. John DeSoi makes a good point that it could b the 64bit version as opposed to 32bit. As I mentioned, the startup method was working fine up through v15.4 HF3, which was the last version before jumping to v16R6, but we went right to the 64bit version of that so I’ll have

Re: startup progress on server

We call QUIT 4D directly with no timer. Our On Exit and On Server Shutdown methods already do checks to be sure the processes we started are dead. I’m hoping for sure this is all that is needed. I didn’t think to test if this was only an issue related to 64bit version of server on Mac. I’ll

Re: startup progress on server

ttp://printpoint.com/> • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • Palisades, NY 10964 Please send all email contacts to supp...@printpoint.com <mailto:supp...@printpoint.com> > On Aug 6, 2018, at 10:15 AM, Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com > <mailto:4d_t

startup progress on server

I’ve spent the morning trying to track down why our database started crashing when we quit 4D Server v16R6 on Mac OS…I haven’t tested yet to see if it affects the Windows version as well. I have tracked down 2 contributors to the crash. 1) Calling SET MENU BAR during On Server Startup

Re: picture of a form

Technical <4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>> > Cc: Stephen Orth <mailto:s.o...@the-aquila-group.com>>; Randy Jaynes > mailto:ra...@printpoint.com>> > Subject: Re: picture of a form > > have you checked on top of your head? > >

Re: picture of a form

> Randy, > > I think its FORM SCREENSHOT > > > Steve > > > -Original Message- > From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com > <mailto:4d_tech-boun...@lists.4d.com>] On Behalf Of Randy Jaynes via 4D_Tech > Sent: Thursday, July 26, 2018 3

picture of a form

My feeble mind says there is some fairly new command that lets us get a ‘screenshot’ of the current window or form. Can’t think of right words to search because I’m not finding anything on KB or searching documentation. Am I off my rocker? Randy

Re: 4D Write PRO: editing a table / collections

Another thing we’re struggling with is that we’re building 4D WP documents using code and make tables so that the resulting area can be easily turned into an HTML email. Unfortunately, that makes the Write area awkward for a user to modify. It’s not easy to manipulate the tables (delete/add

Re: Converting pictures on 4D forms (Windows) to get transparency

> On Jul 9, 2018, at 3:28 PM, Bob Miller via 4D_Tech <4d_tech@lists.4d.com > > wrote: > > Randy - RE: You can use the MSC in v16 to flush out all the forms > > Yes, this works well, and JPR's component does a lot of the same thing. In > working out the problems, I

Re: Converting pictures on 4D forms (Windows) to get transparency

Bob, You can use the MSC in v16 to flush out all the forms where bad pictures are located, as well as bad picture library items and their references. Then use the picture conversion routine mentioned to convert the pictures to PNGs. We did this a couple months ago to prepare for our move to

Re: Printing Write Pro to PDF

Armin, I would love to try it out. I’ll raise the subject in our next development meeting. I’m tired of all these PDF driver headaches on Windows over all these years, so a single solution that I never have to worry about installation issues and missing stuff on a client computer or bad

Re: Printing Write Pro to PDF

No difference when using OPEN PRINTING JOB. It doesn’t appear to be related to WP PRINT specifically because I’m also getting bad PDFs generated when trying similar code like OPEN PRINTING JOB PRINT SELECTION (tableptr->;*) //also tried with ;> and no 2nd parameter

Re: Printing Write Pro to PDF

Tim, As I mentioned in my original message, I cannot use PDFCreator. So this does not work for me on Windows: > SET PRINT OPTION(Destination option;3;fileName) as per documentation, but that was why I mentioned that I wasn't using PDFCreator. As per docs, It works fine on Mac, but not

Re: Printing Write Pro to PDF

ote: > > I think it sued work if you set window title to the name, the document > would have that name. Not sure about now. > > Regards > > Chuck > > On Tue, Jun 19, 2018 at 5:10 PM, Randy Jaynes via 4D_Tech < > 4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com&

Printing Write Pro to PDF

Has anyone successfully used WP Print to print a 4D Write Pro area in v16 to a PDF? It seems we’re expected to go to PDFCreator, which I can’t do. However, I don’t seem to be able to do my 4D Write way of change - switch printer to Adobe PDF / Web2Print / PDF995 - WR Print

Re: issue on windows 10 and 4D 15

Chuck, We’ve had weird display issues on specific machines when the user has set the display properties to more than 100% or they’ve selected a theme other than the default Windows theme. Randy -- Randy Jaynes Senior

Re: Analyzing .4BL Files

I was just looking at this tech note last week http://kb.4d.com/assetid=77626 It’s a 4D Summit attendee only database, but I was impressed at how well it worked. Now I have to go look at LogTools. Randy

Re: 4D Write Pro Interface component v16R6

So much stuff to try and remember. Like Jody said…now I just have to remember _this_ link for the next time! Randy -- Randy Jaynes Senior Programmer and Customer Support http://printpoint.com •

4D Write Pro Interface component v16R6

Just a word of warning to prevent headaches for anyone else in the future. I just finished spending a few hours trying to figure out why the widget in the ‘4D Write Pro Interface’ component embedded in v16R6 (and some earlier versions of v16) wouldn’t work in my database, I finally tracked it

Re: Is there a (US) Mirror site for downloading 4D Products?

I’m not aware of US Mirrors, but I can send you a dropbox link(s) off list if you’d like. Which platform? Or Both? 32bit or 64 bit Windows? Randy -- Randy Jaynes Senior Programmer and Customer Support http://printpoint.com

Re: Old versions of Area List Pro

I have the installers for both mac & windows of the 7.5 that I mentioned. I can shoot you a dropbox link for them if you need, or email them if you’d like. They’re about 3MB in size. Randy -- Randy Jaynes Senior Programmer and

Re: Old versions of Area List Pro

Looking back through my archives, I have ALP 7.5 from ForeSight dated Mar 11,1999 so I’d start there. Randy -- Randy Jaynes Senior Programmer and Customer Support http://printpoint.com • 845.687.3741 •

Re: overlapping subforms

I have a form with 3 subform container objects sitting on top of each other. I just use OBJECT SET VISIBLE to hide the ones that don’t need to be seen at the moment. They all occupy the same space on the parent form, so because I hide the 2 not needed, the ordering on the form does not matter.

time entry filter

Does anyone know of a filter string or something that can be done so people don’t have to be entering times in a time field/variable in 24h format? The display of HH:MM AM/PM is great, but when you click into the field it switches to 00:00:00 and shows the nice 4:08 PM as 16:08:00 and expects

Re: v12 & v13 server - compatability with OS X High Sierra (10.13)

chip, A big issue we’re seeing with v13.5 and High Sierra is copy/paste. Pasting works fine in design environment, but in runtime, at random times, it can cause the app to go ‘rainbow cursor’ for a couple minutes before the Mac gives up and returns control to the user…and you don’t end up with

Re: 4D v6.8

I’m glad I’m not the only one who keeps a Mac 10.6 Server kicking around in VMWare. Pretty much the same reason. :-) Randy -- Randy Jaynes Senior Programmer and Customer Support http://printpoint.com

Re: subforms and object focus

R(-1) and then run the GOTO OBJECT in the On > Timer event. > > HTH. > > -- > Cannon.Smith > Synergy Farm Solutions Inc. > Hill Spring, AB Canada > 403-626-3236 > <can...@synergyfarmsolutions.com <mailto:can...@synergyfarmsolutions.com>> > http://www.sy

subforms and object focus

Has anyone figured out how go to a specific object in a subform when opening the parent form (currently in v15.4 HF3)? The docs for Page Subforms (http://doc.4d.com/4Dv15/4D/15.4/Page-subforms.300-3285433.en.html) says The GOTO OBJECT command looks for the destination object in the

Re: find only partial strings

Match RegEx should be able to do that for you. Provided you get the pattern matching string correct. That’s always a fun task. :-) Randy -- Randy Jaynes Senior Programmer and Customer Support http://printpoint.com

Re: [offish]Volume of mail

I think we’re all too lazy to get up and move all the way over to the 4D forums. I do go there for research and find the forums much more active, and with far many more users than we see here. And with 4D themselves pushing us in that direction, I see more and more of us who have been on this

Re: CONVERT PDF TO PICTURE

I use ImageMagick with Ghostscript. I have utility method that I do this, and actually run it on the server so I only have to install it there rather than on every single client machine:

Re: v12 server - can not connect

Firewall? Randy -- Randy Jaynes Senior Programmer and Customer Support http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • Palisades, NY 10964 > On Sep 11, 2017, at 11:44

Re: Convert 4D data MSSQL

EXPORT DATABASE and SQL EXPORT SELECTION do. You > might have some issues with date/time fields as well as object fields. > > -- > Jeffrey Kain > jeffrey.k...@gmail.com <mailto:jeffrey.k...@gmail.com> > > > > >> On Sep 7, 2017, at 11:40 AM, Randy Jaynes via 4D

Re: Convert 4D data MSSQL

Maybe you can write 4D code to create blocks of insert statements in a text file like LOCK TABLES `CatalogPricing` WRITE; INSERT INTO `CatalogPricing` (`catPriceID`, `catPriceCatalogID`, `catPriceQty`, `catPriceAmount`, `catPriceStatus`) VALUES (2,2,1,15.00,'1'),

Re: Unable to Compile - Crash - looking for ideas - SOLVED

Randy, I would also recommend changing the settings from Generate Typing to All Variables are typed This gives you control over the typing of your variables, and the line you point out would have kicked out a compiler error about the unknown ‘variable1’ in your line of code.

Re: Missing Pict - 64bit Removes pictures from library

Randy, You can use 4D commands to figure out where these are used. I wrote a utility routine to track down things like this and where some formats are used so I could flush out the ones that aren’t in the Filters list in the Toolbox. You should be able to find what you’re looking for using the

Re: 4D Not Seeing A Mounted Network Drive

If this is 4D Server running as a *service* on Windows Server 2012R2, you have to be sure that the user under which the server runs has the network drive mounted. This has been done for me by IT people at the places I’ve run into this, so I’m not really sure exactly what it is they are doing,

Re: Finding where a filter or format is used in a structure

I haven’t tried this - does the log let you know where these deletions occurred so you can go set them to more appropriate filters? That was the reason I had written my method - I needed to track down inconsistencies. Randy

Re: Finding where a filter or format is used in a structure

I have a utility method and a calling method for looping through the forms that dumps the following information into a text file on desktop for all table forms and project forms. The columns it writes are Table Form Name Page # Object Name Variable / Field Name Format Help Tip Filter I

Re: PROCESS 4D TAGS

Mitch, I stumbled on this a few weeks ago. I think I tracked it down to a compatibility setting Use 4DVAR comments instead of Brackets I think my database had that turned off. Randy -- Randy Jaynes Senior Programmer

Re: PDFCreator and Windows 7

Maybe not helpful, but I gave up on PDFCreator long ago because of inconsistencies like this. We moved to Win2PDF and life is much more sane. It works right out of the box and was easy to implement. True, it’s not free, but in 6 years I’ve only had to contact their tech support people 2 times

Re: sending mail with Exchange server

Thanks, Lutz. Will look into these. I know it’s a Pandora’s box and it gets very frustrating, for sure. So many variables. I suspect something on Exchange, but I’m told it’s managed by Comcast, so it’s not going to be fun getting any changes made that we might need. Randy

sending mail with Exchange server

We’ve been using 4D InternetCommands for many years to connect to SMTP servers directly and send emails out of our database. In the last few years it’s been getting harder and harder to keep up with the various security requirements of different servers. The most recent issue is that a