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

2020-05-04 Thread JOHN BAUGHMAN via 4D_Tech
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 a

V18 QuickReport what am I missing

2020-04-25 Thread JOHN BAUGHMAN via 4D_Tech
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

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

2020-04-24 Thread JOHN BAUGHMAN via 4D_Tech
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 it

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

2020-04-23 Thread JOHN BAUGHMAN via 4D_Tech
> 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 di

Select folder

2020-04-22 Thread JOHN BAUGHMAN via 4D_Tech
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 john.

Re: Multiple instances of 4D Client

2020-04-17 Thread JOHN BAUGHMAN via 4D_Tech
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 sam

Re: Multiple instances of 4D Client

2020-04-17 Thread JOHN BAUGHMAN via 4D_Tech
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

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

2020-03-29 Thread JOHN BAUGHMAN via 4D_Tech
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 >

Dll error help

2020-03-28 Thread JOHN BAUGHMAN via 4D_Tech
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 Plugi

Re: Receive packet stop character

2020-03-25 Thread JOHN BAUGHMAN via 4D_Tech
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: >> >>> On

Re: Receive packet stop character

2020-03-25 Thread JOHN BAUGHMAN via 4D_Tech
. I also 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: >>

Re: Receive packet stop character

2020-03-25 Thread JOHN BAUGHMAN via 4D_Tech
ters 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

2020-03-25 Thread JOHN BAUGHMAN via 4D_Tech
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 which

Re: Printing List Box v16R5 - never mind

2020-03-01 Thread JOHN BAUGHMAN via 4D_Tech
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

2020-03-01 Thread JOHN BAUGHMAN via 4D_Tech
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") $end:=

Re: running server v17.3 as a service

2019-12-30 Thread JOHN BAUGHMAN via 4D_Tech
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: 4D v17 To QuickBooks Using Miyako's QBO.4DB

2019-12-16 Thread JOHN BAUGHMAN via 4D_Tech
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 components

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

2019-12-13 Thread JOHN BAUGHMAN via 4D_Tech
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 Client/Serve

Re: Cache flushing did not complete... best practice

2019-10-25 Thread JOHN BAUGHMAN via 4D_Tech
> On Oct 25, 2019, at 6:40 AM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > John was using a Time Machine backup and not a 4D backup, which is a > completely different type of backup and one that cannot be totally trusted > like you can with a 4D backup. Time Machine could have be

Re: Cache flushing did not complete... best practice

2019-10-23 Thread JOHN BAUGHMAN via 4D_Tech
I have never had any trouble recovering until this version of 4D (v17R3). > On Oct 23, 2019, at 9:09 AM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > When 4D starts flushing the cache to disk it writes something to the data > file on disk that it is flushing. When the flush finish

Cache flushing did not complete... best practice

2019-10-23 Thread JOHN BAUGHMAN via 4D_Tech
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 all

Re: windows versions for 4D v13.6

2019-08-30 Thread JOHN BAUGHMAN via 4D_Tech
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 > vers

Re: PICTs

2019-08-19 Thread JOHN BAUGHMAN via 4D_Tech
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 john...

Re: save listbox

2019-08-13 Thread JOHN BAUGHMAN via 4D_Tech
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 contac

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

2019-08-08 Thread JOHN BAUGHMAN via 4D_Tech
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

Windows shutdown with 4D Server running as a service

2019-08-08 Thread JOHN BAUGHMAN via 4D_Tech
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 compute

Re: User and Group information error on validation

2019-07-31 Thread JOHN BAUGHMAN via 4D_Tech
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@lists.4d.co

Another validation issue - orphaned method resource

2019-07-31 Thread JOHN BAUGHMAN via 4D_Tech
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 B

User and Group information error on validation

2019-07-31 Thread JOHN BAUGHMAN via 4D_Tech
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 **

Re: Where is this resource file

2019-07-29 Thread JOHN BAUGHMAN via 4D_Tech
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: Where is this resource file

2019-07-29 Thread JOHN BAUGHMAN via 4D_Tech
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

2019-07-28 Thread JOHN BAUGHMAN via 4D_Tech
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 base

Re: Where is this resource file

2019-07-28 Thread JOHN BAUGHMAN via 4D_Tech
> 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 >

Where is this resource file

2019-07-28 Thread JOHN BAUGHMAN via 4D_Tech
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 jo

Re: Microsoft Azure & 4D

2019-07-20 Thread JOHN BAUGHMAN via 4D_Tech
these and update the > database with 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 se

Microsoft Azure & 4D

2019-07-19 Thread JOHN BAUGHMAN via 4D_Tech
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 AWS

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

2019-07-19 Thread JOHN BAUGHMAN via 4D_Tech
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 j

Get System Info vs PLATFORM PROPERTIES

