Re: HTTP Request and x-www-form-urlencoded

2019-10-12 Thread Tom Benedict via 4D_Tech
Hi Narinder, Thanks again for your quick response! >I'm not sure but maybe this will help you? > > >https://github.com/miyako/4d-tips-encode-uri > > I found that component earlier today and it does help a bit. I was looking for a way to fill an

Re: HTTP Request and x-www-form-urlencoded

2019-10-12 Thread Tom Benedict via 4D_Tech
o built in function to do url encoding. > See feature request at the link below along with some code to implement it. > > https://forums.4d.com/Post/EN/17578327/1/17591881 > > John DeSoi, Ph.D. > > > >> On Oct 12, 2019, at 1:54 PM, Tom Benedict via 4D_Tech <4d

HTTP Request and x-www-form-urlencoded

2019-10-12 Thread Tom Benedict via 4D_Tech
I have very little experience with HTTP Request. I’m calling an external REST service using 4D’s HTTP Request command. The REST service requires that the content-type be x-www-form-urlencoded. The “contents” parameter of the HTTP Request command supports sending a 4D Object (JSON) but that is

Re: Make me smart about Write Pro

2019-10-12 Thread Tom Benedict via 4D_Tech
Another key concept to be aware of when working with Write Pro is that is that features are additive. In Write Classic all its features were available by default and you had to restrict or remove features as needed via code. In Write Pro only the most basic features are available by default

Re: Using Github to Manage Distributed Development

2019-10-10 Thread Tom Benedict via 4D_Tech
Thanks for your response Narinder, >ditch the 4D binary based structure file and use v17's 4D Project format Indeed, that is an attractive option, although it requires 17R5 or higher. Once it’s out of beta I may consider it. I’ve heard that once a structure is moved to Project Mode, there’s no

Using Github to Manage Distributed Development

2019-10-10 Thread Tom Benedict via 4D_Tech
In my current environment, each developer works on a separate copy of a “Master" 4D structure. Periodically each developer runs the "Export structure file” command to export everything (methods, forms etc) to local disk. Then they compare those files using a diff tool (Examdiff in our case)

Re: Converting 4D Server v11 to v17

2019-10-10 Thread Tom Benedict via 4D_Tech
>v17 is 64 bit only on windows (I believe). On windows there are 32bit versions of v17 up through v17R4. v17R5 is the first 64bit only. >while v17 has a different architecture and is primarily object orientated, it >will still accept and interpret v11 style language. Is this truly the case?

Re: 4D Server Hosting - The Future ?

2019-10-10 Thread Tom Benedict via 4D_Tech
>BTW - when using a 'cloud' service, depending on your personal/business > > outlook you might want to think about who has access to your data, and > what are they doing with it. This applies not just to colo and 4D but > to everything in 'the cloud’. That’s why you encrypt your data.

Re: 4D Server Hosting - The Future ?

2019-10-10 Thread Tom Benedict via 4D_Tech
Indeed, that is the magic of VM and SAN. They can change the truck’s engine while its traveling down the road at 60mph. I was a skeptic until I saw it in action. Hot swapping of disks, memory, even ‘blades’ with CPUs on them happens transparently. Keep in mind, though, that this is not done to

Re: 4D Server Hosting - The Future ?

2019-10-10 Thread Tom Benedict via 4D_Tech
The key to getting good 4D performance out of VMs is dedicated resources. Once we got the VM ‘locked’ so it wouldn’t be ’smart’ about reallocating ‘idle’ resources (disk space, cache memory etc) to other VMs performance was very good. I don’t know much about VMs, but I’m surprised that you

Re: 4D Server Hosting - The Future ?

2019-10-10 Thread Tom Benedict via 4D_Tech
Hi Peter, Indeed, it is a brave new world, isn’t it? And like you said, it all happened transparently. At my last employer everything was virtualized. The SAN ‘guarenteed’ data uptime and redundancy. “Disks” (HDD or SSD) were ‘auto-healing’ and hardware failover was automatic. It is really

Re: v13+ SQL access other system

2019-10-09 Thread Tom Benedict via 4D_Tech
Hi Chip, The answer is yes to your three questions, but access to the table/fields schema will need to be granted to the user. Also, “automagically’ creating a matching 4D structure will require you write code, so it’s not very ‘magic’. ;) Extracting data should be straightforward. It’s just a

Re: post-icon conversion

