Moving a window

2017-03-31 Thread Pat Bensky via 4D_Tech
Should be easy enough ... right? Nope! Using Windows 7 (or any version of Windows, probably) we've opened a window in a new process, and it has somehow got itself moved up too far so that the title bar is hidden. On the Mac I can easily fix this by cmd+ctrl+click and drag. On Windows this can be

Re: v16 and Canvas

2017-03-14 Thread Pat Bensky via 4D_Tech
So I got an update for the plugin form Rob at Pluggers and now it works fine. On 9 March 2017 at 21:24, Jim Hays via 4D_Tech <4d_tech@lists.4d.com> wrote: > 16 beta 1 - yeah - I was surprised it's that old. That's how often I get > to work with it I guess. :( > > > On Thu, Mar 9, 2017 at 12:49

Re: Backup files - restoring backup

2017-03-14 Thread Pat Bensky via 4D_Tech
moved a file - like the log file? > > Since they don't think they are doing backups and if they are sure the > datafile is correct you can just trash the log file. > > Or copy the datafile folder, trash the log file and restart. > > > On Mon, Mar 13, 2017 at 7:50 AM, Pat Bensky vi

Re: 4D Write Pro CSS

2017-04-23 Thread Pat Bensky via 4D_Tech
7.en.html > > explains proprietary CSS attributes such as > > > > and > > Click here > > > 2017/04/23 1:12、Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> のメール: > > its own subset of HT

4D Write Pro CSS

2017-04-22 Thread Pat Bensky via 4D_Tech
In the online docs for v16r2 it says: "*Note:* The 4D Write Pro internal document format is a proprietary HTML extension, compatible with HTML5/XHTML5, but which supports its own subset of HTML/CSS attributes and tags, specified in this manual."

v16 and Canvas

2017-03-09 Thread Pat Bensky via 4D_Tech
Anybody successfully using the Canvas plugin with v16? -- * CatBase - The Database Publishing Solution tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky *

Re: v16 and Canvas

2017-03-09 Thread Pat Bensky via 4D_Tech
h it. >> Our app crashes a lot, and we haven't had time to figure out why. >> We still ship with v12.6. >> >> MacBook Pro touch bar >> Sierra 10.12.3 >> v16 beta 1 32 bit >> Interpreted >> >> >> On Thu, Mar 9, 201

Backup files - restoring backup

2017-03-13 Thread Pat Bensky via 4D_Tech
A client is getting the message: "An error occured during the log file integration, it is recommended to restore the last backup of this database in order to attempt the integration of this log file"" I've told them how to restore the backup file manually but they say they do not have any files

Re: Tables created with SQL CREATE TABLE command and triggers

2017-03-08 Thread Pat Bensky via 4D_Tech
to go back to the days before we had triggers > and set a process to look for modified records in the created tables… > > Nigel Greenlee > > > > > > > > On 8 Mar 2017, at 10:10, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > >

Re: Tables created with SQL CREATE TABLE command and triggers

2017-03-08 Thread Pat Bensky via 4D_Tech
u use alter to alter the name of the table in the copy and add the > custom fields > > So you end up with N external data-files one for each custom table. > > …maybe someone has a better way > > Nigel > > > > > On 8 Mar 2017, at 12:32, Pat Bensky via 4D_Tech <

Re: Tables created with SQL CREATE TABLE command and triggers

2017-03-07 Thread Pat Bensky via 4D_Tech
g 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 Mar 7,

Re: Tables created with SQL CREATE TABLE command and triggers

2017-03-07 Thread Pat Bensky via 4D_Tech
Thanks Tim - but METHOD SET CODE doesn't work in a compiled database, does it? On 7 March 2017 at 23:40, Timothy Penner via 4D_Tech <4d_tech@lists.4d.com> wrote: > > I can't see a way to programmatically add a trigger to it > > Triggers can be enabled or disabled via the ALTER TABLE command, > >

Tables created with SQL CREATE TABLE command and triggers

2017-03-07 Thread Pat Bensky via 4D_Tech
I'm revisiting the idea of creating a flexible table structure with v16. Currently we have lots of user data tables defined, and they are activated/deactivated as required by each customer. This works OK but it adds a lot of overhead to the database, as it means we have more than 50 tables, each

Re: Tables created with SQL CREATE TABLE command and triggers

2017-03-08 Thread Pat Bensky via 4D_Tech
17 à 10:19, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > > > [...] Also I've realised that there is another fundamental problem with > the idea > > of allowing customers to create new fields: when we issue a program > update, > > those cust

Re: Tables created with SQL CREATE TABLE command and triggers

2017-03-08 Thread Pat Bensky via 4D_Tech
Hi Chip, The problem with that scenario is that it would preclude the use of 4D features such as the report editor, 4DWrite, label editor, etc. - all things that our customers use. Or we would have to roll out our own, which I'm not inclined to do :) Also I've realised that there is another

FTP_receive with long filenames

2017-07-28 Thread Pat Bensky via 4D_Tech
Using v13.5 ... I'm trying to download some files from a client's FTP site. The files have quite long names - e.g.: 53ee6f6f-3c81-41ae-b001-a5a000baebbc_350x271.jpg So here's some test code: fr_tImageToGet:=fr_WebDirectory+"53ee6f6f-3c81-41ae-b001-a5a000baebbc_350x271.jpg" // returns

Re: Heads Up about Write Pro Style Transformations

2017-08-01 Thread Pat Bensky via 4D_Tech
Hi Keith, I suppose it could be argued that ST Get Plain Text gets plain (i.e., unstyled) text ... text in its raw form ... but I agree with your point of view. Pat On 31 July 2017 at 15:09, Keith Culotta via 4D_Tech <4d_tech@lists.4d.com> wrote: > This is something to be aware of if you plan

Re: Heads Up about Write Pro Style Transformations

2017-08-01 Thread Pat Bensky via 4D_Tech
an expectation that the > case of a character is a "real" thing, and the attributes like bold, etc... > are the "cosmetic" part. It seems unfortunate to introduce this kind of > ambiguity. > > Keith - CDI > > > On Aug 1, 2017, at 4:10 AM, Pat Bensky via 4D_Tech

Re: Use of Objects vs Global Variables (Was 'Arrays vs Objects...)

2017-07-21 Thread Pat Bensky via 4D_Tech
My 2 cents: According to a recent 4D blog entry, using the new object notation option will speed up your objects significantly: "Good news, now you have a mean to get rid of all those OB Get and OB SET

Re: SQL

2017-07-05 Thread Pat Bensky via 4D_Tech
Robert, I remember seeing that when I was working on a SQL project a while back, but can't remember the details :) If you can describe what you are doing when you get the error, perhaps that will jog my memory ... Pat On 5 July 2017 at 06:22, Robert McKeever via 4D_Tech <4d_tech@lists.4d.com>

Re: 4D Write Pro CSS

2017-04-26 Thread Pat Bensky via 4D_Tech
OK, thanks for clarifying that :) So ... I want to create Write Pro documents entirely through programming, but there seem to be some vital options missing. For example: How to create a new Stylesheet? You can apply an existing stylesheet with WP SET ATTRIBUTES but I don't see a way to create

Re: QR code

2017-04-26 Thread Pat Bensky via 4D_Tech
Check out the barcode plugin from HM Plugins https://www.hmplugins.com/en/hmBarcode/Features-133.html On 26 April 2017 at 09:23, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> wrote: > Hi, > > I spent some time on the partner section looking but I couldn’t find > anything on QR codes. Does

Re: 4D Write Pro CSS

2017-04-24 Thread Pat Bensky via 4D_Tech
gt; http://doc.4d.com/4Dv16R2/4D/16-R2.1620/WP-PRINT.301-3124247.en.html > > allows you to ignore the -d4 styles in printing. > > - > > but you are right, the doc seems to be missing a comprehensive list of all > "-d4" styles. > > other than the aforementi

Re: FTP_receive with long filenames

2017-07-28 Thread Pat Bensky via 4D_Tech
Hi Tim, I did a test using v16r4 beta and it worked OK with the long filename. So that's good :) I did notice however that although I passed the 1 parameter in FTP_Receive fr_err:=*FTP_Receive* (vFTP_ID;fr_tImageToGet;fr_tImageSavePath;1) ... it did NOT display a progress message, even when I

Re: No, I don't want to open the structure in Read-Only mode in v.16 - so stuck I'm stuck

2017-05-02 Thread Pat Bensky via 4D_Tech
Hi David, Are you sure you don't already have that structure open elsewhere (in an older 4D version, perhaps)? Pat On 2 May 2017 at 18:09, David Hudson via 4D_Tech <4d_tech@lists.4d.com> wrote: > Just downloaded v16 R2, trying to upgrade a structure currently in v.15.5 > (Mac, Sierra 10.12.4)

Re: Write Pro beginner question

2017-05-30 Thread Pat Bensky via 4D_Tech
Please don't cry, Bernd :) I think you have slightly misunderstood ST SET PLAIN TEXT. In this context PLAIN TEXT means *unformatted*, rather than *unstyled*. In other words, ST SET PLAIN TEXT inserts text into whatever styling is already in place. So to remove the bold, you would need to change

Re: Data mining from Oracle Application using 4D

2017-06-02 Thread Pat Bensky via 4D_Tech
Mac or Windows? If you're on a Mac, check out the Actual ODBC drivers: http://www.actualtech.com/products.php Pat On 1 June 2017 at 18:47, rooftop99--- via 4D_Tech <4d_tech@lists.4d.com> wrote: > Hi All, > > I have a large Oracle database from which I need to regularly extract > specific data

4D and Sage

2017-06-13 Thread Pat Bensky via 4D_Tech
We've had a few enquiries from customers and prospects about interfacing with Sage and I'd like to get an idea of how much work would be involved in setting this up. Basically we need to: - Extract data into our 4D database - Push data from 4D to Sage Standard stuff I guess :) We'll be using 4D