2019-07-14 Thread JOHN BAUGHMAN via 4D_Tech
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 proce

Importing from camera

2019-07-07 Thread JOHN BAUGHMAN via 4D_Tech
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: http:

Re: Indexing taking a log time to reindex

2019-06-26 Thread JOHN BAUGHMAN via 4D_Tech
> 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 appear

Indexing taking a log time to reindex

2019-06-26 Thread JOHN BAUGHMAN via 4D_Tech
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 process

Re: Rotate Picture

2019-06-22 Thread JOHN BAUGHMAN via 4D_Tech
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) >

Rotate Picture

2019-06-22 Thread JOHN BAUGHMAN via 4D_Tech
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 var

HTTP connection to 4D server thru Mac FIrewall

2019-06-22 Thread JOHN BAUGHMAN via 4D_Tech
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 u

HTTP connection to 4D server thru Mac FIrewall

2019-06-22 Thread JOHN BAUGHMAN via 4D_Tech
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 u

Re: [Tip]Set Query Destination

2019-06-21 Thread JOHN BAUGHMAN via 4D_Tech
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 above

V17 current release vs R-release

2019-06-15 Thread JOHN BAUGHMAN via 4D_Tech
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 ha

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

2019-06-08 Thread JOHN BAUGHMAN via 4D_Tech
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 using

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

2019-06-08 Thread JOHN BAUGHMAN via 4D_Tech
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 de

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

2019-06-07 Thread JOHN BAUGHMAN via 4D_Tech
> 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 _o_C_Strin

Re: Zip Code API sites - Follow up

2019-06-04 Thread JOHN BAUGHMAN via 4D_Tech
> 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: Zip Code API sites - Follow up

2019-06-03 Thread JOHN BAUGHMAN via 4D_Tech
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

Zip Code API sites - Follow up

2019-06-03 Thread JOHN BAUGHMAN via 4D_Tech
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 ht

Re: Invalid JSON? - solved

2019-06-02 Thread JOHN BAUGHMAN via 4D_Tech
)#"{") 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: Invalid JSON?

2019-06-02 Thread JOHN BAUGHMAN via 4D_Tech
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

Re: Invalid JSON?

2019-06-02 Thread JOHN BAUGHMAN via 4D_Tech
> 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

Invalid JSON?

2019-06-02 Thread JOHN BAUGHMAN via 4D_Tech
I am getting the following from zip-codes.com… { "item": { "ID": "77252", "Medicare_Rating_Area_ID": "1" } } The list under item: s much much longer. If I use JASON Parse it throws an error…. JSON malformed in line 1, position 1 If I run

Re: Anyone using zipcodeapi

2019-06-02 Thread JOHN BAUGHMAN via 4D_Tech
> 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 method;$url;

Re: Anyone using zipcodeapi

2019-06-01 Thread JOHN BAUGHMAN via 4D_Tech
un it 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_T

Re: Anyone using zipcodeapi

2019-06-01 Thread JOHN BAUGHMAN via 4D_Tech
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

Anyone using zipcodeapi

2019-06-01 Thread JOHN BAUGHMAN via 4D_Tech
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 **

ZipCenter... a blast from the past.

2019-06-01 Thread JOHN BAUGHMAN via 4D_Tech
Anyone besides me using ZipCenter? It has worked great for me through all these years but the license I have fails now when running 64bit 16R6. ASG distributed it but ASG is no more, and David Adams who I believe wrote it does not have a clue about licensing aspects, which I am guessing Michael

Re: V17R3 vs PowerShell

2019-06-01 Thread JOHN BAUGHMAN via 4D_Tech
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. >

Re: V17R3 vs PowerShell

2019-05-31 Thread JOHN BAUGHMAN via 4D_Tech
> 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 te

Re: V17R3 vs PowerShell

2019-05-31 Thread JOHN BAUGHMAN via 4D_Tech
> 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 bi

Re: V17R3 vs PowerShell

2019-05-30 Thread JOHN BAUGHMAN via 4D_Tech
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 instal

Re: V17R3 vs PowerShell

2019-05-30 Thread JOHN BAUGHMAN via 4D_Tech
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 \""+$ScriptPath+"

Re: V17R3 vs PowerShell

2019-05-29 Thread JOHN BAUGHMAN via 4D_Tech
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 scr

V17R3 vs PowerShell

2019-05-29 Thread JOHN BAUGHMAN via 4D_Tech
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 execu

Re: 4D Write Pro: License or privilege error

2019-05-22 Thread JOHN BAUGHMAN via 4D_Tech
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 Fos

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

2019-05-20 Thread JOHN BAUGHMAN via 4D_Tech
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 t

Re: Managing 4D Server as a service

2019-05-10 Thread JOHN BAUGHMAN via 4D_Tech
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: Managing 4D Server as a service

