Re: 4D Write Pro: License or privilege error

2019-05-21 Thread Pat Bensky via 4D_Tech
Maybe try using VirtualBox instead of Parallels ... that's what I use and have not had any issues like that. And it's free :) PB On Tue, 21 May 2019 at 19:13, John J Foster via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi All, > > Tim recommended that I contact 4D TS - which I did. It turns out

4D View - create spans?

2019-05-21 Thread Pat Bensky via 4D_Tech
I can see how to create cell spans via the user interface, when the toolbar is displayed ("merge and center" button) but does anybody know how to do it via code? --Pat * CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118 7889 w:

Re: 4D Write Pro (where is list of reserved attributes?)

2019-05-17 Thread Pat Bensky via 4D_Tech
Probably what's on this list: https://doc.4d.com/4Dv17R4/4D/17-R4/4D-Write-Pro-Attributes.300-403.en.html PB On Fri, 17 May 2019 at 14:25, Jeremy French via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Can I change a 4D Write Pro table’s id attribute to some custom value? > > A recent 4D Tech

Re: 4D Write Pro: License or privilege error

2019-05-15 Thread Pat Bensky via 4D_Tech
John, Do you have the old 4DWrite plugin installed? If so, try removing that, restart 4D, and see if it makes any difference. PB On Wed, 15 May 2019 at 16:20, John J Foster via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Doug, > > The License manager clearly shows 4D Developer Professional v17

Re: v17R4 infelicities

2019-05-15 Thread Pat Bensky via 4D_Tech
The issue with the design windows all closing was fixed in one R version but it seems to have reappeared. I'm on R5 and it SOMETIMES (randomly) does this. I've submitted a bug report (99591). PB On Wed, 15 May 2019 at 08:37, Jeremy Roussak via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Miyako, > >

4D World Tour ... Way more than your moneysworth

2019-05-14 Thread Pat Bensky via 4D_Tech
My head is buzzing with ideas and information following the World Tour training day with JPR in sunny London. If you are serious about your work and it isn't too late for you, you need to go! OH BUT IT COSTS MONEY Yes, it does cost a little. Probably somewhat less than you charge for a day's

Re: 4D Write Pro: License or privilege error

2019-05-14 Thread Pat Bensky via 4D_Tech
John, Has $blob been defined? Do you get the error if you call: $wpDoc:=WP New ? PB On Tue, 14 May 2019 at 22:01, John J Foster via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi All, > > Tried: Partner (silver) versions of 4D v17R4, R5 and v17.1 Windows and > Macintosh Stand alone and 4D

Re: Webarea Embedded rendering engine show blank pages in 64-bit

2019-05-07 Thread Pat Bensky via 4D_Tech
Piotr, I have noticed the same problem. I guess it needs to be reported as a bug :) Pat On Tue, 7 May 2019 at 18:21, Piotr Chabot Stadhouders via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi, > > Tested on Windows > > In 4Dv17R4 32-bit I have some html pages that are shown in a Webarea > Because

Re: WA SET PAGE CONTENT - doesn't work first time

2019-05-04 Thread Pat Bensky via 4D_Tech
NTENT(*;$objName_webArea_t;"";"file:///") > > > > // now the web area has been initialized > > > > End case > > - > > > > Best regards, > > Jeremy > > > > > > > >> On May 4, 2019,

WA SET PAGE CONTENT - doesn't work first time

2019-05-04 Thread Pat Bensky via 4D_Tech
On Page 7 of a form there is a web area which displays information and help about the selected table. When this page is selected, a text variable is filled with html and displayed in the web area with: WA SET PAGE CONTENT(WebAreaHelp;$HTML;"file:///") After a new window has been opened, this

Re: How to set the font colour for rows in an array-based listbox?

2019-05-01 Thread Pat Bensky via 4D_Tech
That applies to the background colour, not the text colour ): On Wed, 1 May 2019 at 11:32, Jeremy Roussak via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Pat, > > LISTBOX SET ROW COLOR? > > Jeremy > > > > On 1 May 2019, at 09:58, Pat Bensky via 4D_Tech <4d_tech@

How to set the font colour for rows in an array-based listbox?

2019-05-01 Thread Pat Bensky via 4D_Tech
I can find plenty of info about setting the row font colour for a selection-based listbox, but how do we do it for an array-based listbox? Pat -- * CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype:

Re: Code signing works on one app but fails on another

