Re: Invalid JSON?

> wrote: > > What version of 4D? JSON Parse on what you provided below does not throw an > error with 4D 17.1. > > John DeSoi, Ph.D. > > > >> On Jun 2, 2019, at 8:05 PM, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> >> wrote

Re: Invalid JSON? - solved

)#"{") Repeat $Response:=Delete string($Response;1;1) Until (Substring($Response;1;1)="{") | ($Response="") End if John > On Jun 2, 2019, at 3:05 PM, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> > wrote: > &g

Re: Anyone using zipcodeapi

> If the website is returning JSON, if you can just pass $oResponse instead of > $response and 4D will do the "JSON Parse” for you automatically. Tim, thanks. At first I did not understand, but got it now... C_OBJECT($oResponse) HTTP Request(HTTP GET

Re: Invalid JSON?

ou pass a C_TEXT to HTTP Request? > > you might want to use a BLOB, > then Convert to text (which will get rid of the BOM), > then parse. > > 2019/06/03 10:05、JOHN BAUGHMAN via 4D_Tech > <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.c

Zip Code API sites - Follow up

Should someone in the future be looking for a Zip Code lookup api, here is what I found… https://www.zipcodeapi.com Includes… City, State Abbreviation, Time Zone, Daylight Savings, Latitude, Longitude. (US Only) Free limits…. 10/hour, 240/day Application registration required

Re: V17R3 vs PowerShell

Not sure anyone is interested, but after a lot of research on line it appears that 64bit version of Powershell cannot call a 32bit dl and vice versa. This does not match the results I am getting with v17R3. In my previous post I left out that . 4D client is running on a 64bit Windows 10

Re: V17R3 vs PowerShell

> On May 30, 2019, at 9:40 PM, Epperlein, Lutz (agendo) > wrote: > > we use Powershell a lot, even in conjunction with 4D. But we never divide > between 32bit and 46bit-Powershell. Since you use the Powershell via LAUNCH > EXTERNEL PROCESS (LEP) the architecture (bitness) of the Powershell

Re: V17R3 vs PowerShell

> On May 30, 2019, at 10:13 PM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > >> QBXMLRP2.RequestProcessor > > > is the QB SDK based on COM / OLE ? Yes. > but it does sound like the SDK is not installed in the client having a > problem. > perhaps OLEVIEW.EXE could

Re: v15 to v17 Conversion of Obsolete _o_C_STRING/_o_ARRAY STRING Commands