Re: Modal dialog dilemma

2017-06-17 Thread Pat Bensky via 4D_Tech
code (as long as you use 4D v12 or greater) to resolve > the issue within the limited scope you describe. As you learn to like it, > then you could expand it as you have time to rewrite old code, and in > anything new that your write. > > Jody > > > > On Jun 17, 2017, at 9:5

Re: Horizontal Sizing Move

2017-06-17 Thread Pat Bensky via 4D_Tech
Robert, I think it depends on whatever static objects are on the form. If you've got an object that is not set to move, that will form the boundary for resizing purposes. If you have more than one page on the form, it will take into account objects on ALL pages. HTH Pat On 17 June 2017 at

Modal dialog dilemma

2017-06-17 Thread Pat Bensky via 4D_Tech
Using v 13.5 ... I have a modal dialog which displays info from [Table A] and contains a pop-up menu listing items form [Table B]. Sometimes it is necessary to modify a [Table B] record, or add a new one, within that dialog. So we change the window size (if necessary), find the record to be

Re: FootRunner + V13.5 Windows?

2017-06-13 Thread Pat Bensky via 4D_Tech
Doug, We had a problem like this with a customer last year and we were able to (kinda) fix it by installing the appropriate version of the C++ Redistributable. I say "kinda" because at one point we got it working, and then it stopped working again - I think the customer's IT guy changed something