2019-04-24 Thread Pat Bensky via 4D_Tech
that signing worked properly: > > spctl -av "$appPath" > codesign --verify -v "$appPath" > > Also, I launch the app before signing to choose the datafile and update > the Info.plist with a more descriptive version string. > > Jim Crate > > > On

Re: Code signing works on one app but fails on another

2019-04-24 Thread Pat Bensky via 4D_Tech
lid instruction (single hyphen+long option >> name). >> >> I've posted a utility to ease the process of signing >> >> https://github.com/miyako/4d-utility-build-application >> >> it is written in v17 but the target app path can be any path. >> >> 2

Re: Double Clickable app where should plugins be?

2019-04-18 Thread Pat Bensky via 4D_Tech
Yes - inside the Contents folder. BTW you can get a list of all installed plugins: *ARRAY LONGINT*(lPluginNumbers;0) *ARRAY TEXT*(atPlugInNames;0) *PLUGIN LIST*(lPluginNumbers;atPlugInNames) Pat On Thu, 18 Apr 2019 at 19:25, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> wrote: > I have

Re: trying to Build double clickable app

2019-04-17 Thread Pat Bensky via 4D_Tech
Chip, You should have two licences selected in the Licences tab: - 4D Developer Porofessional - 4D Unlimited Desktop PB On Wed, 17 Apr 2019 at 20:21, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> wrote: > yes I located the Volume desktop app. > > and Chcuck, > getting the license installed is

Re: I really recommend the 4D World Tour

2019-04-10 Thread Pat Bensky via 4D_Tech
Thanks for that Kirk. I found your ORDA comments interesting. I'll be at the London event. Pat On Wed, 10 Apr 2019 at 15:00, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> wrote: > Heading home from the WT in Atlanta. For me this was the best WT so far and > I've been to them all. I think anyone

Re: LEP - hide console?

2019-04-09 Thread Pat Bensky via 4D_Tech
ut PowerShell windows. > > > https://doc.4d.com/4Dv15/4D/15.6/SET-ENVIRONMENT-VARIABLE.301-3817570.en.html > > Jeff > > > > On Apr 9, 2019, at 5:34 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > > So I now have a Powershell script whic

LEP - hide console?

2019-04-09 Thread Pat Bensky via 4D_Tech
So I now have a Powershell script which converts a Word document to PDF. Unfortunately it briefly shows the Powershell console window when it starts the script, which is rather ugly and I would prefer not to inflict it upon my users. Is there any way to prevent it from appearing? Here's my LEP

Re: Best scripting language to use with LEP (docx to PDF)

2019-04-07 Thread Pat Bensky via 4D_Tech
y folder > > in 4D code > > $path:=Temporary folder+"com.microsoft.Excel"+Folder separator > > this would be for CFBundleShortVersionString > 14 i.e. Office 2016 or > later. > > c.f. > > https://github.com/miyako/4d-plugin-office-document-converter &

Re: Best scripting language to use with LEP (docx to PDF)

2019-04-06 Thread Pat Bensky via 4D_Tech
Miyako, > > but my understanding is that > Word on Windows embeds hyperlinks when exporting to PDF, > whereas Word on Mac doesn't (same with any app that performs print-to-pdf > using the system feature) > If you use the Save As ... option in Word to create the PDF, it preserves the hyperlinks.

Re: Best scripting language to use with LEP (docx to PDF)

2019-04-05 Thread Pat Bensky via 4D_Tech
An easy way to create Word files is: - create a file in XML format - Change the file extension from xml to docx Voila! AS long as your XML is well-formed and conforms to the Open XML standard, it works a treat. Seee https://en.wikipedia.org/wiki/Office_Open_XML On Fri, 5 Apr 2019 at 12:32,

Re: Printing to PDF (again)

2019-04-05 Thread Pat Bensky via 4D_Tech
Oh right ... I'll have a look at that, thanks! Pat On Fri, 5 Apr 2019 at 11:41, Julio Carneiro via 4D_Tech < 4d_tech@lists.4d.com> wrote: > There’s another one there QPDF, have you looked at it? > > > On Apr 5, 2019, at 7:39 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com

Re: Best scripting language to use with LEP (docx to PDF)

2019-04-05 Thread Pat Bensky via 4D_Tech
Good questions Lutz :) I'd like to think that it will work when running as a service as long as a) it runs silently and b) Word is installed on the server. But that is certainly something that will need to be tested. I am trying to find a solution that is very simple for users of all technical

Re: Printing to PDF (again)

