Re: MySql login problem

2018-06-15 Thread Pat Bensky via 4D_Tech
Thanks Tim and Ed. Unfortunately we don't manage their MySql server or have access to it. I will pass your comments along to their IT guy. Cheers Pat On Fri, 15 Jun 2018 at 21:03, Ed Hammond via 4D_Tech <4d_tech@lists.4d.com> wrote: > >They get a message like this: > >1045: Access denied for

Re: issue on windows 10 and 4D 15

2018-06-15 Thread Chuck Miller via 4D_Tech
Buy that will be a lot of work. I would guess I can run code to change all pict to pngs in the library. I do not think it is just one form. That is the problem BTW the right click and changes did not seem to work Regards Chuck

Re: MySql login problem

2018-06-15 Thread Ed Hammond via 4D_Tech
>They get a message like this: >1045: Access denied for user 'belltour_vendor'@' >S01067cb21b32a9c7.cg.shawcable.net' (using password: YES) Looks like a credentials issue. Here's what I remember from using MySql (it has been some time). If you update the security credentials table within MySql -

Re: Content Security Policy - inline style

2018-06-15 Thread Lee Hinde via 4D_Tech
> On Jun 15, 2018, at 12:18 PM, Jim Hays via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > We wrestled with getting our web security up to snuff without having any > in-house expertise. > I found this site useful for testing and offering up next steps and links > on how to fix the problems. > >

RE: Objects without Stylesheets suddenly displayed as Wingdings!

2018-06-15 Thread Chip Scheide via 4D_Tech
does this requirement go away which the ability (v17?) to export/import forms? On Fri, 15 Jun 2018 19:26:06 +, Timothy Penner via 4D_Tech wrote: > Hi Jim, > >> How about: >> >> OBJECT SET STYLE SHEET >> Created: 4D v14 >> Modified: 4D v15 R3 > > That command only applies to the current

RE: Objects without Stylesheets suddenly displayed as Wingdings!

2018-06-15 Thread Timothy Penner via 4D_Tech
Hi Jim, > How about: > > OBJECT SET STYLE SHEET > Created: 4D v14 > Modified: 4D v15 R3 That command only applies to the current process during runtime. To assign style sheets to the structure objects you need to modify the objects within the form editor.

Re: Default Font ? 4D 15.4 & Windows 10

2018-06-15 Thread Jim Hays via 4D_Tech
And since Cheryl asked on another thread, you can also use OBJECT SET STYLESHEET On Thu, Jun 14, 2018 at 1:50 PM Wayne Stewart via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi, > > I wouldn't hard code Segoe UI necessarily. > > What I do is on startup I launch a small window with a text variable

Re: Content Security Policy - inline style

2018-06-15 Thread Jim Hays via 4D_Tech
We wrestled with getting our web security up to snuff without having any in-house expertise. I found this site useful for testing and offering up next steps and links on how to fix the problems. https://observatory.mozilla.org/ We found answers to exactly your issues by following these steps. -

Re: Objects without Stylesheets suddenly displayed as Wingdings!

2018-06-15 Thread Jim Hays via 4D_Tech
How about: OBJECT SET STYLE SHEET Created: 4D v14 Modified: 4D v15 R3 On Fri, Jun 15, 2018 at 6:10 AM Two Way Communications via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Cheryl, > > I’m afraid there is no solution outside 4D. > > But there is e recent tip in the knowledgebase on how to

RE: MySql login problem

2018-06-15 Thread Timothy Penner via 4D_Tech
I was thinking that the difference in the error message (IP vs DNS name) would have been due to a reverse lookup (PTR) record existing for them and not for you. However, both 70.73.106.74 and 62.30.219.230 have a valid PTR record: https://mxtoolbox.com/SuperTool.aspx?action=ptr%3a70.73.106.74

MySql login problem

2018-06-15 Thread Pat Bensky via 4D_Tech
Got a client who uploads data from their CatBase (4D) database to a MySql db on their web server. This has been working just fine since they went live with it a few weeks ago. Suddenly they are getting a 1045 Access Denied message when they try to connect to it. Of course it works just fine for me