> On Jun 7, 2019, at 6:02 AM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > - Run compiler, fix individual errors, or notice sizes you missed above > and do global replaces using C_Text(; -> C_Text( Rather than rerunning the compiler… 1. Find In Design for

Using TRANSFORM PICTURE Crop in a Scaled to fit (Proportional) picture variable

Ha anyone this and be willing to share their code” I have been trying to relate a selected area on the scaled picture to unscaled picture without any success figuring out the math. I am displaying the image in a fixed size variable on a form (819X550 odd numbers I know). The user selects the

Re: V17R3 vs PowerShell

Oooops. Just noticed an error in the code I posted. The case statement should have read On May 29, 2019, at 7:12 PM, JOHN BAUGHMAN wrote: Case of : (32bit PowerShell). //pseudo code. $FilePath:="C:\\Windows\\sysWoW64\\WindowsPowerShell\\v1.0\\powershell.exe -file

Re: V17R3 vs PowerShell

I ran the PS scrip in the 64bit PowerShell ISE and I am getting the error… 80040154 Class not registered Googling this tells me that this is the result of 64bit PowerShell balking at calling a 32bit COM object. I wonder, however, why when run from a 32 bit 4D Client the same

V17R3 vs PowerShell

Anyone using PowerShell on Windows 10 out there? Maybe you can help me figure this out. I am upgrading an old v13 database to v17. My ultimate goal is to have everything run-in 64bit. The database talks to QuickBooks on a Windows 10 machine using an XML stream in a Powershell script file

Re: V17R3 vs PowerShell

Aloha Keith, > The reason that you think the 64-bit PowerShell is working is because > actually the 32-bit PowerShell is still being used. > > When a 32-bit application (in this case 4D) accesses the system32 directory, > those accesses are automatically redirected to the SysWow64 directory. >

Anyone using zipcodeapi

Is anyone using zipcodeapi.com to fill in city and state fields in a 4D database? Would you be willing to share your code? Thanks, John John Baughman Kailua, Hawaii (808) 262-0328 john...@hawaii.rr.com

Re: Anyone using zipcodeapi

OHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Is anyone using zipcodeapi.com <http://zipcodeapi.com/> to fill in city and > state fields in a 4D database? Would you be willing to share your code? > > Thanks, > > John > > > John B

Re: Zip Code API sites - Follow up

Jermy, Zipcodeapi.com has an API for Great Britain. Look at the list of countries near the bottom of the page. Example URLs are shown in th list. Here is a sample 4D call… $url:="http://api.zippopotam.us/GB/“+vZip. //AB1 for example HTTP

Re: Zip Code API sites - Follow up

ssing > something (not unusual) it’s not zipcodeapi.com <http://zipcodeapi.com/> > (your first link) which has UK codes, but zippopotam.us > <http://zippopotam.us/> (your second). > > Jeremy > >> On 3 Jun 2019, at 20:23, JOHN BAUGHMAN via

Re: Anyone using zipcodeapi

are extremely helpful and friendly. > > I looked at the website for zicodeapi.com and notice the service is less > expensive and offers a number of APIs for working with zip codes. It's a > solid suggestion. > > > On Sat, Jun 1, 2019 at 10:06 PM JOHN BAUGHMAN via 4D_Tech < > 4

HTTP connection to 4D server thru Mac FIrewall

Client wants to turn on the firewall on the 4D server machine. We have an iOS app that requests data from the 4D server which stops connecting with the FireWall on. I tried adding 4D server to the allowed apps in Advanced setting of the Firewall. I also have a Xojo web app that works, but it

Re: [Tip]Set Query Destination

I use a macro whenever I call SET QUERY DESTINATION… SET QUERY DESTINATION(;) SET QUERY DESTINATION(Into current selection) So if I write… Query([Patient];[Patient]Dentist_Name="John Baughman") Then realize I need to a query destination other than the current selection I highlight the

HTTP connection to 4D server thru Mac FIrewall

Client wants to turn on the firewall on the 4D server machine. We have an iOS app that requests data from the 4D server which stops connecting with the FireWall on. I tried adding 4D server to the allowed apps in Advanced setting of the Firewall. I also have a Xojo web app that works, but it

Rotate Picture

Is it possible to rotate a picture using native 4D commands? Google search finds references to Miyako’s rotate picture component, SVG, GitHub, etc. I do not see any way to do it with Transform Picture. If not 4D commands, what is the quickest and easiest way to rotate a picture in a picture

Re: Rotate Picture

h-$lHeight)/2)) > DOM SET XML > ATTRIBUTE($svgRef;"height";String($lWidth);"width";String($lHeight)) > Else //180 > SVG_SET_TRANSFORM_ROTATE ($imageRef;$rDegrees;($lWidth/2);($lHeight/2)) > End if > > $0:=SVG_Export_to_picture ($svgRef) >

Re: Using TRANSFORM PICTURE Crop in a Scaled to fit (Proportional) picture variable

Keisuke, Thanks for the helpful response. I had not thought about scaling the image manually. It took awhile, but I finally got the math right…. It works!! > is there a reason why your image is scaled on screen? If I understand the question, a user is manually cropping the image

V17 current release vs R-release

I have been doing an upgrade to v17 64bit for a client and working using the latest R release. I am having second thoughts about deploying the R-release version. I see that I can open the structure no problem with v17.2. Any thoughts with regard to the soundness of deploying a structure that

Managing 4D Server as a service

I am new to this and am wondering how does one manage a 4D Server running as a service. If, for example, the server throws an error there is no way to see the error. I guess what I am asking is to confirm that there is no way to see the server gui while it is running as a service. Also, I am

Re: Managing 4D Server as a service

Well, last night I tried to start the service on the client’s production machine and I could not get it to work. After registering the service from 4D server, I tried starting the service from the Service Manager and it indicated that it had started up but I was unable to establish a