2019-04-05 Thread Pat Bensky via 4D_Tech
tform and might do the trick. > What you want cannot be achieved with any print to pdf solution. You need > a plugin that helps create, or manipulate, pdf documents. > > I’ve Myako also has something on the area, you might check with him. > > hth > julio > > > On Apr 4, 2019, a

Best scripting language to use with LEP

2019-04-04 Thread Pat Bensky via 4D_Tech
I'm looking into getting some custom scripts created to solve my output-to-PDF problems. Mac I think I can do what's needed with AppleScript. Windows Any suggestions as to which language would be best? PERL? Java? We need to be able to run the script via LEP. We would pass a .docx file pathname

Re: Printing to PDF (again)

2019-04-04 Thread Pat Bensky via 4D_Tech
Thanks Armin ... it's Windows only unfortunately. I need a cross-platform solution. Even if it means two separate solutions :) Pat On Thu, 4 Apr 2019 at 20:22, ADeeg via 4D_Tech <4d_tech@lists.4d.com> wrote: > 4D Tech mailing list wrote > > Does anybody know of any way to manage the options for

Re: Creating Word docs in 4D

2019-04-04 Thread Pat Bensky via 4D_Tech
David, Are you a 4D Partner? On Thu, 4 Apr 2019 at 19:45, David Rose via 4D_Tech <4d_tech@lists.4d.com> wrote: > I found another solution, pending some testing. (This is in a Windows > environment, btw.) > Print the Write Pro document to a PDF file (in my case, using Microsoft > Print to PDF),

Printing to PDF (again)

2019-04-04 Thread Pat Bensky via 4D_Tech
Does anybody know of any way to manage the options for printing to PDF? Specifically, for example: - Specify the resolution - Make hyperlinks active ? Pat -- * CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118 7889 w:

Re: Code signing works on one app but fails on another

2019-04-04 Thread Pat Bensky via 4D_Tech
ed a utility to ease the process of signing > > https://github.com/miyako/4d-utility-build-application > > it is written in v17 but the target app path can be any path. > > 2019/04/03 8:05、Pat Bensky via 4D_Tech <4d_tech@lists.4d.com 4d_tech@lists.4d.com>>のメール: > —force:

Re: Code signing works on one app but fails on another

2019-04-02 Thread Pat Bensky via 4D_Tech
cannot. You need to put an escape character in front > of the space (back slash or forward slash not sure at the moment). > > Jody > > > On Apr 2, 2019, at 3:47 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > > Hi Jeremy, > > I've tri

Re: Code signing works on one app but fails on another

2019-04-02 Thread Pat Bensky via 4D_Tech
rce”? In your email, it seems to be an > em-dash. I suspect it should be a double-hyphen. The same will apply to the > character before “deep”. > > Jeremy > > > On 2 Apr 2019, at 19:05, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > > Hi Jody

Re: Code signing works on one app but fails on another

2019-04-02 Thread Pat Bensky via 4D_Tech
. If this works, > make this your new development version. Subject to adding any new files > into the .4dbase it should compile, build and sign using the 4D tool. > > Jody > > > On Mar 21, 2019, at 5:52 AM, Pat Bensky via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >

Setting background colour for ListBox header buttons

2019-03-30 Thread Pat Bensky via 4D_Tech
Using v17: I want to set the background colours of listbox headers according to what type of data is in the column. So if it's the key field, for example, I want black text on a green background. Otherwise, I want yellow text on a red background. Here's my code: *Case of* *:* ($isKey)

SOLVED: Can't run as a service on Windows 2016 (or later)

2019-03-29 Thread Pat Bensky via 4D_Tech
Thanks to 4D tech support for helping us to figure this out. The solution is that the service must be started using the same login credentials as you used to log in to the server. Although this was pointed out to me earlier, I could not get it to work because I didn't realise that the logged-in

Re: Can'r run as a service on Windows 2016

2019-03-25 Thread Pat Bensky via 4D_Tech
Thanks Paul. In the Users and Groups control panel I only see Local Users and Groups. But we've been told NOT to use a local user account ... Pat On Mon, 25 Mar 2019 at 10:07, Paul Dennis via 4D_Tech <4d_tech@lists.4d.com> wrote: > I dont have access to server 2016 so cant be sure but my guess

Re: Can'r run as a service on Windows 2016

2019-03-24 Thread Pat Bensky via 4D_Tech
Hi peeps, I am still having no luck with this :) Would anybody be willing to do a screen-share with me to help me figure this out? I'm happy to pay for your time! Getting a bit desperate here ... Pat On Thu, 28 Feb 2019 at 20:07, Stephen J. Orth via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I