Re: Horizontal Sizing Move

2017-06-18 Thread Pat Bensky via 4D_Tech
dened but > will not move much to the left if the window is narrowed. Rather it just > disappears from view. > > I am not sure what the "static objects" are. > > > > On Jun 17, 2017, at 10:59 AM, Pat Bensky via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >

Re: 4D and Sage

2017-06-14 Thread Pat Bensky via 4D_Tech
ink. > > > > Nigel > > On 13 Jun 2017, at 12:17, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > > We've had a few enquiries from customers and prospects about interfacing > > with Sage and I'd like to get an idea of how much work wo

Re: 4D Write Pro - WP EXPORT DOCUMENT to WORD?

2017-09-18 Thread Pat Bensky via 4D_Tech
I' ve also added a couple of Write Pro feature requests - please vote for them if you care! Creating headers and footers http://forums.4d.com/Post/EN/20815236/1/20815237#20815237 Creating stylesheets http://forums.4d.com/Post//20815261/1/ Pat On 18 September 2017 at 08:19, Epperlein, Lutz

Procedurally adding attributes to ST SET ATTRIBUTES

2017-09-21 Thread Pat Bensky via 4D_Tech
I can't get my head around this :) I need to be able to procedurally build up an *ST SET ATTRIBUTES *statement. I have a number of styles - let's call them Style A, Style B, Style C. Style A might be built like this: Attribute font name;"Arial";Attribute text size;20;Attribute underline

Re: 4D Write Pro - WP EXPORT DOCUMENT to WORD?