Re: Managing 4D Server as a service

Tim, thank you for that most informative post. It really helps. I will be switching my client's 4D Server to a service later this evening for the first time. After reading your post I feel far more confident going forward. > On May 9, 2019, at 11:25 AM, Tim Nevels via 4D_Tech

Re: Managing 4D Server as a service

> On May 10, 2019, at 3:50 AM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > But be warned that you may still run into an issue with how you “Log on as:” > in the “Log on” tab in the Services dialog for 4D Server in the Services > window. 4D or Microsoft changed something and I

Re: Managing 4D Server as a service

Got it working. The fix was to use the Admin account in the Log On tab. That also fixed the Xojo WebApp. The fix did take until the server machine was restarted. I also opened 4D server and database as Administrator before restarting the computer. Looks like Interactive desktop only works with

Re: 4D Write Pro: License or privilege error

Thumbs up for VirtualBox. After using VMWare for few years and then Parallels for a few more, I discovered VirtualBox and have never looked back. Unlike the other 2, I have virtually (no pun intended) had zero issues to deal with. It just woks. John > On May 22, 2019, at 10:29 AM, John J

Error Can't load component "Foundation_560.4DC".

I am trying to upgrade a v13 database to v17 and am taking it first to v14. I am working on a Mac but it is deployed on Windows 10. I have it upgraded on the Mac with everything working including the PKUID fields. I plan to test each upgrade step in Windows. After moving the v14 upgrade over

Indexing taking a log time to reindex

We have been having major thuderstorms on the Islands these last couple of days, and after a second power outage at one of my client sites their database had to be recovered from backup. I had problems with the log file, but eventually got it back up and the log file integrated. In the

Re: Indexing taking a log time to reindex

> perhaps the reindexing of the 250k table has saturated the cache, leaving > little space the smaller table. > > FLUSH CACHE (FLUSH BUFFERS) with the * could be used to purge objects from > the cache, if that's the case. Miyako, I think you may have a point as the problem table

Importing from camera

What options are there, native or otherwise, for importing pictures directly from a camera? Thanks, John John Baughman Kailua, Hawaii (808) 262-0328 john...@hawaii.rr.com ** 4D Internet Users Group (4D iNUG) Archive:

Get System Info vs PLATFORM PROPERTIES

So PLATFORM PROPERTIES has been deprecated in favor of Get System Info. Get System Info is far ore informative, but am I the only one finding the text values of some of the properties near impossible to work with in a consistent manner across multiple platforms? Specifically osVersion and

Re: save listbox

Responded earlier but don’t think my post made it to the NUG… Store the arrays into an object, either a 4D object or ObjectTools object, then save the object to field or file. I have a couple of methods that do just that, either native or OT. I will be happy to share them with you if you

Re: PICTs

Easiest way is to open the structure or a copy of the structure with v16 and run a verify in the MSC on the structure. All the images in the library as well as static images on forms will be listed as warnings if they are in PIC format. John John Baughman Kailua, Hawaii (808) 262-0328

Re: windows versions for 4D v13.6

If I understand your question… Windows 10 - v17R5 64bit Windows 2008 R2 Enterprise - v16 R6 64bit John > On Aug 30, 2019, at 10:31 AM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Is anyone running server on OS newer than windows server 2003. If so what >

Where is this resource file

I have a picture button that is using a Resource File with an ID number. I need to convert it to a png but do not have a clue where it is. I think it should be in the Resource folder. Once I find it, I think I should move it there?? Thanks, John John Baughman Kailua, Hawaii (808) 262-0328

Windows shutdown with 4D Server running as a service

What is the best practice for shutting down a windows computer when 4D Server is running as a service? I have been opening the administration window too see if there are any users connected. If so, I have been disconnecting them before shutting down the computer. Just shutting down the

Re: User and Group information error on validation

t; John, > > Just a thought…might this error relate to a “group” of objects (perhaps > radio-buttons??) on a form and not to a “Users & Groups” Issue? > > Regards, > > Ken > >> On Jul 31, 2019, at 2:03 PM, JOHN BAUGHMAN via 4D_Tech >> <4d_tech

User and Group information error on validation