Re: Code signing works on one app but fails on another

2019-03-21 Thread Pat Bensky via 4D_Tech
ng any new files > into the .4dbase it should compile, build and sign using the 4D tool. > > Jody > > > On Mar 21, 2019, at 5:52 AM, Pat Bensky via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Using v17 > > I've added our Apple OSX signing certif

Code signing works on one app but fails on another

2019-03-21 Thread Pat Bensky via 4D_Tech
Using v17 I've added our Apple OSX signing certificate to a client's app built with 4D v17. It compiles and runs just fine. I've added the same certificate to another app, using the same version of 4D and the same compiler settings. However with this one, at the end of compilation, I get the

Re: $D V17 as a service

2019-03-18 Thread Pat Bensky via 4D_Tech
I have been banging my head against the wall with this problem for weeks :) Advice I was given was to NOT run the service with the Local system Access option selected but to create a new user account and use that. I got the client's IT dept. to create a new user account and it is selected under

Write Pro: Styling tables

2019-03-17 Thread Pat Bensky via 4D_Tech
Using v17r4. I'm finding it "challenging" to add styling to tables in a WP document. *Problem no. 1: Attributes are applied to the wrong row* Here is some simple sample code: $rows:=*WP Get elements*(wptable;wk type table row) $n:=$rows.length // $n = 3 $row:=$rows[1] *WP SET

Re: 4D and Mongo

2019-03-07 Thread Pat Bensky via 4D_Tech
Thanks Chuck and Tom! On Thu, 7 Mar 2019 at 20:34, Tom DeMeo via 4D_Tech <4d_tech@lists.4d.com> wrote: > Hi, > > > I’ve worked on a web site that does quite a bit of this. A MongoDB is > typically part of an Apache/PHP based web site configuration which would > already have a PHP Mongo module in

4D and Mongo

2019-03-07 Thread Pat Bensky via 4D_Tech
Had a request from a client wanting to know if our 4D app can integrate with their Mongo data. Can it? -- * CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky

Re: Crash on startup, v17.1 merged app

2019-02-28 Thread Pat Bensky via 4D_Tech
grammer and Customer Support > > http://printpoint.com <http://printpoint.com/> • 845.687.3741 • > PrintPoint, Inc • 57 Ludlow Lane • Palisades, NY 10964 > Please send all email contacts to supp...@printpoint.com supp...@printpoint.com> > > > > > > > On Feb 28, 2

Crash on startup, v17.1 merged app

2019-02-28 Thread Pat Bensky via 4D_Tech
Running a compiled & merged single-user app v17.1 on a customer's Mac (OS v. 10.12.6), the app crashes soon after startup - before it has asked for a data file. Of course, it runs OK on any other Mac we try it on :) If I hold down the Alt key as it's starting up, it never gets to the open options

Re: Can'r run as a service on Windows 2016

2019-02-27 Thread Pat Bensky via 4D_Tech
> You've got TCP 19812-19814 ports open in Advanced Windows Firewall > inbound rules. > > Yes? > > > > Randy Engle > > > > -Original Message- > > From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Pat Bensky > via 4D_Tech > > Sent:

Re: Can'r run as a service on Windows 2016

2019-02-27 Thread Pat Bensky via 4D_Tech
ars ago which mentions having to “Run > as Administrator” > > > > https://kb.4d.com/assetid=75056 > > > > HTH, > > > > Tom Benedict > > > >> On Feb 27, 2019, at 02:40, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >> >

Can'r run as a service on Windows 2016

2019-02-27 Thread Pat Bensky via 4D_Tech
I'm having a bit of trouble trying to set up our 4D app to run as a service on a Windows server. The server version is Windows Server 2016 Standard. If I run the app "As Administrator" it starts up OK and we can connect to it. If I don't start it as Administrator, I get a message that the

Re: Replacing FootRunner in v16

2019-02-23 Thread Pat Bensky via 4D_Tech
Peter, Here's a method that creates a script. You simply: a) Write your 4D method that you want to run in a script b) Select it all and copy it. c) Run the ScriptCreator method. // ScriptCreator //Create an executable script // The script contents must first be copied to the pasteboard

Re: Three-dimensional arrays?

2019-02-04 Thread Pat Bensky via 4D_Tech
gt; Using arrays is the same idea but you get into pointers and multiple 2D > arrays. Complicated. Collections are easy. > > On Mon, Feb 4, 2019 at 7:22 AM Pat Bensky via 4D_Tech < > 4d_tech@lists.4d.com> > wrote: > > > Here's a nice little question to ponder for a Monday mo

