Re: Output lists

What? nobody likes Comic Sans? > On Sep 16, 2016, at 10:49 AM, Lee Hinde wrote: > > What fonts do you like for output forms, on a Mac? > > Helvetica is looking real stale. > ** > 4D Internet Users Group (4D iNUG) > FAQ: http:/

Re: 4Dv11 & Microsoft Server 2016

While I don’t know about Windows Server 2016, I maintain V11 copies of our database under Windows 10. Running is fine. Occasional quit when editing, but nothing like the Mac 10.11.x. > On Oct 10, 2016, at 10:50 PM, Robert ListMail wrote: > > I have a client that wants to re-write a v11-based s

Re: v14 on macOS Sierra?

I have a Macbook Air that is running 10.12.1 from an external drive. How can I tell which build it is? I had started testing 4D V13.4, but had to put it aside for a couple of months, and I can’t remember the load sequence. I can open V13.4 and V15.2, and they don’t crash, so … > On Dec 5, 2016,

Re: v14 on macOS Sierra?

Ah. But my ‘About This Mac’ only shows 10.12.1 - there is no build number! > On Dec 5, 2016, at 11:22 PM, Keisuke Miyako wrote: > > https://support.apple.com/en-us/HT201260 > >> 2016/12/06 15:40、Robert McKeever のメール： >> How can I tell which build it is? > > >

Re: v14 on macOS Sierra?

16B2555 Thanks. I can get back to testing. > On Dec 5, 2016, at 11:46 PM, Alan Chan wrote: > > Click on the version, the build number will show up. > > Alan Chan > > 4D iNug Technical <4d_tech@lists.4d.com> writes: >> Ah. But my ‘About This Mac’ only shows 10.12.1 - there is no build number!

Re: Best way to find something in an array of objects

-30C is -22F > On Jan 7, 2017, at 3:49 PM, David Adams wrote: > > Yup, it's scheduled to hit 30 this afternoon...we're lucky, it's been over > 40 in a lot of the country recently...it hit 45 here once. Insane. > > For our American friends: > > -30C = 23F > 30C = 86F > 45C = 113F > > > On

Re: OB commands, confirming a few points

And, how about the obvious: 3D Print Money ($Currency; $amount) > On Jan 11, 2017, at 10:26 PM, JPR wrote: > > [JPR] > >> Thanks for confirming what I'd feared, that there are missing features and >> that they've been missing for several years. > > I fully agree with you, David! And this pro

Re: The database cannot be published.

It has to do with port 80 (the web server). Either change its port or turn it off. > On Jan 28, 2017, at 4:45 PM, Ken Eyring wrote: > > I am getting this message: "The database cannot be published" when opening 4D > and 4D Server v15.3 on a Mac. > > I read the following KB articles: > > See:

Touch bar and v15.4

I see v15.4 is certified for OS 10.12. Does this include the Touch Bar on the new MacBook Pro? _ Bob McKeever http://www.mswl.com McKeever's Software Wizardry Port Coquitlam, B.C. bobmckee...@mac.com **

Re: Subrecords with subrecords

It was in 4D v1. > On Oct 12, 2017, at 6:59 PM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I recall Josh Fletcher presented that exact scenario just after v11 came out. > Nested subtables were possible in 4D v2 (or something like that). > >> 2017/10/13 10:07、Lee Hinde via 4D

How do you run MSC in a compiled/merged single user app?

4D V15.4, single user. The client is on the east coast (4 time zones), I’m in the west. I tried ‘Open Security Window’ in an execute statement (I’m logged in with Teamviewer), and it does not work. It is unable to save a record in a frequently used (adds only, no deletes) table. So, I’ve compr

Re: How do you run MSC in a compiled/merged single user app?

Many thanks. Works as advertised. > On Oct 18, 2017, at 7:56 PM, Spencer Hinsdale via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > > hold Option key while starting up to get the dialog where you can switch > files, create new, or use msc > >> On Oct 18, 2017

Re: [Warning] Settings properties values on object field by object notation

Is a ‘2’ in BOLD type sufficiently large, David? > On Oct 31, 2017, at 5:39 PM, David Adams via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > On Wed, Nov 1, 2017 at 10:23 AM, Tim Nevels via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > >> I can guess the answer to that. The engineer responsible l

Question about Execute on Server under 4D v15