I am getting the following error… The group 15003 is referencing a nonexistent member -16.(0,0) No clue how to fix it. I am getting several of these errors. John John Baughman Kailua, Hawaii (808) 262-0328 john...@hawaii.rr.com

Another validation issue - orphaned method resource

I am getting a bunch of warnings in the Check Orphan Methods section that say… Warning: The method resource CC4D of id 19001 is not used anywhere.(0,0) Of course with a different id. I don’t have any orphaned methods. What is a method resource and how do I get rid of them. John John

Re: Where is this resource file

Thanks Jermy. I tried your suggestion and found no resource with a matching ID or name that describes the picture. FYIW, I created this button back in 2004 after seeing a Summit presentation by David Batton on how to create a mask object on a form. Using the presented technique I used a simple

Re: Where is this resource file

Thanks Miyako, but I am still stymied. The picture in the picture button looks good (v17R3 32bit). So I did… C_PICTURE($picture) GET PICTURE RESOURCE(17836;$picture) Also tried GET RESOURCE("PICT";17836;$picture) And tried GET ICON RESOURCE(17836;$picture) $picture comes back empty. So

Re: Where is this resource file

> https://doc.4d.com/4Dv17R5/4D/17-R5/Using-static-pictures.300-4163735.en.html#4096601 > > <https://doc.4d.com/4Dv17R5/4D/17-R5/Using-static-pictures.300-4163735.en.html#4096601> > > >> On Jul 28, 2019, at 4:37 AM, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com >

Re: Where is this resource file

cale any resources (PICT, cicn, MASK...) inside your > RSR file? > > if you are on Mac, it could be that the structure file is forked and the > resource is inside the resource fork. > >> 2019/07/29 16:04、JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com>のメール: >> >&

Re: Windows shutdown with 4D Server running as a service

t; E-Mail: s.o...@the-aquila-group.com > * >>> On Aug 8, 2019, at 01:14, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> >>> wrote: >>> >>> What is the best practice for shutting down a windows computer w

Re: Microsoft Azure & 4D

the specifics. > > On Fri, Jul 19, 2019 at 3:33 PM JOHN BAUGHMAN via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> I have a deployed database that is currently using AWS. We have 200gb of >> PDFs stored on the same machine as 4D server. A Xojo Web App displays the >&g

Re: Windows Server 2012 & 4D Server v17.2

Have the clients tried connecting using a Custom address… 192.16..1.150:19813 for example? I have found that for some of my windows installations This was necessary to make a connection, after which the recent connection created can be used. John John Baughman Kailua, Hawaii (808) 262-0328

Microsoft Azure & 4D

I have a deployed database that is currently using AWS. We have 200gb of PDFs stored on the same machine as 4D server. A Xojo Web App displays the available PDFs, when the end user requests one of the PDFs Xojo sends the request to 4D and 4D returns the PDF. At the present time we are using

Re: 4D v17 To QuickBooks Using Miyako's QBO.4DB

Ken, I have a deployed 4D database talking to QB on Windows 10 and 4D17r5. It started out using Myles’ plug in. For me I had to stop using the plug in when the client moved to Windows 7. I was able to get it done using… QB RDS client and server: Client or

Re: 4D v17 To QuickBooks Using Miyako's QBO.4DB

Seeing an interest in 4D to Quickbooks desktop I am tempted to try my hand at writing a component that facilitates sending and receiving data between 4D and QuickBooks. The 4D side of things is not that difficult using the Quickbooks SDK. What is challenging is the considerations and

Cache flushing did not complete... best practice

What is the best way to recover from a a flushing that did not complete. I have never had an issue using restore before when this happened, but on my development machine I cannot get the data file to open again no matter what I try. I do not care if data is missing so I have tried to delete

Re: Printing List Box v16R5 - never mind

I forgot that I needed to set the x, y start positions otherwise it prints based on the position of the list box on the form, which would push it off the page. John > On Mar 1, 2020, at 2:37 PM, JOHN BAUGHMAN wrote: > > 4dI have done this many times before but for this particular listbox I

Printing List Box v16R5

4dI have done this many times before but for this particular listbox I am getting a blank page using… PRINT SETTINGS If (ok=1) OPEN PRINTING JOB FORM LOAD("DistrictPromotions")