Three-dimensional arrays?

2019-02-04 Thread Pat Bensky via 4D_Tech
Here's a nice little question to ponder for a Monday morning ... Let's say we have a 2-D array that represents the cells in a spreadsheet - eg a2tCellContents{10}{10}) 10 rows x 10 columns. Simples. Now, we want to add another layer to this. Maybe for the individual sheets in a spreadsheet. So

Re: Does 4D 64-bit Volume desktop use more than 1 core?

2019-01-30 Thread Pat Bensky via 4D_Tech
Piotr I believe the "bitness" has more to do with how it uses RAM than cores. Pat On Wed, 30 Jan 2019 at 09:13, Piotr Chabot Stadhouders via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi all, > > First of all, I must say I am no hardware expert, so maybe this is a > stupid question. > > It seems

Sort messes up Listbox selection when in a transaction

2019-01-23 Thread Pat Bensky via 4D_Tech
Using v17r3, Mac: I have a listbox that displays a selection of records from the [ListItems] table, which are related to a record in the [Lists] table. User can select an item in the list and click the Delete button to delete a [ListItem] record. The code that runs: *USE SET*("ListboxSet0")

Re: Making sense of a crash report

2019-01-18 Thread Pat Bensky via 4D_Tech
the app appears to be in a system > folder... > > Shouldn't this say, Path: /Applications/Catbase8.app? > > hth > > On 1/18/19, 5:23 AM, "4D_Tech on behalf of Pat Bensky via 4D_Tech" < > 4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote: > > Path

Making sense of a crash report

2019-01-18 Thread Pat Bensky via 4D_Tech
Anybody have any idea how I can figure out what caused a crash? Our app crashes as soon as the user tries to run it. It's a single-user merged app using v17r3 on Mac OS v10.13.6 - exactly the same OS as I'm using. Of course, it runs without problem on mine. Here's the first part of the crash

Re: Tracking Field Data Changes

2019-01-15 Thread Pat Bensky via 4D_Tech
Ronnie, We have an Audit Trail Manager that does exactly that. Example database attached. Pat On Tue, 15 Jan 2019 at 09:29, Ronnie Teo via 4D_Tech <4d_tech@lists.4d.com> wrote: > Hi, > > I have a client running a 4D application for about 50+ users. > A recent audit has thrown up a request to be

Re: 4D Write Pro license question

2019-01-13 Thread Pat Bensky via 4D_Tech
s are required in a > database that would make specific use of Write Pro. I understand about > setting group access to plugins. That's not how I want to manage this, > though. > > On Sun, Jan 13, 2019 at 8:09 AM Pat Bensky via 4D_Tech < > 4d_tech@lists.4d.com> > wrote: &g

Re: 4D Write Pro license question

2019-01-13 Thread Pat Bensky via 4D_Tech
Hmmm Rudy, I would suggest that if the server (or any stored process) needed to use a WP licence, even for a second, then you WOULD need to reserver a licence for it. Otherwise you would easily run into a situation where all available licences have been used by connected users, and then it

Re: v13- Chasing Relations

2019-01-09 Thread Pat Bensky via 4D_Tech
Chip, I think you would have to - Iterate through all the tables and all their fields - Build a map of all the relations (maybe a simple pair of arrays for the parent and child table numbers) with GET RELATION PROPERTIES - then you'll easily be able to check the map to find out what's related to

Re: Pasting Spreadsheet Data into 4D Records

2018-12-23 Thread Pat Bensky via 4D_Tech
You're going to have to either save it as a text file (csv or tab-delimited) and then parse it, or use a plugin (such as Pluggers' XL Plugin) to read the spreadsheet directly. Pat On Mon, 24 Dec 2018 at 00:48, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com> wrote: > Greetings everyone, > > Is

Applying attributes to a WritePro table cell

2018-12-23 Thread Pat Bensky via 4D_Tech
I want to insert text and apply formatting to individual cells in a WP table. Here's my test code: $WPRange:=WP Create range(wpTablePreview;wk start text;wk end text) $WPTable:=WP Insert table($WPRange;wk replace;wk include in range;2;1) $cell:=WP Table get cells($WPTable;1;1) // column

Appearance of Tab Control objects

2018-12-17 Thread Pat Bensky via 4D_Tech
Using v17 - Is there any way to control the appearance of tab control objects? I have 3 tab controls on a form and I'd like to differentiate them by maybe giving them a background colour or setting the font in a different colour. The only options seem to be the font style. I tried using *OBJECT