Re: Graphing in 4Dv15

2018-06-15 Thread Jeffrey Kain via 4D_Tech
Google charts works great for us in a web area. > On Jun 15, 2018, at 2:22 PM, Tai Bui via 4D_Tech <4d_tech@lists.4d.com> wrote: > > Hi, > > I have seen people using the Web Area to display charts using JS. Some have > mentioned D3, Highcharts, and Google Charts. > Maybe others can chime in

RE: Graphing in 4Dv15

2018-06-15 Thread Tai Bui via 4D_Tech
Hi, I have seen people using the Web Area to display charts using JS. Some have mentioned D3, Highcharts, and Google Charts. Maybe others can chime in with other references. Best Regards, -Tai B. -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of

Re: Comparing all methods in structures

2018-06-15 Thread Dani Beaubien via 4D_Tech
Hi Jeremy, Use my Code Analysis component, It will let you export one, then you can open the other one and compare against it. That will tell you the code differences. http://openroaddevelopment.com/projects_4dComponent_CodeAnalysis.html

Graphing in 4Dv15

2018-06-15 Thread Ronnie Teo via 4D_Tech
Hi, With 4Dv15 on Windows, does anyone have recommendations as to their favourite graphing/charting plugin currently available? It is preferably a plugin where the plugin license is purchased outright rather than on a yearly subscription… Thanks. Regards, Ronnie Tarawerkz

Re: Comparing all methods in structures

2018-06-15 Thread Two Way Communications via 4D_Tech
Hi Jeremy, What I do is to export all methods and forms in text files, using the commands available in ‘Design Object Access’. Then I use Text Wrangler (BBEdit will also do this) to compare the text files. It will list all the differences. Great tool! Regards, Rudy Mortier Two Way

Re: Comparing all methods in structures

2018-06-15 Thread Lee Hinde via 4D_Tech
On Jun 15, 2018, at 10:15 AM, Jeremy Roussak via 4D_Tech <4d_tech@lists.4d.com> wrote: > > I have two structures, which contain quite a few methods. One has been edited > a bit but due to a slapdash approach to record-keeping, I can’t easily > establish which methods have been edited. Is there

Comparing all methods in structures

2018-06-15 Thread Jeremy Roussak via 4D_Tech
I have two structures, which contain quite a few methods. One has been edited a bit but due to a slapdash approach to record-keeping, I can’t easily establish which methods have been edited. Is there an easy way to compare the methods in the two structures? I suppose running a small method, in

Re: Sometimes speed bites

2018-06-15 Thread Robert McKeever via 4D_Tech
But the code does have an UNLOAD RECORD command. Executed before being handed off to the letter editor process. > On Jun 15, 2018, at 5:56 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I'd have a look at workers and get away from code that depends on timing. > > -- >

RE: Sometimes speed bites

2018-06-15 Thread Dennis, Neil via 4D_Tech
> But if the letter editing process is sitting idle waiting for another letter > to edit, it is resumed, > and I get a message from 4D that you are trying to edit a letter that you are > already editing. > Damn, now running too fast. 4D is not recognizing the UNLOAD RECORD in the > resumed >

Re: Delay process bug

2018-06-15 Thread Kirk Brooks via 4D_Tech
I have never had an issue with DELAY PROCESS. Maybe I'm lucky. I don't think I've ever used it to delay something more than a matter of seconds, though. It would never have occurred to me to DELAY PROCESS for minutes or hours. If I have some process I only want one instance of, maybe processing

RE: issue on windows 10 and 4D 15

2018-06-15 Thread Randy Engle via 4D_Tech
Yes, this has been a problem with some users who have display properties set differently. Right click on the EXE, click on "Properties" Click the Compatibility Tab Click on "Change High DPI Settings" Check "Override High DPI scaling behavior" The above will be slightly different, dependent

Re: Updating a structure - data goes AWOL

2018-06-15 Thread Kirk Brooks via 4D_Tech
Pat, I have done this sort of thing a lot over the years. When there are changes involving deleting and reusing tables I've found it's easier to open the data file in the old developer structure and manipulate the data there. I'm not sure how it will work to add tables that exist in the new