2017-09-17 Thread Pat Bensky via 4D_Tech
This is a good question Jim and one that I am also interested in. Have you asked about it on the beta forum? Here's a possible solution for now: - Save the WritePro object as a PDF (using SET PRINT OPTION) - Open the PDF in Acrobat - Save that as a Word document I did this manually and it worked

Re: Procedurally adding attributes to ST SET ATTRIBUTES

2017-09-21 Thread Pat Bensky via 4D_Tech
d > highlight;$aStyle{$iStyle};0) > End for > > Note one issue that I ran into was that I had to use object name form in > order to use the selection constants. > > John DeSoi, Ph.D. > > > > On Sep 21, 2017, at 10:05 AM, Pat Bensky via 4D_Tech < > 4d_tech@lists.

Re: Command numbers and names and using Execute

2017-09-21 Thread Pat Bensky via 4D_Tech
FYI - in V15 and later you don't need to bother with the command numbers any more: " Compatibility note: Since a command name may vary from one 4D version to the next (commands renamed), this command was used in previous versions of the program to designate a command directly by means of its

Re: What to do about users who won't follow instructions?

2017-10-04 Thread Pat Bensky via 4D_Tech
* > Stephen J. Orth > The Aquila Group, Inc. Office: (608) 834-9213 > P.O. Box 690 Mobile: (608) 347-6447 > Sun Prairie, WI 53590 > > E-Mail: s.o...@the-aquila-group.com > ***************** > -Or

Re: Canvas alternative

2017-10-02 Thread Pat Bensky via 4D_Tech
But can you add the same options to your SVG objects as you can with Canvas? Events, callbacks, resizing controls, etc. Pat On 2 October 2017 at 21:15, John Baughman via 4D_Tech <4d_tech@lists.4d.com> wrote: > Drew, > > Ahh yes. I remember now that I too had significant issues going >

What to do about users who won't follow instructions?

2017-10-04 Thread Pat Bensky via 4D_Tech
Users are beginning to get to me :) Some of them WILL NOT follow instructions to accomplish something, no matter how simple those instructions are. I currently have one who is particularly bad! I sent him an email detailing how to accomplish a particular task. It contained an easy-to-follow 1-2-3

Re: What to do about users who won't follow instructions?

2017-10-04 Thread Pat Bensky via 4D_Tech
t; And whether you can hear it or not, > The universe is laughing behind your back. > - National Lampoon : Deteriorata > > Full Lyrics: > http://www.songlyrics.com/national-lampoon/deteriorata-lyrics/ > Youtube : https://www.youtube.com/watch?v=Ey6ugTmCYMk (missing the > intro 20

FORM SET OUTPUT -> project form

2017-10-16 Thread Pat Bensky via 4D_Tech
Using v14: I get an error with *FORM SET OUTPUT*("ReportHeaderLandscape") ​"There is no table to apply the command to" So how do you set the output form for a project form? Pat -- * CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118

Re: FORM SET OUTPUT -> project form

2017-10-17 Thread Pat Bensky via 4D_Tech
Culotta via 4D_Tech <4d_tech@lists.4d.com > wrote: > I think PRINT RECORD and PRINT SELECTION require a Table Form. A project > form is printed with PRINT FORM. > > Keith - CDI > > > On Oct 16, 2017, at 5:39 AM, Pat Bensky via 4D_Tech < > 4d_tech@lists.4d.com> wro

Re: Anyone using 4D Write Pro with a semblance of success?

2017-10-16 Thread Pat Bensky via 4D_Tech
We are creating a document-building system using WritePro. It creates data-based documents like catalogues, price lists, directories etc. - something that our software currently does by creating tagged files for importing into InDesign, QuarkXPress, or Word. Currently there are two major features

Re: Export import all after a crash

2017-10-22 Thread Pat Bensky via 4D_Tech
SQL EXPORT SELECTION will certainly be faster ... and simpler to write ... Pat On 22 October 2017 at 11:10, Arnaud de Montard via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Unbelievable but a customer of mine has always thought that any backup > solution was really too expensive. Predictable has

Re: Numeric Array Variable Not Reset When Array Redefined

2017-11-27 Thread Pat Bensky via 4D_Tech
The selected or specified value of the array is stored in the "zeroeth" element. On 26 November 2017 at 16:48, Arnaud de Montard via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > > Le 26 nov. 2017 à 17:37, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > a écrit : > > > > Allan, > > I went along