Re: Managing different indexes for different databases

2018-12-15 Thread Pat Bensky via 4D_Tech
n the FieldMap settings? If so, if the Designer > logged in would skipping the code that turns off these indexes allow a > developer to work without it reindexing? Or, similarly, if a file called > "Don't Reindex!" exists on the development machine, don't reset the indexes? > > > >

Re: Coding/Development Style Guide?

2018-12-14 Thread Pat Bensky via 4D_Tech
We have a family simple but effective set of rules for naming variables. It's easy to follow and easy for anybody to know immediately what type of variable it is: Variable Naming Conventions Begin each variable name with a character to specify what type it is: · String: s · Text: t ·

Managing different indexes for different databases

2018-12-14 Thread Pat Bensky via 4D_Tech
In our app (CatBase) each customer can manage their own tables and fields and one of the things they can do is specify whether a particular field is indexed. Since these indexes are different for each customer, when they get a program update from us, the indexes have to be recreated and built

Re: Publishing a DB on the WWW. Howto.

2018-12-05 Thread Pat Bensky via 4D_Tech
Thanks Tim. Actually we do already use Wix for our website (catbase.com) and one other, but haven't tried the database integration tools yet. Yes there are some limitations, but we've found workarounds for everything we needed to do so far. For example, we wanted to embed videos from Wistia

Re: Publishing a DB on the WWW. Howto.

2018-12-04 Thread Pat Bensky via 4D_Tech
We've been looking into ways to make it easy for our customers to build custom websites using data from our 4D app (CatBase). I'm quite interested in the Wix solution but haven't had time to properly look into it. Anybody tried this? Basically, you can create a database on your Wix website and

Re: Mojave

2018-11-30 Thread Pat Bensky via 4D_Tech
I am likewise curious about this ... and what about v13? We still have some customers on that version. Will we need to maintain separate machines with different versions of the OS installed? On Fri, 30 Nov 2018 at 14:18, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> wrote: > I don’t believe 4D

Re: Anybody running v17 server on Windows 2008r2?

2018-11-29 Thread Pat Bensky via 4D_Tech
• Palisades, NY 10964 > Please send all email contacts to supp...@printpoint.com supp...@printpoint.com> > > > > > > > On Nov 29, 2018, at 9:00 AM, Pat Bensky via 4D_Tech < > 4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>> wrote: > > > > And

Anybody running v17 server on Windows 2008r2?

2018-11-29 Thread Pat Bensky via 4D_Tech
And if so, do you have any problems with it? Thanks Pat -- * CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky *

Re: "Failed to create WIC imaging factory"

2018-11-28 Thread Pat Bensky via 4D_Tech
ems in Windows seem to always come back to this. > > > > On Nov 28, 2018, at 9:12 AM, Pat Bensky via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Our customer is running on Windows 2008r2. We are compiling on Windows 10 > > using 4D v17r3. > > When he tries

"Failed to create WIC imaging factory"

2018-11-28 Thread Pat Bensky via 4D_Tech
Our customer is running on Windows 2008r2. We are compiling on Windows 10 using 4D v17r3. When he tries to run our compiled & merged 4D Server, he gets the error: Failed to create WIC Imaging Factory -2147221164 I've researched this online but haven't found any helpful info. Anybody run into

Re: Using Preg Replace to replace tags

2018-11-24 Thread Pat Bensky via 4D_Tech
lease ." $Srchstring:="([^<]*)" $replacestring:="<@bold:>\\1<@:>" $err:=*Rgx_SubstituteText* ($Srchstring;$replacestring;->$source) Pat On Sun, 25 Nov 2018 at 03:34, Jim Crate via 4D_Tech <4d_tech@lists.4d.com> wrote: > On Nov 24, 2018,

Using Preg Replace to replace tags

2018-11-24 Thread Pat Bensky via 4D_Tech
I'm attempting to use the Regex Plugin from Pluggers to replace tags with different tags. For example, change this text: Some text.Set this text in bold please . to Some text.<@bold:>Set this text in bold please .<@:> In other words, there' a starting and ending tag with any kind if text in

Re: Format of MySql data file

2018-11-16 Thread Pat Bensky via 4D_Tech
Hi Paul, Yup - that's exactly what I was actually trying to do. But I can't import the whole file in one go - it crashes - so I was hoping to break it up into more manageable sections and import them one at a time. Maybe there is some corruption in the file but I can't find where it is if I can't