2019-05-10 Thread JOHN BAUGHMAN via 4D_Tech
> 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 ha

Re: Managing 4D Server as a service

2019-05-10 Thread JOHN BAUGHMAN via 4D_Tech
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 connection

Re: Managing 4D Server as a service

2019-05-09 Thread JOHN BAUGHMAN via 4D_Tech
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 <4d_tech@lists.4d.

Managing 4D Server as a service

2019-05-09 Thread JOHN BAUGHMAN via 4D_Tech
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 no

Re: Error code 183(W132)

2019-03-14 Thread JOHN BAUGHMAN via 4D_Tech
Sorry, forgot… Windows Server 2008 R2 Enterprise Service Pac 1 V16R6 64bit > On Mar 14, 2019, at 4:27 AM, Chip Scheide <4d_o...@pghrepository.org> wrote: > > platform and version? > > On Wed, 13 Mar 2019 18:24:57 -1000, JOHN BAUGHMAN via 4D_Tech wrote: >> One o

Error code 183(W132)

2019-03-13 Thread JOHN BAUGHMAN via 4D_Tech
One of my deployed 4D server has suddenly started throwing this error (see below). When the error is being displayed 4D server is not visible. When the ok button is clicked 4D server becomes visible. A quick google search finds some discussion about this error independent of 4D and one provides

Re: Replacement Code for very old DisplayList plugin

2019-01-07 Thread JOHN BAUGHMAN via 4D_Tech
If AreaListPro is the same price and if it is the same as the old DisplayList plugin then that would certainly be the easiest approach. The question for me would be whether I prefer to use a component of plugin. For me the component. > On Jan 7, 2019, at 10:34 AM, JOHN BAUGHMAN via 4D_T

Re: Replacement Code for very old DisplayList plugin

2019-01-07 Thread JOHN BAUGHMAN via 4D_Tech
ww.e-node.net/alp > > Best regards, > -- > Phil > > > >> On 7 Jan 2019, at 01:17, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> Tony Ringsmuth, http://bbsp.com, has an excellent component called >> DisplayList4D

Re: Replacement Code for very old DisplayList plugin

2019-01-06 Thread JOHN BAUGHMAN via 4D_Tech
Tony Ringsmuth, http://bbsp.com, has an excellent component called DisplayList4D ($99.00 if you like it). John John Baughman 1331 Auwaiku Street Kailua, Hawaii 96734 (808) 262-0328 john...@hawaii.rr.com > On Jan 6, 2019, at 1:05 PM, Walt Nelson via 4D_Tech <4d_tech@lists.4d.com> > wrote: >

Re: Converting pictures

2018-12-28 Thread JOHN BAUGHMAN via 4D_Tech
What I did was cut each picture off the form to the pasteboard run the following code then paste it back into the form… C_PICTURE($picture_c) GET PICTURE FROM PASTEBOARD($picture_c) // convert the picture CONVERT PICTURE($picture_c;".png") // make all white pixels transparent TRANSFORM PICTU

Re: 4D Mojave full disk access

2018-12-03 Thread JOHN BAUGHMAN via 4D_Tech
wdc2018/702 > > see slide #22 for full list > > 2018/12/04 5:49、JOHN BAUGHMAN via 4D_Tech > <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール: > does one still have access to and remain able to create and move files within >

Re: 4D Mojave full disk access

2018-12-03 Thread JOHN BAUGHMAN via 4D_Tech
Armin, Not sure what a DMS folder is, but does one still have access to and remain able to create and move files within the database folder? What about 4D Backup to an external disk? Perhaps your code should be implemented just as a normal practice regardless. John John Baug

Re: 4D Mojave full disk access

2018-12-03 Thread JOHN BAUGHMAN via 4D_Tech
Armin, Thanks! Could you expand on what you mean by “full disk access”? In Mojave what becomes inaccessible? John > On Dec 3, 2018, at 3:38 AM, ADeeg via 4D_Tech <4d_tech@lists.4d.com> wrote: > > Hi, > > if your app needs full disk access an macOS 10.14.x Mojave and newer,

Re: Publishing a DB on the WWW. Howto.

2018-12-03 Thread JOHN BAUGHMAN via 4D_Tech
Nolan, As others have pointed out, you have lots of ways to go. I use Xojo (xojo.com ) to create web apps to talk to 4D using much of what you will find in David Adam’s book “4D Web Companion”. I did a demo of what I am doing at a 4DMethod meeting recently which you ca

Re: Mojave

2018-11-30 Thread John Baughman via 4D_Tech
I had to convert all my pict format graphics, static and in the picture library. Otherwise 4D would crash when a form containing one or more of them was displayed. 16R6.. client is experimenting with a couple of clients running Mojave. So far no complaints since fixing the pics. Not tried serv

Re: TAOW (Mojave and CREATE THUMBNAIL)