Re: 4D Write Pro Sample DB on YouTube

2017-12-12 Thread Pat Bensky via 4D_Tech
Is it this one? https://blog.4d.com/4d-write-like-toolbar-example-for-4d-write-pro/ On 13 December 2017 at 00:01, John Baughman via 4D_Tech < 4d_tech@lists.4d.com> wrote: > https://www.youtube.com/watch?v=ZpI2L8nCgzE > > The above YouTube video shows and refers to a sample database. Anyone know

Re: Pictures beside text in 4D Write Pro

2017-12-15 Thread Pat Bensky via 4D_Tech
ide an option to paste pictures > behind text as we could in 4D Write. Perhaps that is not possible in Pro?? > > John > > > > > On Dec 14, 2017, at 3:07 PM, Pat Bensky via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > John, > > I believe the wa

Re: Pictures beside text in 4D Write Pro

2017-12-14 Thread Pat Bensky via 4D_Tech
John, I believe the way to accomplish this would be to apply columns to a block of text. Unfortunately that option isn't (yet) available ): So I too would like to know how it was done ... perhaps he used a development version ... I will ask Roland (who wrote the blog) about it. Pat On 13

Sending attachments with SMTP_QuickSend?

2017-12-19 Thread Pat Bensky via 4D_Tech
Using v16 - I feel that it should be possible to add an attachment to an email, using SMTP_QuickSend rather than SMTP_Send, by creating a MIME object and sending that in the body of the message. But I can't get it to work. I want to attach (for example) a Pdf document. Is there a way to do this

Re: Sending attachments with SMTP_QuickSend?

2017-12-19 Thread Pat Bensky via 4D_Tech
December 2017 at 23:18, Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > it's possible but it might be length issue. > > I recommend you use a smaller image to get the code running, and then move > on to PDF. > > 2017/12/20 7:52、Pat Bensky via 4D_Tech <4d_tec

Hunspell dictionaries installed

2017-11-08 Thread Pat Bensky via 4D_Tech
Using v16r4 I call SPELL GET DICTIONARY LIST and the resulting array of language names contains 21 items, which includes English (United States) 3 times and Portuguese (Brazil) two times (but no Portuguese (Portugal)!), one one "unknown". Looking in the application/Resources/Spellcheck/Hunspell

Re: Post Key command not working in converted 4Dv16 database - SOLVED

2017-12-08 Thread Pat Bensky via 4D_Tech
I am also having problems with POST KEY in v16. It simply doesn't work :) Sample code: *Case of* *:* ($i="copy") *POST KEY*(*Character code*("c");Command key mask) *:* ($i="paste") *POST KEY*(*Character code*("v");Command key mask) *:* ($i="cut") *POST KEY*(*Character code*("x");Command key

Re: Change field type programmatically?

2017-12-01 Thread Pat Bensky via 4D_Tech
rough a right clic. Even if the fields are in different tables. > > Regards, > > Olivier > > > > > > Le 1 déc. 2017 à 14:19, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > > > Using v16: > > I have a large number of fields

Change field type programmatically?

2017-12-01 Thread Pat Bensky via 4D_Tech
Using v16: I have a large number of fields (hundreds) that I want to change from String to Text. Is there any way to do this programmatically? I thought I might be able to do it via SQL commands, but apparently 4D doesn't support the ALTER FIELD function. I'd prefer not to spend the rest of the

Re: Anyone have a link to a Northwind SQL dataset?

2017-12-10 Thread Pat Bensky via 4D_Tech
Hey Kirk, I haven't looked into this with v16 yet (it's on my To Do list) but in previous versions you needed to install an ODBC driver on Mac. See: https://www.catbase.com/configuring-an-odbc-driver Does that help? Pat On 10 December 2017 at 16:02, Kirk Brooks via 4D_Tech

Re: Post Key command not working in converted 4Dv16 database - SOLVED

2017-12-12 Thread Pat Bensky via 4D_Tech
indow type? > does the edit action work manually? > > (some window typs, by design, may not accept keyboard input) > > having said that: > > the standard way to invoke an edit action is to use a "standard action" > or use the INVOKE ACTION command (16R) > >

Re: Anyone have a link to a Northwind SQL dataset?

2017-12-09 Thread Pat Bensky via 4D_Tech
Are you connecting from a Mac or PC? Which version of 4D? Can you make the connection to the Northwind db OK? What error do you get? What's the script contents? So many questions ... :) Pat On 9 December 2017 at 21:14, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> wrote: > Hi Folks, > I would