Re: Format of MySql data file

2018-11-16 Thread Pat Bensky via 4D_Tech
Hi John, I've tried opening the document with Document to Text, Receive Packet, and Blob to Text. They all yield the same result. Pat On Fri, 16 Nov 2018 at 02:03, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> wrote: > Pat, > > > > > On Nov 15, 2018, at 5:18 PM

Format of MySql data file

2018-11-15 Thread Pat Bensky via 4D_Tech
I've been given a pretty big MySql data dump file (943 Mb) to migrate to our 4D db. There are lots of tables, many of which I think are not needed for our purposes. I want to break this file down into individual files for each table, to make it more manageable. So I created a method to parse the

4Dv17 + Windows 10 + VirtualBox

2018-11-12 Thread Pat Bensky via 4D_Tech
Anybody else using this configuration? I find that it works OK - although rather slowly - with one exception: When I compile a multi-user app, if I include the automatic client updating options for Windows and Mac, it does not compile the Client app. I get an error message "Cannot install the

INVOKE ACTION only works when I trace through it

2018-11-11 Thread Pat Bensky via 4D_Tech
Using v17, Mac I have an enterable field on a form. The user can right-click on it and select an action such as "Select a picture" from a dynamic popup menu. The code that runs: tEditText:="" *PicturePathSelect* (->tEditText) // choose a pic, copy pathname to tEditText *SET TEXT TO

Re: How to get a list of all user windows?

2018-11-08 Thread Pat Bensky via 4D_Tech
sses belong to the design process. > > John DeSoi, Ph.D. > > > > On Nov 8, 2018, at 1:46 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > > The WINDOW LIST function creates a list of ALL open windows, including > > method windows.

How to get a list of all user windows?

2018-11-08 Thread Pat Bensky via 4D_Tech
The WINDOW LIST function creates a list of ALL open windows, including method windows. Is there any way to get a list of only the user windows? (IE, ones that are open in the runtime environment). -- * CatBase - Top Dog in Data Publishing tel: +44

Re: 4d write pro

2018-10-30 Thread Pat Bensky via 4D_Tech
Chuck, Try this ... First create a Range object that contains the whole document. Then save it as a BLoB with VARIABLE TO BLOB I did a quick test and it seems to work: *C_BLOB*($blob) *C_OBJECT*($range;$range2) $range:=*WP Create range*(PtrWriteProArea->;wk start text;wk end text) *VARIABLE

Re: Shared Object - NOT!

2018-10-20 Thread Pat Bensky via 4D_Tech
gt; > On 20 Oct 2018, at 15:50, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > > Well I guess I must be doing something wrong :) > > Using v17r3: > > > > In the Startup method I create a new Shared Object: > > > > *C_OB

Shared Object - NOT!

2018-10-20 Thread Pat Bensky via 4D_Tech
Well I guess I must be doing something wrong :) Using v17r3: In the Startup method I create a new Shared Object: *C_OBJECT*($objTriggerState) // 20/10/18 $objTriggerState:=*New shared object*() Subsequently I want to add something to that object. $State:="on" *Use* ($objTriggerState)

Re: [off] Windows installer recommendation

2018-10-20 Thread Pat Bensky via 4D_Tech
Inno Setup. Been using it for years. Works great and very configurable. And free :) On Sat, 20 Oct 2018 at 13:23, Jeremy Roussak via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I have been inveigled into making a Windows version of a Mac 4D > application. I have no experience of Windows

Re: v13 - Why would a query fail to change current reocrd?

2018-10-16 Thread Pat Bensky via 4D_Tech
Chip, You haven't got a SET QUERY DESTINATION somewhere have you? Pat On Mon, 15 Oct 2018 at 23:24, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> wrote: > Background > - I use 2 tables to manage listboxes. > - I am on an entry form, which includes a selection listbox. > - I am trying to

Re: how do I turn it into a component or a database

2018-10-16 Thread Pat Bensky via 4D_Tech
Axel, See: http://doc.4d.com/4Dv17R3/4D/17-R3/Compiled-structure-page.300-3961299.en.html On Tue, 16 Oct 2018 at 00:06, Axel Kohlepp via 4D_Tech <4d_tech@lists.4d.com> wrote: > Hello, > > I found the following things: > > https://github.com/ThomasMaul/UserMode_Component > >

Resetting the table sequence number