2019-10-07 Thread Tom Benedict via 4D_Tech
Yes, Find in Design followed by Replace in Content will work to fix the references. Tom > On Oct 7, 2019, at 07:25, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I do not know that this will work... > try Find in design for the negative library reference > > it you find it -

Re: post-icon conversion

2019-10-07 Thread Tom Benedict via 4D_Tech
tructure in 32-bit, the buttons appear > normal. > > On Sat, Oct 5, 2019 at 10:46 PM Tom Benedict via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> Mike, >> >> Here’s the method I use to convert the Picture Library. I believe I got >> this from a 4D T

Re: post-icon conversion

2019-10-05 Thread Tom Benedict via 4D_Tech
Mike, Here’s the method I use to convert the Picture Library. I believe I got this from a 4D Tech Tip, but I’m not sure. It includes the call to TRANSFORM PICTURE to make the background transparent which Chuck mentioned. I don’t recall a red “Library” on the icons prior to running this method,

Re: mirror to production

2019-10-04 Thread Tom Benedict via 4D_Tech
>I could simply change DNS name and voila each client would connect seamlessly. >This code is for a large hospital and changing DNS names like this does not >seem to be in the cards. That what we did at the last place I worked. Alternatively, if your users are on Windows, you can push new

Re: Printing structures

2019-10-04 Thread Tom Benedict via 4D_Tech
See the methods listed below.. > i get that for normal human beings that don't have 24 or 36" rolls printing a > structure was not the greatest thing ever, but for us… May I point out that for those of us who don’t have plotters in our office, Staples (and I expect most other printing service

Re: Printing structures

2019-10-03 Thread Tom Benedict via 4D_Tech
Another possibility is to export an SQL Script which will can be imported into any number of data modeling tools (or even things like Visio). In the data modeling tool you can move stuff around and reformat as you wish. I have a method to generate a SQL Script if you are interested. Tom

Re: 4D ODBC, MS SQL and Alpha Fields

2019-10-03 Thread Tom Benedict via 4D_Tech
I second Chuck’s comment about 4D -> SQL Server via ODBC being much easier, stable etc than SQL Server -> 4D via ODBC. I know that probably doesn’t help, but if you have the option to change your architecture it would make life much easier. Tom Benedict > On Oct 3, 2019, at 10:22, Charles

Re: [repost - desperate]What runs before ON STARTUP?

2019-10-01 Thread Tom Benedict via 4D_Tech
I don’t know whether this has been mentioned yet, but have you run MSC on the component? Also, it’s a long shot, but have you deleted the .4DIndy file? I only mention that because I’ve seen it cause strange behavior. Tom Benedict > On Oct 1, 2019, at 07:16, Chip Scheide via 4D_Tech

Re: Converting PICTs to PNGs

2019-09-30 Thread Tom Benedict via 4D_Tech
Doug Hall writes: > I'm not sure if this is why, but now, even after running the script > uncompiled, I can only see some of my > converted images, and only from the compiled version. When I browse through > my Picture Library, almost all I see are those camera icons with the red > 'X' through

Re: REsource folder - Building a component or App

2019-09-27 Thread Tom Benedict via 4D_Tech
> On Sep 27, 2019, at 13:52, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I use the build dialog to setup and configure the initial build XML file and > do a build. After that I don’t use the build dialog. I have a method that I > run that does the BUILD APPLICATION and after

Re: Folder path issues

2019-09-26 Thread Tom Benedict via 4D_Tech
On Sep 26, 2019, at 08:32, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> wrote: > > >there are other software related issues keeping us from moving to an OS > >which is supported by (or supports) v17 >... > >there is other software that does not > >behave/like 10.13 that we need to be able

Custom Notepad++ Editor Style for 4D?

2019-09-25 Thread Tom Benedict via 4D_Tech
Does anyone have a custom User Defined Language for NotePad++ for 4D HTML pages? I’d like to have 4D Tags displayed as code rather than comments. Has anyone created such a thing? If not, maybe there are other editors which are preferred for creating and maintaining 4D web sites? Thanks, Tom

Re: v16 - Verify & Repair log files

2019-09-20 Thread Tom Benedict via 4D_Tech
On Sep 19, 2019, at 16:06, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I don’t know how critical those anomalies are. Some are cosmetic, but others, > like the scrollable area compatibility mode, might impact functionality. We > have over 3,000 to change,

Re: v16 - Verify & Repair log files