Re: Updating a structure - data goes AWOL

2018-06-15 Thread Chip Scheide via 4D_Tech
you might not have to do "special programming" a simple loop over the tables might suffice i.e. // open a document referenced by $Doc_Ref For ($i; 1; Size of array($Bad_Tables)) $Current_Table:=$Bad_Tables{$i} all records($Current_Table->) $Record_Count:=records in

Re: issue on windows 10 and 4D 15

2018-06-15 Thread Chip Scheide via 4D_Tech
how do they not display properly? are they the wrong size? the wrong resolution? etc On Fri, 15 Jun 2018 08:09:19 -0400, Chuck Miller via 4D_Tech wrote: > Hi All, > > I have one windows ten machine where pictures of buttons do not > display properly. They do on all other instances. We have

Re: Updating a structure - data goes AWOL

2018-06-15 Thread Chip Scheide via 4D_Tech
I think this is due to UUIDs for each table. even though you renamed table [Data_61] to [Data_61_x] the uuid is the same, and probably the upgrade processes the table(s) by uuid not table name. the only solution I can think of (off the top) would be to: - export from the old system the data in

Re: issue on windows 10 and 4D 15

2018-06-15 Thread Randy Jaynes via 4D_Tech
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: Sometimes speed bites

2018-06-15 Thread Jeffrey Kain via 4D_Tech
I'd have a look at workers and get away from code 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 > to

issue on windows 10 and 4D 15

2018-06-15 Thread Chuck Miller via 4D_Tech
Hi All, I have one windows ten machine where pictures of buttons do not display properly. They do on all other instances. We have deleting local files, reinstalling 4D, to no avail. Any ideas out ther greatly appreciated Thanks and regards. Chuck

Re: Write Pro: programmatically manipulate text expertise needed

2018-06-15 Thread Pat Bensky via 4D_Tech
Hi Piotr, I think you can use WP SELECT to do this - WP SELECT ( {* ;} wpArea {; targetObj} | {; startRange ; endRange} ) Let me know if you can't get that to work and I'll take a closer look at it. HTH Pat On Wed, 13 Jun 2018 at 07:35, Piotr Chabot Stadhouders via 4D_Tech <

Re: Updating a structure - data goes AWOL

2018-06-15 Thread Pat Bensky via 4D_Tech
Chuck, Hmmm. this is a one-off exercise so I would prefer not to do some special programming. I would like to understand what's going on in the database though! Thanks Pat On Fri, 15 Jun 2018 at 02:51, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> wrote: > How about using sql to bring data

Re: Musing on creating PDFs in 4D

2018-06-15 Thread Two Way Communications via 4D_Tech
Hi Kirk, Are you using the QPDF plugin from pluggers? If so, which version, QPDF plugin light or Pro? Regards, Rudy Mortier Two Way Communications bvba > On 14 Jun 2018, at 22:48, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > John, > Using QPDF is much like using PRINT

Re: Objects without Stylesheets suddenly displayed as Wingdings!

2018-06-15 Thread Two Way Communications via 4D_Tech
Hi Cheryl, I’m afraid there is no solution outside 4D. But there is e recent tip in the knowledgebase on how to find these objects. And if they can be located, I suppose that the font can be set for thos objects. This way you could write code to address the issues. Regards, Rudy Mortier Two

Re: select from _USER_COLUMNS

2018-06-15 Thread Arnaud de Montard via 4D_Tech
> Le 11 juin 2018 à 22:33, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > What values can be returned in $DataType_aL It seems that they do not equal > 4D data types (I did not expect it to) Is there a chart I can not find that > lists them? See here:

Re: Delay process bug

2018-06-15 Thread Bernd Fröhlich via 4D_Tech
Bryan Green: > Actually, that's exactly what I meant -- short-term (5 minutes, 10 minutes, > etc.) kind of delay using DELAY PROCESS is more stable than something like 12 > hours, 1 day, etc. using DELAY PROCESS. If by "more stable" you mean "hangs only every few weeks" that may be right. I