Re: MySql login problem

[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 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 - the changes
> will not take affect util they restart the database. Should be rather
> fast.
> Did they have credentials in the Catbase app that may have changed? Is it
> used to access MySql?
>
> Digest reader, so if you want a quicker response from me use the email
> address below.
>
>
>
> 
> 
>
> Edgar Hammond
> ehamm...@questinformation.com
>
> Quest Information Systems
>
>
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **



-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: issue on windows 10 and 4D 15

[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

 Chuck Miller Voice: (617) 739-0306
 Informed Solutions, Inc. Fax: (617) 232-1064   
 mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase connectivity
  http://www.informed-solutions.com  

This message and any attached documents contain information which may be 
confidential, subject to privilege or exempt from disclosure under applicable 
law.  These materials are intended only for the use of the intended recipient. 
If you are not the intended recipient of this transmission, you are hereby 
notified that any distribution, disclosure, printing, copying, storage, 
modification or the taking of any action in reliance upon this transmission is 
strictly prohibited.  Delivery of this message to any person other than the 
intended recipient shall not compromise or waive such confidentiality, 
privilege or exemption from disclosure as to this communication. 

> On Jun 15, 2018, at 12:19 PM, Two Way Communications via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> The thing is, that the user may not want to change his settings under Windows.
> 
> The cause is that the pictures have been resized manually in the 4D form 
> editor.
> I had the same issue in one of my applications a while ago.
> 
> I replaced the pictures on the form with a .png file in the resources, or I 
> made sure that the picture has not been resized manually in the 4D form 
> editor.

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: MySql login problem

[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 - the changes 
will not take affect util they restart the database. Should be rather 
fast.
Did they have credentials in the Catbase app that may have changed? Is it 
used to access MySql?

Digest reader, so if you want a quicker response from me use the email 
address below.





Edgar Hammond 
ehamm...@questinformation.com

Quest Information Systems



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Content Security Policy - inline style

[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.
> 
> https://observatory.mozilla.org/ 
> 
> We found answers to exactly your issues by following these steps.
> 
> - Jim

Nice resource; thanks.

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Objects without Stylesheets suddenly displayed as Wingdings!

[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 process during runtime.
> 
> To assign style sheets to the structure objects you need to modify 
> the objects within the form editor.
> http://doc.4d.com/4Dv15/4D/15.6/Applying-a-style-sheet.300-3836676.en.html
> 
> -Tim
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Objects without Stylesheets suddenly displayed as Wingdings!

[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.
http://doc.4d.com/4Dv15/4D/15.6/Applying-a-style-sheet.300-3836676.en.html

-Tim



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Default Font ? 4D 15.4 & Windows 10

[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
> set to automatic (probably static text would work as well).
>
> I then run OBJECT Get font(*;"My Text") etc to retrieve the font name
> and store that in an IP variable.  I guess you could use storage
> nowadays.
>
> <>Dlg_FontName_t:=OBJECT Get font(*;"Dlg_Text1_t")
> <>Dlg_FontSize_i:=OBJECT Get font size(*;"Dlg_Text1_t")
> <>Dlg_FontStyle_i:=OBJECT Get font style(*;"Dlg_Text1_t")
> OBJECT GET COORDINATES(*;"Dlg_Text1_t";$Left_i;$Top_i;$Right_i;$Bottom_i)
> <>Dlg_FontHeight_i:=$Bottom_i-$Top_i
>
> Then you could call
>
> OBJECT SET FONT(*;"@";"<>Dlg_FontName_t")
>
> This way you will get the correct font on startup for different systems.
>
>
> Regards,
>
> Wayne
>
>
> Wayne Stewart
> about.me/waynestewart
>
>
>
>
> On 15 June 2018 at 03:29, Jim Hays via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> > How about:
> >
> > OBJECT SET FONT(*;"@";"Segoe UI")
> >
> >
> >
> > On Thu, Jun 14, 2018 at 10:28 AM David Rose via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> >
> >> Has anyone found a solution? (BTW, I just received a report of this
> problem
> >> from a Windows 7 user.)
> >>
> >>
> >>
> >> --
> >> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> >> **
> >> 4D Internet Users Group (4D iNUG)
> >> FAQ:  http://lists.4d.com/faqnug.html
> >> Archive:  http://lists.4d.com/archives.html
> >> Options: https://lists.4d.com/mailman/options/4d_tech
> >> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> >> **
> > **
> > 4D Internet Users Group (4D iNUG)
> > FAQ:  http://lists.4d.com/faqnug.html
> > Archive:  http://lists.4d.com/archives.html
> > Options: https://lists.4d.com/mailman/options/4d_tech
> > Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> > **
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Content Security Policy - inline style

[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.

- Jim




On Thu, Jun 14, 2018 at 6:15 PM Timothy Penner via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I think it's telling you that the page does not have a default-src self
> tag. Therefore Content-Security-Policy (CSP) is blocking the loading of
> inline styles
> https://content-security-policy.com/
>
> Quote: "The default-src is the default policy for loading content such as
> JavaScript, Images, CSS, Fonts, AJAX requests, Frames, HTML5 Media. See the
> Source List Reference for possible values."
> https://content-security-policy.com/#source_list
>
> The comments on this stack overflow post suggest not using inline css at
> all because it is unsafe:
>
> https://stackoverflow.com/questions/17766817/refused-to-apply-inline-style-because-it-violates-the-following-content-security/18428346
>
> -Tim
>
>
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Objects without Stylesheets suddenly displayed as Wingdings!

[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 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 Way Communications bvba
>
>
>
> > On 13 Jun 2018, at 20:57, Cheryl Michels via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > A recent Windows update (Windows 10, version 1803) has resulted in at
> least two of our customer sites reporting that certain form objects are now
> displaying as Wingdings.  When I look at these objects, I note that the
> developer did not assign a style sheet to them.  Against our SOP, but that
> is a different story.  So, using Form Introspection, I have discovered over
> 14,000 objects without stylesheets.  Not a trivial task to set them all.
> >
> > Has anyone else run into this problem?  Is there something I can do
> globally that I'm not thinking of?  Is there something that is causing it
> to select Wingdings that I can undo?
> >
> > Cheryl Michels
> > President and System Architect
> > che...@freezerworks.com
> > (425) 673-1974
> > www.freezerworks.com
> > Dataworks Development, Inc.
> > Providing secure and configurable data management solutions for research
> and clinical labs since 1987.
> > [Description: cid:image003.png@01D3FCEC.D2F77330]<
> http://www.freezerworks.com/index.php/user-education-conference/?utm_source=signature_medium=footer_campaign=hos-int-2018-uec_content=other
> >
> >
> > **
> > 4D Internet Users Group (4D iNUG)
> > FAQ:  http://lists.4d.com/faqnug.html
> > Archive:  http://lists.4d.com/archives.html
> > Options: https://lists.4d.com/mailman/options/4d_tech
> > Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> > **
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: MySql login problem

[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
https://mxtoolbox.com/SuperTool.aspx?action=ptr%3a62.30.219.230
^ So I am not sure why one of the two uses a IP and the other uses the DNS 
name...

Regarding the access, does your MySQL database define the user as 
beltour_vendor@* or are you defining the user on a per machine basis?
If the user is defined on a per machine basis then  you will need to make  sure 
 that the appropriate user access exists in MySQL.
If the user is defined on a per machine basis and the hostname of the machine 
changed then the user account will be different (the hostname is part of the 
authentication process).

In other words, the following two users could have different accounts defined 
on the mysql server since the hostname is part of user account defined on the 
server:
'belltour_vendor'@'S01067cb21b32a9c7.cg.shawcable.net'
'belltour_vendor'@'62.30.219.230'

-Tim




**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

MySql login problem

[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 :) I've checked that
they have all the correct credentials.

I suspect it is something to do with their network / firewall settings -
something must have changed.
If I deliberately use the wrong password I get an error message like this:

1045: Access denied for user 'belltour_vendor'@'62.30.219.230' (using
password: YES)

That's my IP address :)

They get a message like this:
1045: Access denied for user 'belltour_vendor'@'
S01067cb21b32a9c7.cg.shawcable.net' (using password: YES)

I'm no expert on these things but that looks like it is a network address.
The MySql server doesn't like it.

Any ideas about this?

PB

-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Graphing in 4Dv15

[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 with other references.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Graphing in 4Dv15

[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 Ronnie Teo via 
4D_Tech
Sent: Friday, June 15, 2018 10:52 AM
To: 4D iNug Technical
Cc: Ronnie Teo
Subject: Graphing in 4Dv15

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

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Comparing all methods in structures

[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 


Dani Beaubien



> On Jun 15, 2018, at 11:38 AM, Two Way Communications via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> 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 Communications bvba 
> 
> 
> 
>> On 15 Jun 2018, at 19:15, 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 an easy way to 
>> compare the methods in the two structures?
>> 
>> I suppose running a small method, in each structure, which exports all the 
>> methods into a folder and then using something like BBEdit to do the 
>> comparison would work, but has anyone had to do this and come up with 
>> something better?
>> 
>> Jeremy
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4d.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Graphing in 4Dv15

[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

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Comparing all methods in structures

[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 Communications bvba 



> On 15 Jun 2018, at 19:15, 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 an easy way to compare the 
> methods in the two structures?
> 
> I suppose running a small method, in each structure, which exports all the 
> methods into a folder and then using something like BBEdit to do the 
> comparison would work, but has anyone had to do this and come up with 
> something better?
> 
> Jeremy
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Comparing all methods in structures

[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 an easy way to compare the 
> methods in the two structures?
> 
> I suppose running a small method, in each structure, which exports all the 
> methods into a folder and then using something like BBEdit to do the 
> comparison would work, but has anyone had to do this and come up with 
> something better?
> 

Export and compare in BBEdit (or Kaleidoscope) is exactly what I do.

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Comparing all methods in structures

[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 each structure, which exports all the 
methods into a folder and then using something like BBEdit to do the comparison 
would work, but has anyone had to do this and come up with something better?

Jeremy
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Sometimes speed bites

[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.
> 
> --
> 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 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 process. So, a LOAD 
>> RECORD/If Locked loop does what is necessary.
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

_
Bob McKeever  http://www.mswl.com 
McKeever's Software Wizardry
Port Coquitlam, B.C.
bobmckee...@mac.com




**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Sometimes speed bites

[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
> process. So, a LOAD RECORD/If Locked loop does what is necessary.

Sounds like a job for a worker :) 

Unload the record, message the worker... done.

Neil









Privacy Disclaimer: This message contains confidential information and is 
intended only for the named addressee. If you are not the named addressee you 
should not disseminate, distribute or copy this email. Please delete this email 
from your system and notify the sender immediately by replying to this email.  
If you are not the intended recipient you are notified that disclosing, 
copying, distributing or taking any action in reliance on the contents of this 
information is strictly prohibited.

The Alternative Investments division of UMB Fund Services provides a full range 
of services to hedge funds, funds of funds and private equity funds.  Any tax 
advice in this communication is not intended to be used, and cannot be used, by 
a client or any other person or entity for the purpose of (a) avoiding 
penalties that may be imposed on any taxpayer or (b) promoting, marketing, or 
recommending to another party any matter addressed herein.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Delay process bug

[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
records created by imports from various, simultaneous sources, I use this
outline:

// UniqueProcessMethod (some parameter)
$processName:=Current method name
Case of

:(Count parameters=1)

$pid:=Process number($processName)

If($pid=0)  // process doesn't exist

$pid:=EXECUTE ON SERVER(Current method name; 1024*1024; $processName;
$1;Current process)

End if

:(Count parameters=2)

//  do whatever here

End case


This works consistently if called from a client process or server process.
I prefer making $1 an object but the approach works just as well if you
have more than one parameter. The key is adding the current process
(sometimes useful) to distinguish between the call to start the process and
just checking data.

The other tool I have for such situations is a really simple stored method
launcher. It requires 1 table, a background loop (which delays 1 minute)
and the idea is to create a record for each method that I want to run at
some interval. I'm sure a lot of you already have such a thing in place.
This is what I use in place of long delays. Like for daily reports or
maintenance methods.

On Fri, Jun 15, 2018 at 12:04 AM Bernd Fröhlich via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> 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 still would not use it at the moment.
> Until it stopped beeing reliable I used it to delay a process by 10
> seconds.
>
> Greetings from Germany,
> Bernd Fröhlich
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **



-- 
Kirk Brooks
San Francisco, CA
===

*We go vote - they go home*
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: issue on windows 10 and 4D 15

[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 upon the specific version of 
Windows 10.

Easy-Peasy Lemon Squeezy!   


Randy Engle, Director
XC2 Software LLC – XC2LIVE!

-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Randy Jaynes via 
4D_Tech
Sent: Friday, June 15, 2018 6:13 AM
To: 4D iNug List <4d_tech@lists.4d.com>
Cc: Randy Jaynes 
Subject: Re: issue on windows 10 and 4D 15

Chuck,

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

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 Please send all email contacts to 
supp...@printpoint.com 




> On Jun 15, 2018, at 8:09 AM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com 
> > 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 deleting local files, 
> reinstalling 4D, to no avail. Any ideas out ther greatly appreciated
> 
> Thanks and regards.

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Updating a structure - data goes AWOL

[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 structure to
the old structure. They may not be recognized as belonging to the table
with the same name in the new structure because the UUID is different. In
that case the best solution may be to export the data from tables that were
heavily modified from the old structure. I would write a custom export
method in the old structure to transform the data into the format the new
structure expects, export it and import into the new one. I find doing the
transforms in the old structure easier.

Some things I'm sure you know already and assuming a large datafile: turn
off indexes as much as you can. If you use triggers heavily you can bypass
them with a semaphore set by the importing method. This allows you to
preserve things like mod dates plus greatly speed up the import process.

On Fri, Jun 15, 2018 at 4:31 AM Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> 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 from old database into new one
> >
> > Regards
> >
> > Chuck
> >
> > Sent from my iPhone
> >
> > > On Jun 14, 2018, at 8:36 PM, Pat Bensky via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> > >
> > > I'm updating a client's database from an old version of my app, in 4D
> > v12,
> > > to the latest version, using v16. There have been various modifications
> > to
> > > the structure in between the version they are using and the current
> > > version. Tables have been added, deleted, repurposed. The result is
> that
> > > when the database is opened in the v16 version, some of the tables are
> > lost.
> > >
> > > I figured out that I should be able to fix this by using GET MISSING
> > TABLE
> > > NAMES and REGENERATE MISSING TABLE.
> > >
> > > But some of the missing table names are the same as some "live" table
> > names
> > > in the updated structure.
> > > So I changed the names of those tables in the old structure by adding
> > "_x"
> > > to each one. e.g. "data_61" becomes "data_61_x" etc.
> > >
> > > However, after opening the database in the updated (v16) structure, the
> > > missing table names list shows the ORIGINAL table names, not the
> MODIFIED
> > > ONES! "data_61_x" has reverted to "data_61", etc. So if I try to use
> > > REGENERATE MISSING TABLE, nothing happens because there is already a
> > table
> > > with that name.
> > >
> > > ​Any ideas about this?
> > > Pat​
> > >
> > > --
> > > *
> > > CatBase - Top Dog in Data Publishing
> > > tel: +44 (0) 207 118 7889
> > > w: http://www.catbase.com
> > > skype: pat.bensky
> > > *
> > > **
> > > 4D Internet Users Group (4D iNUG)
> > > FAQ:  http://lists.4d.com/faqnug.html
> > > Archive:  http://lists.4d.com/archives.html
> > > Options: https://lists.4d.com/mailman/options/4d_tech
> > > Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> > > **
> >
> > **
> > 4D Internet Users Group (4D iNUG)
> > FAQ:  http://lists.4d.com/faqnug.html
> > Archive:  http://lists.4d.com/archives.html
> > Options: https://lists.4d.com/mailman/options/4d_tech
> > Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> > **
>
>
>
> --
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **



-- 
Kirk Brooks
San Francisco, CA
===

*We go vote - they go home*
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Updating a structure - data goes AWOL

[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 selection($Current_Table->)
  send variable($Doc_Ref;$Record_Count)

For ($ii;1;records in selection($Current_Table->))
  send record($Doc_Ref;$Current_Table->)
  next record($Current_Table->)
end for
end for
NOTE: code above was written in email, so no promises about syntax etc  
:)

a simple export utility not necessarily the most efficient, but always 
useful to have around.
you can populate the (pointer) array $Bad_Tables as appropriate.
and a corresponding import routine

On Fri, 15 Jun 2018 12:30:54 +0100, Pat Bensky via 4D_Tech wrote:
> 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 from old database into new one
>> 
>> Regards
>> 
>> Chuck
>> 
>> Sent from my iPhone
>> 
>>> On Jun 14, 2018, at 8:36 PM, Pat Bensky via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>>> 
>>> I'm updating a client's database from an old version of my app, in 4D
>> v12,
>>> to the latest version, using v16. There have been various modifications
>> to
>>> the structure in between the version they are using and the current
>>> version. Tables have been added, deleted, repurposed. The result is that
>>> when the database is opened in the v16 version, some of the tables are
>> lost.
>>> 
>>> I figured out that I should be able to fix this by using GET MISSING
>> TABLE
>>> NAMES and REGENERATE MISSING TABLE.
>>> 
>>> But some of the missing table names are the same as some "live" table
>> names
>>> in the updated structure.
>>> So I changed the names of those tables in the old structure by adding
>> "_x"
>>> to each one. e.g. "data_61" becomes "data_61_x" etc.
>>> 
>>> However, after opening the database in the updated (v16) structure, the
>>> missing table names list shows the ORIGINAL table names, not the MODIFIED
>>> ONES! "data_61_x" has reverted to "data_61", etc. So if I try to use
>>> REGENERATE MISSING TABLE, nothing happens because there is already a
>> table
>>> with that name.
>>> 
>>> ​Any ideas about this?
>>> Pat​
>>> 
>>> --
>>> *
>>> CatBase - Top Dog in Data Publishing
>>> tel: +44 (0) 207 118 7889
>>> w: http://www.catbase.com
>>> skype: pat.bensky
>>> *
>>> **
>>> 4D Internet Users Group (4D iNUG)
>>> FAQ:  http://lists.4d.com/faqnug.html
>>> Archive:  http://lists.4d.com/archives.html
>>> Options: https://lists.4d.com/mailman/options/4d_tech
>>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>>> **
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4d.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
> 
> 
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: issue on windows 10 and 4D 15

[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 deleting 
> local files, reinstalling 4D, to no avail. Any ideas out ther greatly 
> appreciated
> 
> Thanks and regards.
> 
> 
> Chuck
> 

>  Chuck Miller Voice: (617) 739-0306
>  Informed Solutions, Inc. Fax: (617) 232-1064   
>  mailto:cjmillerinformed-solutions.com 
>  Brookline, MA 02446 USA Registered 4D Developer
>Providers of 4D and Sybase connectivity
>   http://www.informed-solutions.com  
> 

> This message and any attached documents contain information which may 
> be confidential, subject to privilege or exempt from disclosure under 
> applicable law.  These materials are intended only for the use of the 
> intended recipient. If you are not the intended recipient of this 
> transmission, you are hereby notified that any distribution, 
> disclosure, printing, copying, storage, modification or the taking of 
> any action in reliance upon this transmission is strictly 
> prohibited.  Delivery of this message to any person other than the 
> intended recipient shall not compromise or waive such 
> confidentiality, privilege or exemption from disclosure as to this 
> communication. 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Updating a structure - data goes AWOL

[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 [data_61] (and others) and 
import into upgraded version 
basically as Chuck suggests

On Fri, 15 Jun 2018 01:36:23 +0100, Pat Bensky via 4D_Tech wrote:
> I'm updating a client's database from an old version of my app, in 4D v12,
> to the latest version, using v16. There have been various modifications to
> the structure in between the version they are using and the current
> version. Tables have been added, deleted, repurposed. The result is that
> when the database is opened in the v16 version, some of the tables are lost.
> 
> I figured out that I should be able to fix this by using GET MISSING TABLE
> NAMES and REGENERATE MISSING TABLE.
> 
> But some of the missing table names are the same as some "live" table names
> in the updated structure.
> So I changed the names of those tables in the old structure by adding "_x"
> to each one. e.g. "data_61" becomes "data_61_x" etc.
> 
> However, after opening the database in the updated (v16) structure, the
> missing table names list shows the ORIGINAL table names, not the MODIFIED
> ONES! "data_61_x" has reverted to "data_61", etc. So if I try to use
> REGENERATE MISSING TABLE, nothing happens because there is already a table
> with that name.
> 
> ​Any ideas about this?
> Pat​
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: issue on windows 10 and 4D 15

[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 Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Jun 15, 2018, at 8:09 AM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com 
> > 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 deleting local files, 
> reinstalling 4D, to no avail. Any ideas out ther greatly appreciated
> 
> Thanks and regards.

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Sometimes speed bites

[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 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 process. So, a LOAD 
> RECORD/If Locked loop does what is necessary.

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

issue on windows 10 and 4D 15

[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

 Chuck Miller Voice: (617) 739-0306
 Informed Solutions, Inc. Fax: (617) 232-1064   
 mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase connectivity
  http://www.informed-solutions.com  

This message and any attached documents contain information which may be 
confidential, subject to privilege or exempt from disclosure under applicable 
law.  These materials are intended only for the use of the intended recipient. 
If you are not the intended recipient of this transmission, you are hereby 
notified that any distribution, disclosure, printing, copying, storage, 
modification or the taking of any action in reliance upon this transmission is 
strictly prohibited.  Delivery of this message to any person other than the 
intended recipient shall not compromise or waive such confidentiality, 
privilege or exemption from disclosure as to this communication. 

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Write Pro: programmatically manipulate text expertise needed

[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 <
4d_tech@lists.4d.com> wrote:

> Hi Pat,
>
> Your tips seem to work, but I am hoping you also know the answer to the
> next problem.
> See example 1 : After replacing the text with ST SET
> TEXT($wp_obj;$text;$start_pos;$end_pos) the cursor must be set after the
> last inserted character. This replacing is done in the On After Keystroke
> event of the Write Pro area and is triggered when the user types a space.
> However, I don't succeed in setting the cursor at the end of the inserted
> text, it stays at the position where it was (position after the original
> space)
>
> Do you also have a tip how to set the cursor to a different position in
> the "On After Keystroke" event of the Pro Area?
>
> Thanks,
>
> Piotr
>
>
> > -Oorspronkelijk bericht-
> > Van: Pat Bensky 
> > Verzonden: dinsdag 12 juni 2018 13:40
> > Aan: 4D iNug Technical <4d_tech@lists.4d.com>
> > Onderwerp: Re: Write Pro: programmatically manipulate text expertise
> needed
> >
> > Piotr,
> > 1. I think you will need to use ST GET PLAIN TEXT to get all the text
> after the
> > specified range and then look for the first return character in that
> selection. I
> > believe this is the only way to get an accurate position with styled
> text.
> >
> > 2. Again, use ST GET PLAIN TEXT to get a range of text from the cursor
> position
> > back n characters or to the beginning of the text.
> >
> > HTH
> >
> > Pat
> >
> > On Tue, 12 Jun 2018 at 10:02, Piotr Chabot Stadhouders via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> >
> > > Hi all,
> > >
> > > We are in the progress of migrating from 4D Write to Write Pro A lot
> > > of things are going fine, but there is one area that seems easy but I
> > > am having difficulties with it and that is programmatically
> > > manipulating text
> > >
> > > I give 2 examples that maybe seem obvious to others but are not for me:
> > >
> > >   1.  I am in a procedure where I have an Write Pro object (not perce
> > > an area on screen, could be a range) and an expression has been
> > > selected via $type:=ST Get content
> > > type($wp_obj;$start;$end;$startBlock;$endBlock). I call the command ST
> > > SET TEXT($wp_obj;$text;$startBlock;$endBlock) to replace the selected
> > expression. So far no problems, but here it comes...
> > > Now I want to find the first occurrence of a carriage return in the
> > > text that comes after the replaced text (end inserted text - end whole
> text).
> > > What is the best / easiest way to do this? Remember, this text can
> > > contain styled text and/or expressions and/or pictures
> > >   2.  Example 2 is like example 1 but now with an actual visual area.
> > > The user types a couple of characters. At a certain point after typing
> > > I want to procedurally replace the typed text from the cursor back
> > > until the first space and replace it with another text. Maybe somebody
> > > knows "Type it for me", this is what I am talking about. So, what is
> > > the best way to find the first occurrence of a space from the cursor
> > > back and replace this text with another text?
> > >
> > > Thanks in advance,
> > >
> > > Piotr
> > >
> > >
> > 
> > **
> > > 4D Internet Users Group (4D iNUG)
> > > FAQ:  http://lists.4d.com/faqnug.html
> > > Archive:  http://lists.4d.com/archives.html
> > > Options: https://lists.4d.com/mailman/options/4d_tech
> > > Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> > >
> > 
> > **
> >
> >
> >
> > --
> > *
> > CatBase - Top Dog in Data Publishing
> > tel: +44 (0) 207 118 7889
> > w: http://www.catbase.com
> > skype: pat.bensky
> > *
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **



-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com

Re: Updating a structure - data goes AWOL

[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 from old database into new one
>
> Regards
>
> Chuck
>
> Sent from my iPhone
>
> > On Jun 14, 2018, at 8:36 PM, Pat Bensky via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > I'm updating a client's database from an old version of my app, in 4D
> v12,
> > to the latest version, using v16. There have been various modifications
> to
> > the structure in between the version they are using and the current
> > version. Tables have been added, deleted, repurposed. The result is that
> > when the database is opened in the v16 version, some of the tables are
> lost.
> >
> > I figured out that I should be able to fix this by using GET MISSING
> TABLE
> > NAMES and REGENERATE MISSING TABLE.
> >
> > But some of the missing table names are the same as some "live" table
> names
> > in the updated structure.
> > So I changed the names of those tables in the old structure by adding
> "_x"
> > to each one. e.g. "data_61" becomes "data_61_x" etc.
> >
> > However, after opening the database in the updated (v16) structure, the
> > missing table names list shows the ORIGINAL table names, not the MODIFIED
> > ONES! "data_61_x" has reverted to "data_61", etc. So if I try to use
> > REGENERATE MISSING TABLE, nothing happens because there is already a
> table
> > with that name.
> >
> > ​Any ideas about this?
> > Pat​
> >
> > --
> > *
> > CatBase - Top Dog in Data Publishing
> > tel: +44 (0) 207 118 7889
> > w: http://www.catbase.com
> > skype: pat.bensky
> > *
> > **
> > 4D Internet Users Group (4D iNUG)
> > FAQ:  http://lists.4d.com/faqnug.html
> > Archive:  http://lists.4d.com/archives.html
> > Options: https://lists.4d.com/mailman/options/4d_tech
> > Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> > **
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **



-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Musing on creating PDFs in 4D

[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 FORM. The plugin commands allow you to
> precisely control where on the page something (text, line, image) will
> appear. Unlike PRINT FORM you can add to existing pages. This greatly
> simplifies, for instance, adding page numbers in the form of "Page x of y".
> You can traverse back and forth through your pages if necessary.
> 
> QPDF allows me to use templates. These can be pre-formatted PDFs or I can
> build one on the fly. My usual workflow in a method is to create the
> document and set the meta data (author, date, subject, etc. - stuff I don't
> think you can do at all when creating PDFs via print engines). Then I'll
> make the page template with things like the report header and footer info.
> Then I basically run down the page adding material just like I would with
> PRINT FORM. I like to make my methods that add material to the page
> functions that return the last y value. Coupled with a method to check for
> available space and handle page breaks it works well.
> 
> I may get around to locating these methods in a component for ease of reuse
> as I think about.
> 
> A few other things I can do with the plugin are include existing PDFs. This
> didn't seem like an incredibly useful feature at first but it is. In the
> case of sales quotes some salesmen like to include cut sheets, drawings or
> brochures from the vendor with their bid. Another use is creating or
> reading PDF forms. If you have a PDF form you must populate but the form is
> really just a scan of something you can still place text in the appropriate
> locations on the page. It's a pain but you only have to do it once.
> 
> Another benefit I don't believe is available any other way is adding
> bookmarks and internal references. Bookmarks are what you see in the
> sidebar and allow you to navigate large documents. Internal references are
> like anchors on a web page and work the same way.
> 
> Don't get me wrong, I have not abandoned traditional print forms by any
> means. It takes some effort to build a PDF form in code for anything beyond
> very simple needs. It's not the right solution for everything. But for
> certain types of documents I'm finding working with it a very deep breath
> of fresh air.
> 
> On Thu, Jun 14, 2018 at 11:07 AM JOHN BAUGHMAN via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Interesting. I have never had a situation where I did not have a
>> relatively  good idea of what a document will look like such that I
>> couldn't create 1 or more variable populated forms to cover all the
>> possibilities.
>> 
>> 
>> John Baughman
>> 1331 Auwaiku Street
>> Kailua, Hawaii  96734
>> (808) 262-0328
>> john...@hawaii.rr.com
>> 
>>> On Jun 14, 2018, at 7:14 AM, Kirk Brooks via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>>> 
>>> John,
>>> Yes. No 4D form printing at all.
>>> 
>>> On Thu, Jun 14, 2018 at 10:14 AM JOHN BAUGHMAN via 4D_Tech <
>>> 4d_tech@lists.4d.com> wrote:
>>> 
 Kirk, are you talking about creating the pdf strictly in code?
 
 Otherwise, as Pat pointed out 4D Write Pro can be used, as can 4D forms…
 
 SET PRINT OPTION(Destination option;3;$FolderPath+"MyTest.pdf")
 OPEN PRINTING JOB
 Print form("MyTest4DForm";Form header)
 CLOSE PRINTING JOB
 
 PDFs from 4D forms using this methodology works both on the client and
>> on
 the server.
 
 
 John Baughman
 1331 Auwaiku Street
 Kailua, Hawaii  96734
 (808) 262-0328
 john...@hawaii.rr.com
 
> On Jun 14, 2018, at 5:37 AM, Pat Bensky via 4D_Tech <
 4d_tech@lists.4d.com> wrote:
> 
> Another option, which may or may not be suitable depending on the
 project,
> is to build the document with 4DWrite Pro and then simply set the print
> option and print it:
> 
> *SET PRINT OPTION*(Orientation option;iPrintOption) // landscape or
 portrait
> 
> *SET PRINT OPTION*(Destination option;3;$pathname)  // PDF
> 
> *WP USE PAGE SETUP*(oWPdoc)
> 
> *WP PRINT*(oWPdoc)
> 
> *SHOW ON DISK*($pathname)
> 
> This will require you to learn how to program Write Pro, but I think
>> that
> will be a bit simpler than learning how to create PDFs, it won't cost
>> you
> any extra, and those skills might come in handy for other 4D projects
>> :)
> 
> Pat
> 
> On Thu, 14 Jun 2018 at 16:22, Kirk Brooks via 4D_Tech <
 4d_tech@lists.4d.com>
> wrote:
> 
>> I just chimed in on a conversation on the forums about using PDF
>> Creator
>> . In this
 case
>> the OP was asking about making it work on the server. I'm sure anyone
 who
>> tried to 

Re: Objects without Stylesheets suddenly displayed as Wingdings!

[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 Way Communications bvba 



> On 13 Jun 2018, at 20:57, Cheryl Michels via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> A recent Windows update (Windows 10, version 1803) has resulted in at least 
> two of our customer sites reporting that certain form objects are now 
> displaying as Wingdings.  When I look at these objects, I note that the 
> developer did not assign a style sheet to them.  Against our SOP, but that is 
> a different story.  So, using Form Introspection, I have discovered over 
> 14,000 objects without stylesheets.  Not a trivial task to set them all.
> 
> Has anyone else run into this problem?  Is there something I can do globally 
> that I'm not thinking of?  Is there something that is causing it to select 
> Wingdings that I can undo?
> 
> Cheryl Michels
> President and System Architect
> che...@freezerworks.com
> (425) 673-1974
> www.freezerworks.com
> Dataworks Development, Inc.
> Providing secure and configurable data management solutions for research and 
> clinical labs since 1987.
> [Description: 
> cid:image003.png@01D3FCEC.D2F77330]
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: select from _USER_COLUMNS

[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:

From that thread:
>
The idea is from David Adams: create fields of any types to see their 
definition in system tables. 

-- 
Arnaud de Montard 


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Delay process bug

[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 still would not use it at the moment.
Until it stopped beeing reliable I used it to delay a process by 10 seconds.

Greetings from Germany,
Bernd Fröhlich
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**