2018-10-15 Thread Pat Bensky via 4D_Tech
I have a method that creates record numbers using the Sequence number. I'm running into a situation where I am getting duplicate record numbers for some reason. So I added some code to check and - supposedly - fix it by resetting the table sequence number, but it doesn't seem to work. This is

Re: EAN8 barcode with Zint plugin

2018-10-15 Thread Pat Bensky via 4D_Tech
udes EAN8 but I am not sure. > > technically there should be no need to differentiate 8 from 13. > > https://en.wikipedia.org/wiki/International_Article_Number > > 2018/10/15 23:52、Pat Bensky via 4D_Tech <4d_tech@lists.4d.com 4d_tech@lists.4d.

Re: EAN8 barcode with Zint plugin

2018-10-15 Thread Pat Bensky via 4D_Tech
Seems to be the same. On Mon, 15 Oct 2018 at 15:56, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> wrote: > Does this list of IDs and codes look like it matches Miyako's plug-in? > > http://www.zint.org.uk/Manual.aspx?type=p=4 > >

EAN8 barcode with Zint plugin

2018-10-15 Thread Pat Bensky via 4D_Tech
Using Miyako's Zint plugin, I need to create a barcode in EAN8 format. There's a list of supported formats on the Github page: https://github.com/miyako/4d-plugin-zint But EAN8 isn't listed. On the ZInt website it says that EAN8 is supported. I need to know what the id number for EAN8 is. Can't

Re: Elementary question

2018-10-13 Thread Pat Bensky via 4D_Tech
Is it an in-house solution or deployed? PB On Sat, 13 Oct 2018 at 12:01, Jeremy Roussak via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I usually work on a Mac. I have to develop one application in 4D on a > Windows machine. It’s already up and working on the Mac. > > On my Mac, I can put aliases

Re: Write Pro: Creating headers/footers

2018-10-10 Thread Pat Bensky via 4D_Tech
ader and a footer for a specific section with > two new commands: WP New header and WP New footer. You can also delete a > header or footer with the WP DELETE HEADER and WP DELETE FOOTER commands." > > On Tue, Oct 9, 2018 at 5:57 PM Pat Bensky via 4D_Tech < > 4d_tech@lists.4d.com&

Re: 4D Write Pro (WP) Area and ST INSERT EXPRESSION

2018-10-09 Thread Pat Bensky via 4D_Tech
Something like ... *ST INSERT EXPRESSION*(WriteProArea;"String(Current date;System date long)") for example. On Tue, 9 Oct 2018 at 17:50, David Ringsmuth via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Insert expression and Get expression seem to not be pre-implemented in the > 4D v17 Write Pro

Re: Write Pro: Creating headers/footers

2018-10-09 Thread Pat Bensky via 4D_Tech
hen in ‘Page’ mode…. practically, this means, as high or as > low as you can on the 4D Write Pro page. > > Rudy Mortier > Two Way Communications bvba > > > > > On 6 Oct 2018, at 00:59, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > > I

Write Pro: Creating headers/footers

2018-10-05 Thread Pat Bensky via 4D_Tech
If I create a new WP document from scratch, is there any way to add a header or footer to the document? Or do I have to start with a template that has a header/footer and modify it? Pat -- * CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118

Re: WritePro letter emailed to MS Outlook

2018-10-03 Thread Pat Bensky via 4D_Tech
Alan, I'd suggest that you try using SMTP_Quicksend instead of the lower-level SMTP functions. Read up on SMTP_Quicksend and I think you'll find that you can do everything you need with that, and (in our pretty thorough testing) it sends emails that are accepted by Outlook, Yahoo, Gmail, Mail, and

Re: How to get the current time in a specified time zone

2018-09-26 Thread Pat Bensky via 4D_Tech
I will see if then I can figure out getting it > for the different time zones without having it hard coded in. > > Jody > > > > On Sep 24, 2018, at 4:28 PM, Pat Bensky via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Using v16: > > I've figured out

How to get the current time in a specified time zone

2018-09-24 Thread Pat Bensky via 4D_Tech
Using v16: I've figured out how to get the current GMT time using cURL. (Code at the bottom if anybody is interested). Now I need to get the current time in a different time zone - eg in France. Any ideas how to do that? == //

Re: v16 - playing videos stored in the database

2018-09-18 Thread Pat Bensky via 4D_Tech
We use Wistia to manage our videos (https://wistia.com). You have lots of control over the appearance and functioning of each video, and can easily get links to embed in an email, web page, etc. You also get useful stats on who viewed each video, their level of engagement, etc. It's not free of

  1   2   3   >