Re: 4D Write Pro - Exporting / Saving to other file formats (e.g., .rtf or .doc)

2017-10-26 Thread Pat Bensky via 4D_Tech
You're correct ... currently it doesn't support export to RTF or Word. I imagine (hope) that this function will be added in a future release and I expect it will support the current MS Office XML format rather than RTF. Pat On 25 October 2017 at 23:05, Michael McCall via 4D_Tech <

Resizable subforms

2017-10-26 Thread Pat Bensky via 4D_Tech
Using v16: I'm experimenting with using subforms in ways that I haven't previously used them :) I have created a subform which contains a Write Pro area. The resizing options on that object are both set to Grow. I've placed this subform onto another form. I've set the resizing options for the

Re: Sending attachments with SMTP_QuickSend?

2017-12-21 Thread Pat Bensky via 4D_Tech
r own account details. (they are > removed in the published example) > > 2017/12/20 9:17、Pat Bensky via 4D_Tech <4d_tech@lists.4d.com d_t...@lists.4d.com>> のメール: > > Thanks Keisuke ... Do you have some sample code you could share? I tried > attaching a small image. It seemed to

Re: Creating/Modifying 4DWrite/Pro Documents via Web Page

2017-12-21 Thread Pat Bensky via 4D_Tech
I'm pretty sure this cannot be done with any flavour of 4DWrite ... I'd maybe use something like TinyMCE ( https://www.tinymce.com/docs/demo/full-featured/) and find a way to insert tags to merge data. TinyMCE is open source and either cloud- or self-hosted and mobile-friendly. This is something

Importing rtf files with images into 4D Write

2018-05-16 Thread Pat Bensky via 4D_Tech
I'm creating RTF files programmatically. They contain images. If the image is small (e.g. 8kb in one test), the file imports into 4DWrite correctly and prints OK. If the image is larger (e.g. 200k) it does not import into the 4DWrite document. I've tried this will various versions of 4D from v11

"Your password does not allow you to use this form"

2018-05-24 Thread Pat Bensky via 4D_Tech
On v13.5: Forever, we've had a Labels option with this code: PRINT LABEL(Table(iTableNumber)->;"xxx") ​This has always worked as expected: it opens the Label Editor with a blank label, and a list of fields form the table specified by iTableNumber. But it now displays the alert "Your password

Re: "Your password does not allow you to use this form"

2018-05-24 Thread Pat Bensky via 4D_Tech
that falls into this category. > > John > > > > > On May 23, 2018 at 11:14:12 PM, Pat Bensky via 4D_Tech ( > 4d_tech@lists.4d.com) wrote: > > On v13.5: > > Forever, we've had a Labels option with this code: > > PRINT LABEL(Table(iTableNumber)->;"xxx&

Re: "Your password does not allow you to use this form"

2018-05-24 Thread Pat Bensky via 4D_Tech
Hi Alan, Tried that - it doesn't make any difference. Pat On 24 May 2018 at 10:50, Alan Chan via 4D_Tech <4d_tech@lists.4d.com> wrote: > May be trying to use Char(1) instead of "xxx". > > Char(1) works well for us. > > Alan Chan > > 4D iNug Technical <4d_tech@lists.4d.com> writes: > >On v13.5:

Re: 4D won't launch - Windows 10

2018-06-09 Thread Pat Bensky via 4D_Tech
Have you tested with creating a new database instead of opening an existing one? PB On 9 June 2018 at 16:51, David Rose via 4D_Tech <4d_tech@lists.4d.com> wrote: > I have been using 4D v12, 15, 16 on my Windows 10 computer for years, no > problems until today. When I try to launch any of these

Re: Write Pro: programmatically manipulate text expertise needed

2018-06-12 Thread Pat Bensky via 4D_Tech
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

Re: Why won't Help Tip editor accept Carriage Return?

2018-06-12 Thread Pat Bensky via 4D_Tech
We manage help tips this way: - For each object, select the On Mouse Enter form event - We have a Help Tip named "HelpText" which simply contains a variable, tHelpText. Select that Help Tip for each object. - On the object, populate the tHelpText variable in the On Mouse Enter form event. With

Re: MySql login problem

2018-06-18 Thread Pat Bensky via 4D_Tech
Thanks Dougie. I gave them a different MySql connection to try (on our test server) and of course that works OK, so I think I have finally convinced them that the problem lies in their web server and NOT our software! Cheers Pat On Mon, 18 Jun 2018 at 17:01, Douglas Cryer via 4D_Tech <

Re: Is there any reason to not use Windows 64bit for v16R6 clients (Mac 64bit Server)?

2018-06-14 Thread Pat Bensky via 4D_Tech
Here's one: If you are using 4DWrite (not Pro), it won't work :) PB On Thu, 14 Jun 2018 at 15:54, Dave Nasralla via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hey All, > > We recently moved all our 4D apps to v16R6, partly to get ready for > the Macs going 64bit only. (I thought High Sierra was

Re: Musing on creating PDFs in 4D

2018-06-14 Thread Pat Bensky via 4D_Tech
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)