2019-09-19 Thread Tom Benedict via 4D_Tech
rted. Please convert them to shapes. >> 3D button style is not supported. >> >> There are likely more, but that’s all it flagged in our structure. >> >> More work for me... >> >> Tom Benedict >> >>> On Sep 19, 2019, at 14:34, Tom Benedict via

Re: v16 - Verify & Repair log files

2019-09-19 Thread Tom Benedict via 4D_Tech
structure. More work for me... Tom Benedict > On Sep 19, 2019, at 14:34, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I use NotePad++ which will generate a list of all the hits which is what > Miyako’s parsing script does. Miyako’s script is much easier. > >

Re: v16 - Verify & Repair log files

2019-09-19 Thread Tom Benedict via 4D_Tech
I use NotePad++ which will generate a list of all the hits which is what Miyako’s parsing script does. Miyako’s script is much easier. Tom > On Sep 19, 2019, at 14:03, Chip Scheide <4d_o...@pghrepository.org> wrote: > > it is not that I can not search - it is that I did not know what to >

Re: v16 - Verify & Repair log files

2019-09-19 Thread Tom Benedict via 4D_Tech
Browsing the log file manually is tedious, so I use a text editor to look for “warning” or “error”. That’s always been enough for me to find any outstanding “Anomalies”. If you’ve already done that there must be something else which is considered an anomaly. Sorry this isn’t very useful. Tom

Re: Apple Events Manager Process?

2019-09-16 Thread Tom Benedict via 4D_Tech
ot trigger any UI code (MESSAGE, for example). > > 2019/09/13 21:08、Tom Benedict via 4D_Tech > <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール: > From time to time I see an empty window named “Apple Events Manager” on 4D > Server. There is a process in

Re: SQL Connection to External SQL DB

2019-09-16 Thread Tom Benedict via 4D_Tech
Hi Ronnie, My suspicion is that something around SSL on the external DB has changed. Perhaps your app uses a version of 4D which supports TLS 1.0 and the external DB was changed to use TLS 1.2? Or maybe the other way around? Just a guess. Here’s 4D Tech Tip which can help determine what

Re: PHP and 64 bit readyness

2019-09-13 Thread Tom Benedict via 4D_Tech
I think there is a 64bit PHP… details on this and other 64bit updates at https://blog.4d.com/64-bit-support-brings-new-opportunities/ Tom Benedict > On Sep 13, 2019, at 13:56, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> >

Apple Events Manager Process?

2019-09-13 Thread Tom Benedict via 4D_Tech
From time to time I see an empty window named “Apple Events Manager” on 4D Server. There is a process in Runtime Explorer named “Apple Events Manager”. What is the purpose of this window/process? Thanks, Tom Benedict ** 4D

Re: [resolved?] PICTs as static pictures was: v15 - How to get an (form) object into a blob?

2019-09-11 Thread Tom Benedict via 4D_Tech
Chip, In case you encountered references to picture library images which have negative IDs, here is a link to some guidance from Mr Miyako on how to update them to positive IDs: http://4d.1045681.n5.nabble.com/Resource-Pictures-td5761195.html

4D Write Pro Programmable Margins?

2019-09-10 Thread Tom Benedict via 4D_Tech
I'm perplexed by the behavior of margins in Write Pro 17R4 and 17R5. If I display a Write Pro document in a form and set the margins under program control (i.e. in a button object method WP SET ATTRIBUTES(MyWPArea;wk page margin left;".75in")) the ruler will change, as expected, to show the

Re: v15 - How to get an (form) object into a blob?

2019-09-09 Thread Tom Benedict via 4D_Tech
Hi Chip, I may not completely understand your question, but one way you can tell if a static picture is still in PICT format is to open the form in 64 bit. If it’s still in PICT you’ll see it substituted by a red X. Tom Benedict > On Sep 9, 2019, at 15:29, Chip Scheide via 4D_Tech

Re: 4D authentication system that allow for stronger security.

2019-09-06 Thread Tom Benedict via 4D_Tech
Is there some news about Active Directory which I’ve missed lately? What weaknesses should I be concerned enough about to devote my efforts at "home brewing" something better? Thanks, Tom Benedict > On Sep 6, 2019, at 06:15, Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >

"automatically repaired method"

2019-09-05 Thread Tom Benedict via 4D_Tech
I just encountered an object method whose code was replaced with this comment: //automatically repaired method I’ve found the ‘missing’ code in a backup and reinstated it, but I’m wondering how/why did this happen? I looked through the MSC Repair Logs and found this error: Line 189517: Could