Re: running server v17.3 as a service

I have been running 4D server as a service for about a year now and have had no problems except for a single instance of the service stopping unexpectedly. Don’t know if it was 4D crashing or the service itself stopping, When I was setting this up I remember finding a way to access the service

Re: Multiple instances of 4D Client

Forgot to mention he is on 4D v18. > On Apr 17, 2020, at 11:36 AM, JOHN BAUGHMAN wrote: > > I don’t think you have to create duplicate copies of 4D. I an not on Windows > but have a client who is on Windows 10 and he is able to have multiple > instances of the same 4D client running at the

Re: Multiple instances of 4D Client

I don’t think you have to create duplicate copies of 4D. I an not on Windows but have a client who is on Windows 10 and he is able to have multiple instances of the same 4D client running at the same time on the same machine, each connected to different 4D servers. John > On Apr 2, 2020, at

Re: Receive packet stop character

hidden characters in there and reinserted the return with the return key. I also opened it up in Pages and showing invisibles all were carriage returns I also brought in other text files that have worked fine up to now and it did not work with them either. > > On Wed, Mar 25, 2020 at 9:31 PM JOHN BAUGHMAN

Receive packet stop character

I have a tab delimited text file and I want to get the first row with… C_TEXT($TextValue) $DocRef:=Open document($IndexPath) RECEIVE PACKET($DocRef;$TextValue;”\r") CLOSE DOCUMENT($DocRef) This was working fine until about an hour ago when it suddenly started bringing in the whole document

Re: Receive packet stop character

USE CHARACTER SET("iso-8859-1";1) >> before receive packet >> >> >> On 3/25/20, 8:01 PM, "4D_Tech on behalf of JOHN BAUGHMAN via 4D_Tech" >> <4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote: >> >>>

Re: Receive packet stop character

lso tried changing the code to char(carriage return) > Could the line ending have change to something else like \n ? No. See my response to Chuck. John > >> On Mar 25, 2020, at 9:31 PM, JOHN BAUGHMAN via 4D_Tech >> <4d_tech@lists.4d.com> wrote: >> >&

Dll error help

I am trying to get a v14 database to work on windows uncompiled and on startup I am getting… The ordinal 748 could not be located in the dynamic link library ASINTPPC.dll If I click ok to the error window, database startup, but the constants in the Foundation Extras.bundle in the

All plugins are throwing a License or privilege error on windows. Was: Dll error help

e: > > John, > > Which version of Foundation Shell are you using? > > Foundation 5 or later does not require Foundation Extras.bundle anymore. > > Thanks, > Walt > > >> On Mar 28, 2020, at 2:39 AM, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com >

V18 QuickReport what am I missing

I am looking at the Quick Report Editor in v18 for the firs time. It looks a lot less daunting for the end user which is a good thing. I have a couple of questions… 4D v18.1 LTS Mac High Sierra 1. When I click the Sort popup in the popup associated with a column header

Using Document to text ala Receive Packet Was: Receive packet stop character

> On Mar 25, 2020, at 8:21 PM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > sometimes, it might just be easier to read the entire text with > > Document to text (which can normalise the EOL character) I took Keisuke’s advice to heart and looked closer at Document to text. I

Select folder

On Windows when using Select Folder only folders are displayed. Is there any way to get documents to be listed as well. On a Mac documents are listed but cannot be selected. Is this a Windows thing or a 4D thing? John John Baughman 1331 Auwaiku Street Kailua, Hawaii 96734 (808) 262-0328

Re: ListBoxes and AreaList Pro again (was: Object notation replacement for use of Self in a script — v18)

First off, this is in no way an attempt to bash AreaList Pro. It is one of the best and most solid plugins available. Price is write and support continues to be great. If any plugin fits your needs by all means stick with it. Some of yoI have may remember that in the old days I always

Re: Using Document to text ala Receive Packet Was: Receive packet stop character

I have modified my Document to text wrapper that functions like Receive packet. Not sure if anyone is really interested in this but since I did post the original method I thought it best for me to post the modified version. The new version has 2 uses.. 1. To replace Receive packet as

<    1   2   3   4