2018-11-26 Thread JOHN BAUGHMAN via 4D_Tech
Thanks Keisuke. So I must be going to the wrong place to see the bug list. I always end up at taow.4d.com but only see my support cases. I thought I could search the TAOW for reported issues before reporting my own. Is this not the case? If not, how? Thanks, John > On Nov 25, 2018, at 3:00

TAOW (Mojave and CREATE THUMBNAIL)

2018-11-24 Thread JOHN BAUGHMAN via 4D_Tech
I want to see if this has already been reported but don’t see how to search for existing cases about Mac OS 10.14 in the TAOW. Running 10.14.1 with 16R6 if I do… CREATE THUMBNAIL($ImagePtr->;vThumbnail;98;120) vThumbnail displays slanted to the left with what looks like multiple images.

Re: Resource Pictures

2018-11-23 Thread JOHN BAUGHMAN via 4D_Tech
Another note to Keisuke’s instructions. You cannot just change the number. After doing the first one as Keisuke described manualyl, the name and negative number must be replaced by just the new positive number. 1. Change one of the objects manually to a static picture an back to a libr

Re: Resource Pictures

2018-11-23 Thread JOHN BAUGHMAN via 4D_Tech
Keisuke, Thank you! Your instructions worked well. One thing to note is that the first (only one so far) that I updated this way changed the icon. The name of the picture is "Separateur vertical Mac” and was a small solid grey vertical line. It is now a dotted line. No problem, but I will have t

Re: Resource Pictures

2018-11-23 Thread JOHN BAUGHMAN via 4D_Tech
Along the same line as my first question, I have 4 picture buttons that use the same Resource file. The property lists a resource ID, no name. I am pretty sure that the picture is a mask. I use these as movable guidelines over a photo for cropping in a QPix image area. I learned how to do this f

Resource Pictures

2018-11-22 Thread JOHN BAUGHMAN via 4D_Tech
I am going through a database in preparation for going to 64bi deployment and fixing all the pictures. Where do I find a picture resource listed in the Property list as… Image titre liste/-2082 I should know this. ;-( Thanks, John John Baughman Kailua, Hawaii (808) 262-0328 john...@

Re: 4D v17 & macOS Mojave beta

2018-10-25 Thread JOHN BAUGHMAN via 4D_Tech
One of my client’s decided to upgrade a computer to Mojave and reported that 4D was creating. I think I have narrowed down the problem at least for my application. It looks like any form that has static pictures or maybe even picture buttons causes 4D to crash both in the design environment as

Re: [ANN] Q2Pix 1.0b2 available

2018-10-25 Thread JOHN BAUGHMAN via 4D_Tech
Ooops, This was meant to be a private message to Escape support, but I guess it could be a general question about why a picture created on an iPhone (HAIF) converted to jpeg by the OS in an Airdrop transfer may not be the same as a jpeg saved directly to the computer from a digital camera? At l

Re: [ANN] Q2Pix 1.0b2 available

2018-10-25 Thread JOHN BAUGHMAN via 4D_Tech
Hi Danis, I am running in to a strange problem with QPix (3.7b2 and 4D v16R6 Client/Server on Mac OS 10.13.6). The following is returning error -50, Parameter Error… $eror:=QPx_SetAreaPicture (eQPixEdit;aPicturesToEditPtr{aPictureThumbs}->) This install

Re: v13 - Why does this query not work?

2018-10-24 Thread JOHN BAUGHMAN via 4D_Tech
Chip, I may be wrong but I don’t think you can query a table based on a many table relation. I would… RELATE MANY SELECTION([BnchProt_File_Link]Bench_Protocol_ID) RELATE ONE SELECTION( [BnchProt_File_Link];[Bench_Protocols] ) John John Baughman Kailua, Hawaii (808) 26

Re: Longing IDs or UUIDs as primary key?

2018-10-24 Thread John Baughman via 4D_Tech
It made no sense to me to abandon my longint primary keys used for relational integrity and uniqueness in a long standing system when 4D would automatically establish and maintain a new UUID primary key for the purposes of replication and sharing right along side my working longint field. Jo

Re: Mac OS 10.14 Mojave and 4D 15

2018-10-20 Thread JOHN BAUGHMAN via 4D_Tech
Kirk, I highly recommend Oracle VirtualBox it’s FREE and I have found it far easier to setup and maintain than either VMWAre or Parallels. Oracle does a great job of keeping it updated. Just had an update this morning. I am currently running Windows 2008 Server 32bit and 64bit,

List Box Font Color Expression, how?

2018-10-10 Thread JOHN BAUGHMAN via 4D_Tech
In a Selection based list box how do you set a row font color based on a condition such as if records in a related many table exist or not. I would like to set the font color for the row to red if the related many table has records and black if it does not. I see that a method entered in Font C

  1   2   3   4   >