Re: 4d write to write pro conversion

2019-09-03 Thread Tom Benedict via 4D_Tech
On Sep 3, 2019, at 14:07, Charles Miller via 4D_Tech <4d_tech@lists.4d.com> wrote: > > >Hi All, > > > >we use 4D write extensively and have many issue trying to convert. > > > >For example, we need to know the total number of pages to be printed > >so that we can have page 1 of x etc on each

Re: Write Pro Stylesheet Support...

2019-08-28 Thread Tom Benedict via 4D_Tech
> Save the document as HTML. > Modify the CSS in the HTML. > Recreate the doc from the HTML > > HTH > Pat > > On Tue, 27 Aug 2019 at 18:39, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >> I am converting a massive code base from Write Cl

Write Pro Stylesheet Support...

2019-08-27 Thread Tom Benedict via 4D_Tech
I am converting a massive code base from Write Classic to Write Pro. I’m down to the final few dozen methods. A few of them have support for Write Classic stylesheets as in WR Create stylesheet, WR SET STYLESHEET FONT, WR SET STYLESHEET TEXT PROP etc. What is the recommended approach to doing

Write Pro Tab Stop Example...

2019-08-26 Thread Tom Benedict via 4D_Tech
I want to manage tabs under program control in 4D Write Pro. The documentation explains how to use WP SET ATTRIBUTES to set tabs and the command seems to work (I can verify that the tab offset was changed using WP GET ATTRIBUTES), but the change is not manifested in the Write Pro horizontal

Re: _ as first character in Method Name [was 64 bit...]

2019-08-19 Thread Tom Benedict via 4D_Tech
How about two underscores instead of a space? Tom > On Aug 19, 2019, at 08:38, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > related... > > I name project methods in 'modules', that is the first 3 - 7 characters > are the same. > i.e. animal_ > I also have a 'header method',

Re: 64 bit readiness report - some questions

2019-08-17 Thread Tom Benedict via 4D_Tech
ps://doc.4d.com/4Dv17R5/4D/17-R5/o-PLATFORM-PROPERTIES.301-4128805.en.html> Tom > On Aug 17, 2019, at 01:27, Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi Tom, > >> On 17 Aug 2019, at 09:29 AEST, Tom Benedict via 4D_Tech >> <4d_tech@lists

Re: 64 bit readiness report - some questions