I have two processes, one foreground, the other background (runs continually with appropriate pause/resume). There are a few dialogs that exist in the background process that can be eliminated. Since it does a lot of information gathering before creating/deleting a record and updating another, I

Re: Question about Execute on Server under 4D v15

; variables or data into a single c_object. > > My 2 cents. > > John > >> On Mar 5, 2018, at 6:00 PM, Robert McKeever via 4D_Tech >> <4d_tech@lists.4d.com> wrote: >> >> I have two processes, one foreground, the other background (runs continually >

Re: Question about Execute on Server under 4D v15

o reading from the server side only. > > I pass a pointer to a local object var. This is a pretty handy way to let > your server manage this sort of operation without having to add the > overhead of a messaging table where the server process writes data to a > table and th

Re: 4D data on the web - what do you use?

Jody: Same story in BC. Nova Scotia is curious. 3 years ago, they decided that the radiologists should submit claims electronically instead of on paper. You had the capital region (all around Halifax), and the community based groups related to specific hospitals. There are 8 such groups. All t

4D 11.9 Server issue

One of our clients, in a hospital setting, is running 4D Server 11.9. They are gradually replacing their Windows XP machines. The server runs on a rack-mounted machine in a server room that is stuffed to the gills with hardware. I have to schedule any access I might want. They have updated to c

Re: Collections

Anybody here remember Pick Basic? A record had many fields, each field could have many values, and any value could have many sub values. Like working with a cube where you can reference any point in the cube, and may be of any type. When used properly, the structure was marvelous. When abused,

Date entry

4D V15.4, Mac OS 10.13.4 A site that uses 4D Server. Mostly mini’s as clients. Has been working fine for years. Then growth, so someone brought in some PC’s. Then they scrounged around and now all minis. But, since we are in Canada, sometimes when the OS is loaded anew, this select Canadian Eng

Re: Date entry

date. It also resulted in some great > tools for quick entry of dates. Still loving that way of doing thing in v16. > > Jody > > >> On Jun 9, 2018, at 5:49 PM, Robert McKeever via 4D_Tech >> <4d_tech@lists.4d.com> wrote: >> >> 4D V15.4, Mac OS 10.1

Sometimes speed bites

4D v15 Server, new Mac Pro tower, 10.13.5. The code has been running on an older MacPro tower for many years. Now a second office. So, it gets the old tower, and the main office gets the new one. I put in an update last night that added even more speed. Yeah, everyone likes speed. Part of the

Re: Sometimes speed bites

that depends on timing. > > -- > Jeffrey Kain > jeffrey.k...@gmail.com > > > > >> On Jun 14, 2018, at 9:47 PM, Robert McKeever via 4D_Tech >> <4d_tech@lists.4d.com> wrote: >> >> But if the letter editing process is sitting idle waiting for another letter

Re: problems with SEND RECORD

You need to save each record: [Approvals]log:=$new_line+$current_log SAVE RECORD([Approvals]) NEXT RECORD and, of note, just a bare NEXT RECORD command assume that [Approvals] is the default table. It might not be. > On Jul 3, 2018, at 3:00 PM, Noah via 4D_Tech <4d_tech@lists.4d.com> wrote: >

Extra characters

4D V15, on a Mac. Once this works, the PC version is next. I have nine text files that contain java scripts. They contain the users password (not my idea). The health authority has decided that each site (maybe 45+ users) must change their passwords. So, I did the following: $MyRawDoc:=Document

Re: Extra characters

n using TEXT TO DOCUMENT. > > I use this method instead: > > > C_TEXT($1;$2) > C_BLOB($blob) > > TEXT TO BLOB($1;$blob;UTF8 text without length) > BLOB TO DOCUMENT($2;$blob) > > John DeSoi, Ph.D. > > > >> On Jul 3, 2018, at 10:31 PM, Robe

V17 - No Glass Buttons

Created a test database. New Table. Added 1 field. Go to create a form via the wizard. Move the field and the uuid to the form. Go to Advanced. No Glass buttons. I quit V17. I copied the Button Images ‘Glass’ folder into the Resources folder —> Images —> Buttons —> Glass just like a v15 databas

Assistance Needed

A client wants his ancient (4D 2003) database upgraded to 4D v16. I have the source, and a 10.6.8 environment under Parallels, and I found my old 2003 serial number, and it runs with 4D 2003. It won’t convert as the source has components. So, I found my 4D Insider. But it needs an ID (from the

Re: Assistance Needed

serial for the developer edition as well, so I might try that and see what happens. > On Jul 27, 2018, at 11:00 AM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > If you are a partner call your sales person > > Regards > Chuck > > Sent from my

Re: Assistance Needed

Yep, the 4D 2003 Developer license activated 4D Insider. That license email was from June 10, 2004. I never throw them away. Good thing. > On Jul 27, 2018, at 11:37 AM, Robert McKeever via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I emailed him yesterday. > > His im

Re: Confused about ORDA

Either they have changed the way QUERY works, or you are missing …&;… after the first semi-colon on lines 2, 3, and 4 of the QUERY. So, it looks like you are really simply searching for just the last line. Probably would be quicker. > On Jul 29, 2018, at 4:47 AM, Two Way Communications via 4D_Te

Tinkering with SQL

4D v15 I run the following code: The SQL Login goes to the database that is running. DA_SQL_Login2 C_TEXT(tLookFor) tLookFor:="%Mc%" ARRAY TEXT(aFoundNames;0) ARRAY TEXT(aFoundPhones;0) Begin SQL Select FullName, Phone FROM PatientBase WHERE (FullName like :tLookFor) INTO :aFoundNames, :a

Re: Tinkering with SQL

So, how do I make the SQL case-insensitive? > On Aug 6, 2018, at 4:57 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > 4D query is case insensitive whereas SWL by default is not. > > > > ** > 4D Internet Use

Re: Tinkering with SQL

Thanks, Tim. > On Aug 6, 2018, at 5:27 PM, Timothy Penner via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >> So, how do I make the SQL case-insensitive? > > http://doc.4d.com/4Dv16R5/4D/16-R5/Database-Parameters.302-3480842.en.html > > Set Database Parameter (SQL Engine case sensitivity) = selec

SQL Select failure

I’m transferring data between two 4D server systems. One table contains Lab reports which are formatted from a block of HL7. The records contain the raw HL7 and a 4D Write letter which is the lab report. There could,instead, be a PDF report in a blob. There is also a table of consult letters th

Duplicate data in Key Field

I’m converting an old database for a client from 4D 2003 to 4D v16. Quite the leap. I’ve run the procedure to add Primary Key UUID’s to all tables. Now some tables have duplicate data in the UUID field. They have never used the log file, so I could just skip them, but I’d rather not. How does

4D v15 and Microsoft PDF

Trying to make a PDF under Windows 10 as PDFCreator does not work on the client’s machine. The following code does not work (unable to start print job): $PDFPath:="C:\\" $PDFPrinter:="Microsoft Print to PDF" ARRAY TEXT($Name1;0) PRINTERS LIST($Name1) If (Find in array($Name1;$PDFPrinter)>0) SET

Re: [OFF] Credit card payments...

You can use Interact transfers, too. Very fast, and it might cost them a couple of dollars. > On Oct 23, 2018, at 4:10 PM, Robert ListMail via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I have a client with an overdue invoice…. They want to pay via CC but I > normally don’t take credit card

Opening a verify log

4D v16.3, Mac OS 10.11.6. I was trying to create a form in V16 that exists in V15. Went to add a plug-in area and it crashed. So, I opened again, and copied the plug-in area from a different existing form. Then I ran a structure verify. There are anomalies. This is generally bad news. So, I pr

Re: SET MENU BAR glitch

Chris: Starting in V11, based on the user, I load into the menu bar what is applicable. As I recall, I had to send my menu system to tech support, and they used it to ‘fix’ some of their menu commands. I have two tables, one for Menus, and one for the menu items for a given menu. So, if the us

V15 and SQL

a 4D server (Mac) is receiving new records in a table via SQL. That is fine EXCEPT that ((Trigger event=On Saving New Record Event) | (Trigger event=On Saving Existing Record Event)) never triggers. I need this to happen so other related tables can be updated accordingly. Any suggestions? _

Re: V15 and SQL

4d.com/4Dv15/4D/15/ALTER-TABLE-DISABLE-TRIGGERS.300-2048419.en.html > http://doc.4d.com/4Dv15/4D/15/ALTER-DATABASE-DISABLE-TRIGGERS.300-2048403.en.html > >> 2018/11/15 8:25、Robert McKeever via 4D_Tech <4d_tech@lists.4d.com>のメール: >> a 4D server (Mac) is receiving new records

Re: Active4D/ObjectTools with 4D 32-bit

Yes, still at 32-bit. > On Dec 10, 2018, at 10:55 AM, Aparajita Fishman via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Hi, > > Just wondering how many Active4D or ObjectTools users out there *must* use > 32-bit 4D on macOS for the foreseeable future. > > I need to know how much longer I need

V15 issue

I have a single user mac client (running Sierra) with a 4D V15.4 database. The database WAS in 4D V13.4. There is a 4 hour time difference between his computer and mine. I sent him a new structure, and moved the older datafile into the V15 structure. It converted it fine. He imports an extract

Re: V15 issue - solved

Permissions - the folder it was in messed it up. > On Apr 3, 2017, at 1:38 PM, Robert McKeever via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I have a single user mac client (running Sierra) with a 4D V15.4 database. > The database WAS in 4D V13.4. There is a 4 hour ti

Re: v13 and OS X 10.12

If you have a machine running 10.11.x, you might get away with starting the new machine in target disk mode, downloading the 10.11.x installer from Apple again, and installing it on the target disk. I did this last night on a machine that had been 10.6.8, and bricked trying to force 10.12. Worke

Re: Unattended Mac OS X Sierra v15.4 remote disconnects

Disable App Nap. > On Apr 13, 2017, at 6:30 PM, Perkins, Bradley D via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I'm trying to deploy a couple of system upgrades. We moved two 'web client' > machines from v14 on Mac OS X El Capitan to v15.4 on Sierra this week. > Previous versions of both sy

PDF's

Platform - Mac 4D V15.4 The client will scan 10 pages or so into a single pdf. They want to be able to open the PDF, and attach one or more pages of the PDF into a 4D Write document (or multiple documents). So, how do I extract a given PDF page into an image? ___

Re: PDF's

And where can I find the plug-in? > On Apr 16, 2017, at 12:33 PM, Mitchell Shiller via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > You can use Miyako’s pdf plugin to do basic pdf manipulation. > > For instance we receive our faxes as pdf’s from an e-fax service. > In our application, we create

Re: Components: How do you reuse utility code?

Remember subtables inside of subtables? (4D v1.xxx). Lots of fun - if used right. > On Apr 21, 2017, at 8:31 AM, Keith White via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >> If they did care, some of these things could have been added instead of >> querying on object fields that most people wi

What is 'Index Scanning'

4D v13.4 Server. Runs on an iMac. I access via Teamviewer as they are 4 time zones away. The entire machine froze today. Blamed on 4D of course, although there are a couple of other programs running, etc. 52.78Gb datafile, 2.43 Gb index file. When they restarted, it was rebuilding some indexes

Re: Disable close button on Splash screen windows v12

Jeremy: 'Quick Edits' of what? My databases are all compiled. The Designer can do anything, including exiting the splash screen, and then to user mode. Anyone else can have certain privileges(or most all), but they can not exit the splash screen. Easy to do. > On May 16, 2017, at 2:32

Re: Disable close button on Splash screen windows v12

John: Been there (many years ago) in the days of interpretive Basic. Had one client who loved to tinker. Since he owned the place, we had no choice but to allow it. But then he would go away for a couple of weeks, and they would call me when something did’t work. Open the code, and you could se

V15.4 and the GRAPH command

The code: GRAPH(IOPGraph;vGraphType;Labels;aBlock1;aBlock2;aBlock3;aBlock4) IOPGraph is a picture variable vGraphtype is a longing, value of 1. Labels is a text array, 11 entries, string of date values ("5/11/2013", …) aBlock1 thru aBlock4 are longing arrays, all with numerical values. IOPGraph

Re: V15.4 and the GRAPH command

Well, what do you know - the aBlock# arrays were text! Works now. > On May 30, 2017, at 3:17 PM, Robert McKeever via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > The code: > > GRAPH(IOPGraph;vGraphType;Labels;aBlock1;aBlock2;aBlock3;aBlock4) > > IOPGraph is a pi

4D v15.4 and 4D Chart

I just updated a client to V15.4 from v13.4. Datafile was no problem. As an ophthalmologist, he occasionally graphs eye pressure over time. Of course the first time he tried, it generated an error. One for for a 27” monitor, and a button that opens another form to do the graph. Found the new Gr

Cache Settings

I have been running with 600mb cache memory under 4D V13. No problems. Under 4D V15, I seem to be having some arrays end up undersized (of course, in a compiled database running client-server). I increased it to 800Mb. Same issue. The code is the v13 database converted to v15. Should it use ada

Re: Cache Settings

server or mac > How much memory on machine > How big is data file > > Regards > Chuck > > Sent from my iPhone > >> On Jun 20, 2017, at 12:59 PM, Robert McKeever via 4D_Tech >> <4d_tech@lists.4

Re: Cache Settings

lepath > (aDocument_Path_T{$iIndex})) > > End for > > The issue was resolved when I changed the code to Append to array instead > of creating the array and assigning to the individual elements. > > > > -- > Douglas von Roeder > 949-336-2902 > > On

Re: Cache Settings

AM, Douglas von Roeder via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Is there an error message? > > -- > Douglas von Roeder > 949-336-2902 > > On Tue, Jun 20, 2017 at 10:34 AM, Robert McKeever via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >>

Re: Cache Settings

ech@lists.4d.com> wrote: > > Got it. > > 4D has been pushing us to large stack sizes for a long time so I've > switched to a Constant that resolves to 0. > > Good luck with this. > > -- > Douglas von Roeder > 949-336-2902 > > On Tue, Jun 20, 2017 at

SQL

Anybody know what an error 9900 is when dealing with SQL? _ Bob McKeever http://www.mswl.com McKeever's Software Wizardry Port Coquitlam, B.C. bobmckee...@mac.com ***

Re: SQL

e what happens. > On Jul 5, 2017, at 1:39 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Robert, > I remember seeing that when I was working on a SQL project a while back, > but can't remember the details :) If you can describe what you are d

Re: Use of Objects vs Global Variables (Was 'Arrays vs Objects...)

I doubt that they would let you through customs, David. > On Jul 21, 2017, at 6:01 AM, David Adams via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > On Fri, Jul 21, 2017 at 10:35 PM, Pat Bensky via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> My 2 cents: >> >> According to a recent 4D blog entr

Re: Serious 4D Internet commands issue in v15.4 with SMTP on Mac OS X

I’d check the text with a hex editor to look for invisible characters, etc. > On Jul 25, 2017, at 9:36 PM, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > It seems this does not do the trick in all instances. > > It appears there may be a problem with the text in the fields. I expo

Re: Recommendations?

Ken: 1. Get a copy of PDFCreator 1.7.3 for Windows. if you can’t find one, let me know and I’ll send you a copy. I could also dig out code for assigning the printer to PDF Creator with file naming, etc. 2. You will probably have to run 2 ‘print’ passes, one for the batch PDF, the other for ind

Re: 4D Forums no longer accessible -- too many redirects

Tim: Tried the steps. I got tangled up in the migration as I can not remember my very old password. Now what? > On Jul 27, 2017, at 10:09 AM, Timothy Penner via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Hi Jeff, > >> Is there a new way to access forums.4d.fr? > > forums.4d.com is the new w

4D Equivalent from SQL

Working with V15. The definition script for SQL for a few fields is ‘bigint (18)’. If I specify a 64 bit integer, I get negative numbers upon import. No calculations are done with the numbers, so should I define them as alpha fields? _ Bob McKeever

Re: SEND / RECEIVE RECORD questions

I’ve done this a lot over the years. You send from a specific table. Likewise, you receive into a specific table. The receive goes in field order. Internally, the datafile keeps a mini-structure map for each record that is written at the time the record is written. Then, if you change a field f

Subform will not appear

A simple test database in 4D v15.4. The data comes about because the province of Nova Scotia has decided to change their billing codes and diagnostic codes. As a result, I have base data to play with. 16 tables. 5 for SNOMED diagnostic codes, 11 for CPT fee codes. Only looking at two of them. O

Re: Subform will not appear

Ah!. Thou shall not simply test a form by pressing on the green ‘run’ button. Invoking it from a one line procedure (Dialog(“formname”) ) works fine. > On Aug 28, 2017, at 4:19 PM, Robert McKeever via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > A simple test database in

Re: 4D dot releases versus R releases - a metaphor

No, it’s just Friday… > On Sep 8, 2017, at 7:20 AM, David Adams via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > On Fri, Sep 8, 2017 at 11:41 PM, Doug Hall via 4D_Tech <4d_tech@lists.4d.com >> wrote: > >> What's wrong with using semantic versioning, like the rest of the entire >> freaking world?

Connecting to SQL on a PC

For years, we have had a couple of clients that connect to an SQL server. All the traffic is done using triggers under 4D Server (the triggers run on the server), and we use the Actual OBDC SQL drivers for the connection on a Mac server. Works well. Now I have received a request to draw some da

Re: REDRAW WINDOW not working v17?

Have you tried GOTO PAGE(x) where x is the current page number? > On Jan 3, 2019, at 4:28 PM, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hello Keisuke, > > Windows, 32 & 64 bit, although most of my experience is 64 bit. > > Yes, I reference the variable in on display detail. >

Re: QPix License Install Issues...

What OS and what version of 4D? Yes, I’ve seen it with one client. V15 with an older Mac OS. You just have to re-install his license. The roll-back (which we never did) seems odd. What does the license manager say is installed? > On Feb 5, 2019, at 9:15 PM, Tom Benedict via 4D_Tech <4d_tech@li

Print Job issue

I have a client that is retiring, and needs to print all of his patient charts, each to separate PDF’s. About 19,000 charts. So, for each chart, I start by making a file name that Is based on the patient name, and the do SET PRINT OPTION(Destination option;3;$FileName) OPEN PRINTING JOB Then

Base64 Encoded text

The health authority has decided to release some results (discharge reports) in PDF form which we receive in HL7 format. The line received begins with 'OBX|1|ED|PDF^PDF||^TEXT^PDF^Base64^JVBERi0xLjQKJdP0zOEKM’. I’ve tried $BlobText:=substring([PatientLabResults]HL7Text;36;length([PatientLabR

Re: Base64 Encoded text

he other way and encode the provided PDF file to base64 > using 4D and compare it to its hl7 counterpart. Maybe you can discover some > differences? > > Kind regards, > Koen > > >> Op 14 feb. 2019, om 06:30 heeft Robert McKeever via 4D_Tech >> <4d_tech@li

Re: Base64 Encoded text

Actually, I look for the HL7 delimiters (the vertical bar | and the carat ^). It breaks the HL7 into its component parts wonderfully well. I appreciate the comment. > On Feb 14, 2019, at 12:10 PM, slerch via 4D_Tech <4d_tech@lists.4d.com> wrote: > > BASE64 can be split into multiple lines so i

Re: Printing 4D Write to PDF via Windows 10 "Microsoft Print to PDF"

This is what I do: SET CURRENT PRINTER(<>FormPrinter)` where <>FormPrinter is "Microsoft Print to PDF" SET PRINT OPTION(Destination option;2;$FileName) SET PRINT OPTION(Orientation option;2) Then, I just print. To print a patient chart, I open a print job, and print forms, images, PDF’s by

Connecting to FTP

I run an FTP server for my clients. All of the connections are secure FTP - port . I can’t get the FTP_Login to work. I assume that it is using regular FTP, port 21. I tried ###.###.###.###: for the address, but no joy. Any Ideas? _ Bob McKeever

Re: Connecting to FTP

IT_SetPort returns 0. The FTP Login returns 10032 - Unknown or invalid response. > On Apr 30, 2019, at 5:32 PM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Bob, > > You need to use the IT_SetPort command. > > John DeSoi, Ph.D. > > &g

Re: Connecting to FTP

l. Check his site out > > Regards > > Chuck > > Sent from my iPhone > >> On Apr 30, 2019, at 10:03 PM, Robert McKeever via 4D_Tech >> <4d_tech@lists.4d.com> wrote: >> >> IT_SetPort returns 0. >> >> The FTP Login returns 10032 - Unknown or in

4D V15 crash

My client (4 time zones away), had been running the single user compiled and merged app under windows. Then he purchased a new Mac. It is running 10.14.3, I’m running 10.14.4. I have moved the appropriate mac app files to his machine, along with the datafile and index file from his PC. 4D crash

4D V15 crash - further info

So, I set the compiled/merged app up here. Runs fine. I even downloaded the merged app from our FTP in case a new plug-in might be bothering it. No such luck. > On May 3, 2019, at 6:11 PM, Robert McKeever via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > My client (4 time zon

4D V15 crash - further thoughts

Am I trapped in some security hole? Sandbox? > On May 3, 2019, at 6:49 PM, Robert McKeever via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > So, I set the compiled/merged app up here. Runs fine. I even downloaded the > merged app from our FTP in case a new plug-in might be

Re: 4D V15 crash

in ~/Library/Logs/DiagnosticReports). It > often gives helpful clues about what is causing the crash. > > > John DeSoi, Ph.D. > > >> On May 3, 2019, at 8:11 PM, Robert McKeever via 4D_Tech >> <4d_tech@lists.4d.com> wrote: >> >> My client (4 time zones away),

Re: 4D V15 crash

And, the reboot fixed whatever was bothering it. Runs fine now. > On May 4, 2019, at 8:07 AM, Robert McKeever via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > My son is a software engineer at Apple. I passed him the crash log last > night. He could not find anything

Re: 4D V15 crash

But why would restarting the Mac solve it? > On May 5, 2019, at 2:46 AM, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Maybe it’s part of the 4D license validation routine trying to phone home... > >> Le 4 mai 2019 à 17:58, Robert McKeever via 4D_Te

I've not seen this before

A client reports that Windows did an update last night. Today, when importing one of the billing extract files (CSV format), he get the following error from 4D: “The volume for a file has been externally altered so that the opened file is no longer valid.” Sometimes the radiologists like to ed

WordPress

I’ve just been handed a website to host with 4D. No big deal, I thought. Except it built with WordPress. I have no experience with WordPress, and I’ll need to host it and have 4D interact with it (the usual - capture incoming queries, name and address data, etc.). Is it possible? If so, where

Re: v13+ SQL access other system

Back in 4Dv11 days, I was asked to connect to a SQL database with 4D. With 4D, I was able to connect to a test copy of the SQL system. I found and extracted the list of the SQL tables. And, for each table, I extracted the field map. I then wrote 4D code to do sample data extracts for each table

Weird Build Message

Mac, OS 10.14.6, 4D v15.4 Did a bunch of testing to resolve small issues with creating a lab report from received HL7. The changes they wanted are really picky. In the build of the single user app, I received this at the top of the log: Component copying from Macintosh HD:Users:bob:Desktop:4D v

Re: Weird Build Message

At the top of the log, it said 1 error (in red, of course). > On Oct 19, 2019, at 9:09 PM, Robert McKeever via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Mac, OS 10.14.6, 4D v15.4 > > Did a bunch of testing to resolve small issues with creating a lab report > fro

How to view PDF's on Windows with 4D V16

I’ve tried PDF View, and the PDF’s fail to load. Works fine on the Mac. Any ideas? _ Bob McKeever http://www.mswl.com McKeever's Software Wizardry Port Coquitlam, B.C. bobmckee...@mac.com **

Mac OS Catalina, V16.6, permissions, etc.

Out of necessity, I’ve updated my MacBook Air to Catalina. I’ve made a stripped down single user version of my app to run on a couple of users that updated without asking me about it. One such client is in Nova Scotia and I have good access to his machine via Teamviewer. Since the root level of

4D V15.4, Mac OS 10.12.8 to 10.14.x

The server is a mini (late 2014). The clients are minis. Same age or a bit older. Software has run without error for many years, occasional updates when the various hospitals change forms. One mini does the scheduling. A couple of others do billing, patient queries and such. In the last few we

Re: v17.3 on Mac OS 10.15.2 Plugins "cannot be opened because the developer cannot be verified"

Yep, this is a pain. Go to System Preferences, Security & Privacy, the General Tab. Now start your database. You will have to authorize each plug-in as not being recognized (Allow apps downloaded from:…). Now quit your database. Now start your database again. Answer yes for each plug-in (sorr

Re: Receive packet stop character

So, open the file with a hex editor, and see what ends the first line. I use Hex Fiend for that on the Mac. > On Mar 25, 2020, at 8:10 PM, Spencer Hinsdale via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > > Does the behavior change if you insert > USE CHARACTER SET("iso-8859-1";1) > before rece

Image Export Issues

The database is 4D v15.4, iMac 10.14.6, using a Pegasus 9Tb RAID (sweet drive). I have 151,814 images, in either JPEG or BMP format, and the format is known for each image. So, I cycle through the images and figure out what the export be, do a create document for that name, close that file and

  1   2   >