Re: Updating a structure - data goes AWOL

2018-06-15 Thread Pat Bensky via 4D_Tech
ring 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 4

Re: Write Pro: programmatically manipulate text expertise needed

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

Updating a structure - data goes AWOL

2018-06-14 Thread Pat Bensky via 4D_Tech
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

MySql login problem

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

Re: MySql login problem

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

Re: Save Record($vptr_Table->)

2018-06-10 Thread Pat Bensky via 4D_Tech
If there are any Unique fields in that table (I'm sure there are!) check that you aren't trying to save a duplicate value in one of them. PB On 10 June 2018 at 21:02, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> wrote: > Hi Doug: > > I wrote this code in the method with the problem line: > >

Re: "Your password does not allow you to use this form"

2018-05-29 Thread Pat Bensky via 4D_Tech
I determined that the problem only occurred when a specific table was involved. I opened the MSC and repaired the structure file. That fixed it :) PB On 25 May 2018 at 06:55, JPR via 4D_Tech <4d_tech@lists.4d.com> wrote: > [JPR] > > Hi Pat, > > Yes, I did write the Label Editor long time

Re: v13 - Null values

2018-06-03 Thread Pat Bensky via 4D_Tech
Maybe try something like this: - Set an error handler - Try to use that field or variable - If it is null then the error handler will catch it eg: ON ERR CALL("errorcatcher") $result:=$BooleanVarOrfield=true ON ERR CALL("") On 2 June 2018 at 15:02, Arnaud de Montard via 4D_Tech

Backup Settings window

2018-06-01 Thread Pat Bensky via 4D_Tech
I've just upgraded a client's custom database to v16. I compile it and build a stand-alone single-user app. When I launch this app, the Backup settings window opens with the window title ":StrLang,61". No matter what settings I choose, when I click the Save button I get the message: *Backup

Counting lines of text

2018-06-27 Thread Pat Bensky via 4D_Tech
I have a need to know how many lines a block of text will occupy. Given: - the plain text - the font - font size - text area width I'm thinking it should be possible to do this by creating a WritePro object, adding the text and setting the various parameters - this would create an accurate

Re: Counting lines of text

2018-06-27 Thread Pat Bensky via 4D_Tech
t; On Jun 27, 2018, at 4:31 PM, Pat Bensky via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > I have a need to know how many lines a block of text will occupy. > > Given: > > - the plain text > > - the font > > - font size > > - text area widt

Re: Creating Tables by running a method

2018-06-22 Thread Pat Bensky via 4D_Tech
One gotcha with creating tables this way is that you cannot add triggers. That may not be important for you but it's worth knowing ... Pat On Fri, 22 Jun 2018 at 19:11, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> wrote: > Just in case you "really" want to use SQL to create the index: > >

Re: WP Get selection

2018-06-22 Thread Pat Bensky via 4D_Tech
t; > John Baughman > Kailua, Hawaii > john...@hawaii.rr.com > > > On Jun 22, 2018, at 4:34 AM, Pat Bensky via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Further to my earlier post regarding the 4Dwrite toolbar ... > > I discovered that I

Re: Creating Tables by running a method

2018-06-23 Thread Pat Bensky via 4D_Tech
John, Can you set the trigger code that way as well (using XML)? Pat On Sat, 23 Jun 2018 at 21:04, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> wrote: > The triggers won't run until you set the trigger properties on the table. > I'm not aware there is any way to do that via SQL. You can set the

WP Get selection