2019-08-16 Thread Tom Benedict via 4D_Tech
Hi Chip, I’m going through this exercise too. See my comments on a couple of your questions below: > On Aug 16, 2019, at 16:17, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I do have a few questions which I expect someone here can answer... > > 2nd - obsolete commands (which

Read Only Mode for Structure Editor

2019-08-13 Thread Tom Benedict via 4D_Tech
Is there a read only mode for the 4D Structure Editor? I find it very easy to inadvertently change things while browsing or when moving tables around. I seem to recall it was possible to lock the editor in the past, but I may be dreaming. Tom Benedict

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

2019-08-08 Thread Tom Benedict via 4D_Tech
Hi John, I believe that 4D Server does a 1 minute countdown when downing while running as a service, so that should notify any connected users. At least that’s what it did when I tested NET STOP and NET START some years ago. I don’t know whether that also happens when downing Windows. I would

Re: Pasting problem

2019-08-07 Thread Tom Benedict via 4D_Tech
Are you sure there’s no form event being triggered somehow? Is the text area styled text? Is this universal in all objects on all forms or just in a few places? Tom Benedict > On Aug 7, 2019, at 10:51, William Swann via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi All, > > I am having a

Re: Mapping Write Classic Attributes to Write Pro. (Was "How to "Get" the State of 4D Write Pro Standard Actions?)

2019-08-06 Thread Tom Benedict via 4D_Tech
Whoops! I neglected to update the subject prior to posting. I will add another post regarding getting Standard Action values and how they are connected to attributes at a later date. Tom > On Aug 5, 2019, at 20:16, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> > wrote: > &g

How to "Get" the State of 4D Write Pro Standard Actions?

2019-08-05 Thread Tom Benedict via 4D_Tech
I am struggling with the new 4D Write Pro paradigm. One thing our Write Classic app has is a method which collects all the “Document Properties” into an array which we can use to manage the whole range of property/attributes for any given document or document editor. Given the fundamental

Re: 4D Write Pro Equivalent of wr modified?

2019-08-02 Thread Tom Benedict via 4D_Tech
Thanks for the confirmation David. Tom > On Aug 2, 2019, at 12:13, David Ringsmuth wrote: > > Tom, > > You’ll need to get the content of the 4D Write document and compare the old > to the new to know if it has been changed. > > David Ringsmuth > >

Re: No Object Auto-Completion for 4D Commands?

2019-08-02 Thread Tom Benedict via 4D_Tech
And Thomas Maul’s recent post on the forums regarding SCM with GIT from either Export structure files or Project format. https://forums.4d.com/Post/EN/30825681/1/3056#30825682 Export structure files is available in 17R3 and

4D Write Pro Equivalent of wr modified?

2019-08-02 Thread Tom Benedict via 4D_Tech
I want to know if a 4D Write Pro document has been modified. In 4D Write Classic the command is WR GET AREA PROPERTY(WriteArea;wr modified;$isModified) which does just that. Is there a similar 4D Write Pro attribute which can tell me this? I’ve dug around in the documentation but haven’t found

Re: Write Pro wk anchor layout attribute permanent when using wk behind text

2019-07-31 Thread Tom Benedict via 4D_Tech
> have you tried modifier+click? > > 2019/08/01 0:58、Tom Benedict via 4D_Tech > <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール: > Has anyone else experienced this? > ** 4D Inte

Write Pro wk anchor layout attribute permanent when using wk behind text

2019-07-31 Thread Tom Benedict via 4D_Tech
I have found that when inserting a picture into a 4DWrite Pro document to be “behind text” using: $image:=WP Add picture($WPObject;$imageRef) WP SET ATTRIBUTES($image;wk anchor layout;wk behind text) or when dragging and dropping inline with the text then changing

4D Write Pro Drag and Drop

2019-07-31 Thread Tom Benedict via 4D_Tech
I want to be able to drag a picture from the desktop and drop it onto a 4D Write Pro document and have the On Drop event trigger so I can prompt the user as to what layer (inline with text, anchored behind text or anchored in front of text) the picture should be placed. I’ve found that drag

Re: Resize Window and Move Code (RESOLVED)

2019-07-29 Thread Tom Benedict via 4D_Tech
On Jul 29, 2019, at 13:20, John J Foster via 4D_Tech <4d_tech@lists.4d.com> wrote: > And if you want a margin of air around each window that’s another > consideration. ^^ What an interesting term! I don’t think I’ve encountered it before now. I had to look

Re: SQL - renaming a field

2019-07-26 Thread Tom Benedict via 4D_Tech
Maybe 4D’s SQL implementation doesn’t support the RENAME keyword? I don’t see it in the docs.. https://doc.4d.com/4Dv16/4D/16/ALTER-TABLE.300-3201314.en.html Tom Benedict > On Jul 26, 2019, at 11:30, Chip Scheide via 4D_Tech

Re: Query by Formula Join vs. Comparison

2019-07-24 Thread Tom Benedict via 4D_Tech
Jim Medlen writes: > On Jul 24, 2019, at 13:28, Jim Medlen via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > I am trying to do a Query Selection By Formula that links two tables by the > filed ItemNum > with the condition that the value of a field in the first table does not > equal a value

Re: Static Pictures to Library Pictures

2019-07-24 Thread Tom Benedict via 4D_Tech
Chuck Miller responded to Ben Sokal’s post regarding moving Static Pictures to Library Pictures... > On Jun 4, 2019, at 17:06, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > If you had gone to one of 4D’s road shows, JPR had a db that would do this > for you. Perhaps you can

Re: Writting code to disk

2019-07-23 Thread Tom Benedict via 4D_Tech
If you are using 17 R3 or later, you can let 4D take care of that by using EXPORT STRUCTURE FILES. Tom Benedict > On Jul 23, 2019, at 10:52, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > When exporting 4D code does it matter in what way the text of the code > is written to

Re: How can I update a 4D record from SQL Server, over ODBC?

2019-07-15 Thread Tom Benedict via 4D_Tech
I tried this a number of years ago and was not successful. I don’t recall the details though. It may be a limit in the ODBC driver or SSMS. You can update records from other apps via ODBC though. Hopefully there will be other, more definitive, responses. Tom Benedict > On Jul 13, 2019, at

Re: 4D v17r4 Windows Print To PDF ignoring PAGE SETUP

2019-07-12 Thread Tom Benedict via 4D_Tech
Cam Ambrose wrote: >I’m trying to avoid making all those changes if there is another solution. >Still seems odd that >PAGE SETUP works for everything but the Windows 10 PDF Printer. Is there any >way of finding >out if it’s a known bug? … Are you aware of any 4D Blog entry or tech note >that

Re: Write Pro Print Preview...

2019-07-08 Thread Tom Benedict via 4D_Tech
I have discovered that Print Preview is not appearing because my code is running ‘inside’ of OPEN PRINTING JOB, which requires that all printer setup, including Print Preview, be done prior to calling OPEN PRINTING JOB. Tom > On Jul 7, 2019, at 15:09, Tom Benedict wrote: > > I’m trying to

Write Pro Print Preview...

2019-07-07 Thread Tom Benedict via 4D_Tech
I’m trying to get a reliable print preview support in 4D Write Pro. This blog posting https://blog.4d.com/4d-write-pro-wp-commands-and-beyond/ says: "So 4D’s printing commands also apply to 4D Write Pro, such as SET PRINT PREVIEW

Is there a Status Bar in 4DWrite Pro?

2019-07-03 Thread Tom Benedict via 4D_Tech
In 4DWrite Classic there a Status Bar at the bottom of the 4DWrite area. It includes current page number, total page count, current line number, current column (character) number and whether NumLock or CAPS Lock is on. It can be hidden or displayed by using WR SET DOC PROPERTY

Re: information needed using sql on a database called smsdb.dat

2019-07-01 Thread Tom Benedict via 4D_Tech
Hi Ernie, If you haven’t already, I would start by using Microsoft SQL Server Management Studio (SSMS) to access whatever details you can of the database. There may be documentation or ERD diagrams available there. SQ Query Analyzer, part of SSMS, is a great tool for writing queries. Get your

Re: R1Soft / Continuum / Continuous Data Protection - 4D compatibility?

2019-06-28 Thread Tom Benedict via 4D_Tech
In the past (before v17) I have experienced 4D Server crashing and corrupting issues associated with Volume Shadow Copy. The CDP concept is interesting and from the sounds of it I would guess that it shouldn’t cause a problem for 4D. However, I would not trust that backups of the .4DD would be

Re: Complex graph

2019-06-27 Thread Tom Benedict via 4D_Tech
Scott Staley wrote: > I'm not very familiar with View Pro or the tool it was developed from > (SpreadJS, a javascript spreadsheet API) but one thing that I see that > hasn't been talked about much is that it brings many if not most of the > charts/graphs that are available in excel to 4D. I

Re: v14+ find in design

2019-06-26 Thread Tom Benedict via 4D_Tech
Yes. At least they do in v17R4, which I just tested. I have a variable on a form where the expression is “Size of array(atMyArray)” and it showed up in Find in Design. I also tried it with an expression which calls a Project Method and it shows up too. Tom Benedict > On Jun 26, 2019, at

Re: Create Object Field Under Program Control?

2019-06-25 Thread Tom Benedict via 4D_Tech
> if the UUID matches. > > you might want to first test and confirm the behaviour with an existing DB. > >> 2019/06/25 23:57、Tom Benedict via 4D_Tech <4d_tech@lists.4d.com>のメール: >> Is there a way to add an object field to a table via 4D code? I went to

Re: Any 4D Write Pro Features Available Only in 64Bit?

2019-06-25 Thread Tom Benedict via 4D_Tech
>What 4DWrite Pro features, if any, are only available in 64bit? From what I’ve been able to determine the only 64bit specific limitation is that the WP PRINT command cannot be called within a 4D print job started with OPEN PRINTING JOB

Create Object Field Under Program Control?

2019-06-25 Thread Tom Benedict via 4D_Tech
Is there a way to add an object field to a table via 4D code? I went to create a SQL script to do this using ALTER TABLE but found in the documentation that object fields cannot be added via SQL. I have to add an object field to a number of tables in a number of databases, so it would be nice

4DWrite Pro <-> 4DWrite Classic Cross Reference

2019-06-24 Thread Tom Benedict via 4D_Tech
I’ve started a project to convert a large library of 4D Write Classic code to 4D Write Pro. I’ve read the various tech notes and blogs about 4DWrite Pro, along with the official 4D documentation, but I have a very hard time keeping track of it all. Some commands are now in the Styled Text

Any 4D Write Pro Features Available Only in 64Bit?

2019-06-19 Thread Tom Benedict via 4D_Tech
What 4DWrite Pro features, if any, are only available in 64bit? As part of an effort to move a large 4DWrite installation onto 4DWrite Pro I’d like to run as long as possible with Write Classic and Write Pro ‘side by side’. Since WriteClassic can only run under 32bit I won’t be able move to

4DWrite Pro Toolbar Widget Control

2019-06-19 Thread Tom Benedict via 4D_Tech
The 4DWrite Pro Toolbar in v17Rn is a welcome addition. I’m wondering what level of program control is available. The setup code which comes with the WritePro area when dropped onto a form from the Object Library mentions the ability to switch toolbars. “Toolbar1" and “Toolbar2” are mentioned.

Re: Backup and journal file configurations

2019-06-18 Thread Tom Benedict via 4D_Tech
I am very interested in increasing the level of support for automated testing in 4D. The larger and more complex the code base, the greater the testing burden. It has been my experience that the lack of automated test tool support in 4D is a roadblock to code refactoring. The cost of manual

Filter MSC Log File?

2019-06-18 Thread Tom Benedict via 4D_Tech
Is there a way to filter the log file that is generated by MSC? I want to only see the warnings or errors and filter out the rest. The log is hundreds of pages and scrolling through it looking for warnings is tedious. Thanks for any suggestion. Tom Benedict

Re: Conversion from v2003

2019-06-11 Thread Tom Benedict via 4D_Tech
> Luc Devar writes: > I am not too familiar with DDE_Tools. I am wondering if someone can point me > in a direction to help me have more information on that plugins and how to > replace it in V17. Maybe there is something similar out there now. A new > plugin, a component or tech note that

Re: Clients hang on Quit after server problem

2019-05-29 Thread Tom Benedict via 4D_Tech
On May 29, 2019, at 07:34, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> wrote: > > A customer recently suddenly started to have problems - they were unable to > quit their Clients (both Macs and PCs) - they Client would freeze when they > tried to Quit and they had to force quit. They were

Re: Benefits of 64-bit 4D Remote

2019-05-23 Thread Tom Benedict via 4D_Tech
Thanks to Arnaud, Jeff, Jody and Kirk for their confirmation that, while it’s important to plan for the 64-bit future, living in the 32-bit past continues to make sense in specific cases. This client has all Windows clients with a MacOS Server, which will be moving to Windows soon, so we’re

Benefits of 64-bit 4D Remote

2019-05-22 Thread Tom Benedict via 4D_Tech
I’m trying make a recommendation to a client as to whether they should move to 64-bit 4D Remote in v16.5 However, I’m not finding any compelling reasons. But I know it’s a very big thing for 4D, so I’m wondering whether I’m missing something? The documentation

Re: No Certification Matrix for v17.x?

2019-05-21 Thread Tom Benedict via 4D_Tech
Thanks for the confirmation Erick. > On May 21, 2019, at 13:59, ericklui678 via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi Tom, > > There is no longer a certification matrix for v17.x and newer as it is now a > systems requirements document which can be found in the link below: > >

No Certification Matrix for v17.x?

2019-05-21 Thread Tom Benedict via 4D_Tech
I’m searching 4d.com for the Certification Matrix for v17.x. I’ve found v16.x and previous versions, but not v17.x. Has it been combined with another document or am I overlooking it? Thanks, Tom Benedict ** 4D Internet Users

Re: Log integration issue in mirror database

2019-05-19 Thread Tom Benedict via 4D_Tech
> On May 19, 2019, at 07:33, Two Way Communications via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Windows server 2008 R2, 4D server v15.4 > > A customer has this mirror setup, where code in the mirror database > integrates log files coming from the master database. > > There are no data

Re: ShipWorks ODBC integration

2019-05-16 Thread Tom Benedict via 4D_Tech
Hi Clive, > On May 16, 2019, at 14:06, Clive Wilson via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Has anybody done a ShipWorks integration into 4D server. > > I’m trying to get it read & write using v17r4 & ODBC 64Bit. > It recognizes the server and a select works & downloads the whole

Re: Managing 4D Server as a service

2019-05-09 Thread Tom Benedict via 4D_Tech
On May 9, 2019, at 14:25, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> wrote: > > On May 9, 2019, at 2:00 PM, JOHN BAUGHMAN wrote: > >> 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 >>

AlwaysUp Utility to Run 4D Client as a Windows Service

2019-05-07 Thread Tom Benedict via 4D_Tech
I’ve seen a number of recommendations to use the AlwaysUp utility app to run 4D Client as a Windows Service. It looks to be very full featured and reasonably priced. The licensing scheme, however, binds the license to a specific machine. I haven’t looked into this further, but I’m wondering if

Re: Windows Server transition - Best Practice Advice

2019-05-06 Thread Tom Benedict via 4D_Tech
ired command line access to do this). >> >>> On May 6, 2019, at 1:45 PM, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> >>> wrote: >>> >>> Hi Ed, >>> >>>> We are beginning to transition our servers from Mac to Windows. For those

Re: Windows Server transition - Best Practice Advice

2019-05-06 Thread Tom Benedict via 4D_Tech
Hi Ed, >We are beginning to transition our servers from Mac to Windows. For those >of you who have made the journey, what have you found to be best practices >for a built c/s app running on Windows Server 2016 Standard? Are there any >gotcha's we should watch out for? Direct roads to smooth

Re: 4D World Tour - Seattle

2019-05-05 Thread Tom Benedict via 4D_Tech
John Foster wrote: >I am sending this knowing that there is only one more stop in San Jose. But if >you have any doubts about going please don’t. > >Take advantage of the first free day with a free lunch and fellow camaraderie. >And get teased about the content of the 2nd day. I second John’s

Re: Split Screen Support with 4D and MacOS?

2019-05-01 Thread Tom Benedict via 4D_Tech
te: > > You could use Exposé to put your code windows side by side. Or just drag > methods from one Explorer window to another. > >> On Apr 30, 2019, at 6:05 PM, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> Am I missing someth

Re: Split Screen Support with 4D and MacOS?

2019-05-01 Thread Tom Benedict via 4D_Tech
Thanks for the suggestions Chip. Yes, I’ve got Dani Beaubein’s Code Analysis component which I can use to export and compare. This particular situation is relatively small and I was hoping for a quick and simple solution. Tom > On May 1, 2019, at 06:45, Chip Scheide

Re: Split Screen Support with 4D and MacOS?

2019-04-30 Thread Tom Benedict via 4D_Tech
Thanks Chip, >- display the explorer in both > > - adjust the windows so you can see the column (list of methods/forms > whatever) in the destination. Drag and Drop between Explorer windows will work, but since I’m moving code between versions (15 to 16) I’m reluctant to replace whole methods

Split Screen Support with 4D and MacOS?

2019-04-30 Thread Tom Benedict via 4D_Tech
After 25 years of using 4D on Windows I have started using 4D on Mac. I am rather surprised at how many useful productivity features in Windows are extremely hard to accomplish on MacOS. I suspect it’s mostly a newbie thing. Right now I’m trying to copy/paste a lot of code edit from one 4D

Re: HTTP Get on 4D Server v15 - is it synchronous?

2019-04-30 Thread Tom Benedict via 4D_Tech
If you’re doing any significant volumes I would move the Web Server to one or more 4D Clients. That’s the best way to scale web services to avoid impacting 4D Server adversely. It will keep 4D Server doing what it does best. You’ll need to get a Web Services client license. Tom Benedict > On

Re: How to connect to a 4d ODBC server across a network

2019-04-17 Thread Tom Benedict via 4D_Tech
>Is it possible to create a UserDSN or SystemDSN that can find the server >located across the network?? My experience is a few years old, but you should be able to do this. The documentation which comes with the 4D ODBC driver (here’s the link for 4D ODBC Driver v17: 4D ODBC

Re: Best scripting language to use with LEP

2019-04-04 Thread Tom Benedict via 4D_Tech
Hi Pat, I believe that PowerShell is included in all versions of Windows: https://docs.microsoft.com/en-us/powershell/scripting/install/installing-windows-powershell?view=powershell-6 And I see that there is a version for MacOS too, but will need to be installed:

4D Developer Available

2019-04-03 Thread Tom Benedict via 4D_Tech
I have recently left my long time employer and begun free-lance 4D development work. I have 24+ years of experience scaling a 4D solution from a departmental application into a full enterprise system. During that time I have worn many hats, some simultaneously, including Business Analyst,

Re: Securing sensitive data in a 4D data file (Chip Scheide)

2019-04-01 Thread Tom Benedict via 4D_Tech
Chip, Just checking to confirm that the ultimate ‘owner’ of the data is indeed the individual user and if they are incapacitated or lose their key that is OK and ’their’ data is inaccessible forever. Or is there a need for a ‘master’ key? Tom Benedict > On Mar 31, 2019, at 21:54, Chip Scheide

<    1   2   3   >