2018-06-22 Thread Pat Bensky via 4D_Tech
Further to my earlier post regarding the 4Dwrite toolbar ... I discovered that I was using an older version of the demo database. So I got the latest one and copied the necessary elements from the demo db over to my db. Now I get an error message on calling *WP Get selection:* $wpRange:=*WP Get

Re: Any way to detect change to 4D Write Pro orientation.

2018-06-26 Thread Pat Bensky via 4D_Tech
Piotr, Perhaps you will need to: - Make it enterable - Give it the focus - Set the zoom - Make it non-enterable - Make the other object the focus A bit clunky ... but should work OK? Pat On Tue, 26 Jun 2018 at 07:54, Piotr Chabot Stadhouders via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi

Re: QUERY into variable vs. Records in Table

2017-10-19 Thread Pat Bensky via 4D_Tech
I'd have thought Records in Table would be quicker ... I'm sure 4D already "knows" how many records there are in each table, so it can just answer that question immediately rather than having to query and count the result ... Pat On 19 October 2017 at 17:28, Dennis, Neil via 4D_Tech

Lightning examples?

2017-10-26 Thread Pat Bensky via 4D_Tech
I'm putting a proposal together for a client, which involves a web interface. Web dev is not really my thing and I don't have any examples to show them. We'll probably be using Lightning to manage the web stuff so - do any Lightning users have a site they can let us look at? Thanks! Pat --

Re: Resizable subforms

2017-10-26 Thread Pat Bensky via 4D_Tech
are thinking > when the host form is resized. > > Keith - CDI > > > On Oct 26, 2017, at 4:32 AM, Pat Bensky via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Using v16: > > I'm experimenting with using subforms in ways that I haven't previously > > u

Re: Resizable subforms

2017-10-26 Thread Pat Bensky via 4D_Tech
within the subform for sure set to grow? > > Keith - CDI > > > On Oct 26, 2017, at 12:47 PM, Pat Bensky via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Nothing grows ... not the subform or any of it contents. > > > > On 26 October 2017 at 16

Re: Resizable subforms

2017-10-28 Thread Pat Bensky via 4D_Tech
<4d_tech@lists.4d.com > wrote: > Here is a quick sample of what I think we are talking about: > http://cdinc.co/Sample/SubformGrow.zip > The subform objects resize in this one. Done in v16.2. > > Keith - CDI > > > On Oct 26, 2017, at 1:48 PM, Pat Bensky via 4D_Tech &

Emails to gmail - images don't come through

2018-01-08 Thread Pat Bensky via 4D_Tech
Using v16, Mac I'm using Write Pro to create emails. This works really well except for one thing ... If there's an image embedded within the email, when the email is sent to a gmail account, the pathname to the image appears instead of the actual image. If the same email is sent to another email

"Are you sure you want to open the structure file in read only mode" - Windows 7

2018-01-10 Thread Pat Bensky via 4D_Tech
Customer has installed our merged app (built using 4D v13) on his PC (Windows 7 with the latest updates installed). When he tries to run it he gets the message "Are you sure you want to open the structure file in read only mode?" He clicks OK and it crashes (crash report below). I guess it's a

Re: "Are you sure you want to open the structure file in read only mode" - Windows 7

2018-01-10 Thread Pat Bensky via 4D_Tech
was specifically > why, but I suspect it is. > Windows doesn't want an app writing to it's own directory. > > Or, have them right-click on the EXE and Run as Administrator - that might > solve it, but it is a pain to have to do that every time. > > > HTH, > > Jim Hays &

Miyako's ZIP plugin - without_enclosing_folder - creating Word DOCX docs - solved

2018-01-17 Thread Pat Bensky via 4D_Tech
I realised after posting my previous message that there is an error in my code - a missing semicolon: $success:=Zip ($folder;$dst;"";ZIP_Without_enclosing_folder"ZIP_CALLBACK") ​should be: $success:=Zip ($folder;$dst;"";ZIP_Without_enclosing_folder;"ZIP_CALLBACK") ​ ​Anyway, now it's working :)

Re: Creating .docx files

2018-01-19 Thread Pat Bensky via 4D_Tech
https://github.com/miyako/4d-plugin-opc > > > 2018/01/18 20:39、Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> のメール: > > > > I think I am slowly losing my sanity. > > Trying to create DOCX files from 4D. > > > > >

  1   2   3   4   >