Re: Creating .docx files

Patrick and/or Dani ... I wonder if you would be willing to share some basic code to create a Word document with phpword? I am having trouble getting it to work. If you could share just a snippet that creates a very simple document, that would be very much appreciated! Thanks Pat On 22 January 201

Re: User Custom Forms

's > changes. > > Also, could OBJECT DUPLICATE be used during On Load to give a new object a > name like "[Table1]Field1"? > > Keith - CDI > > > On Jan 23, 2018, at 8:41 AM, Pat Bensky via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > (U

User Custom Forms

(Using v16) I'm experimenting with allowing users to create their own forms with editable forms. I have one or two questions ... *1. Displaying/deleting objects such as fields* I need to allow the user to choose which fields to display on the form. The only way I can see to manage that is to plac

Re: Creating .docx files

Oh wow ... I'm going to give phpword a try. thanks for the suggestion. On 21 January 2018 at 20:47, Dani Beaubien via 4D_Tech <4d_tech@lists.4d.com > wrote: > +1 for phpword. I have been using for the last few months and it is fast > and works very well. > > Dani > > > ***

Re: Anyone been using R5 for real work?

For us, there's one show-stopping bug in r5 (not present in R4). It's a bit obscure ... In our Data Import area we have a listbox in which users can add columns to map incoming data (e.g. from a spreadsheet or csv file) to fields in the database. If a field name is duplicated, it generates an error

Re: Creating .docx files

rnatively you could use something like: > > 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. > &g

Creating .docx files

I think I am slowly losing my sanity. Trying to create DOCX files from 4D. My code creates the requisite XML files, then zips them up and produces a .docx document. My test document is very simple: it contains one word, "Brownies". If I unzip that .docx I can see all the files and they all appear t

Re: How to fix Design windows closing after quiting 4D

> use 16.214179 or later... I'm using 16R5.219028 and I have the same problem ... On 17 January 2018 at 23:42, Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > ACI0096985,ACI0097118 > > Opened windows are not saved after 4D is closed (test application mode). > > use 16.214179 or later

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

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

Miyako's Zip plugin for 4D v16 - ZIP_Without_enclosing_folder option

using 4D v16, Mac: I can successfully Zip a folder using the Zip plugin. However ... I'm building docx files, which consist of a zipped folder of xml files. I need to create the Zip archive by adding just the actual files without their enclosing folder. I believe the ZIP_Without_enclosing_folder o

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

r if that 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,

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

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 per

Emails to gmail - images don't come through

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 ad

Re: Sending attachments with SMTP_QuickSend?

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 seeme

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

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 t

Re: Sending attachments with SMTP_QuickSend?

Pat On 19 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_

Sending attachments with SMTP_QuickSend?

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 or

Re: Pictures beside text in 4D Write Pro

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

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 December

Re: 4D Write Pro Sample DB on YouTube

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: Post Key command not working in converted 4Dv16 database - SOLVED

the window 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?

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

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

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: Post Key command not working in converted 4Dv16 database - SOLVED

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?

gh 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 (hun

Change field type programmatically?

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 day

Re: 16R5 checks array element twice

It behaves the same with in v16r4 also. Seems like a bug to me! Pat On 27 November 2017 at 22:28, Jim Hays via 4D_Tech <4d_tech@lists.4d.com> wrote: > This is just a weird oddity I came across. I can't think of a good reason > to use this code in a safe way, but here it is. (If anyone can think

Re: Numeric Array Variable Not Reset When Array Redefined

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 for

Re: How do I programmatically set a 4D Write Pro document's page size?

Hi Jeremy, Try SET PRINT OPTION ( option ; value1 {; value2} ) http://doc.4d.com/4Dv16R4/4D/16-R4/SET-PRINT-OPTION.301-3318228.en.html HTH Pat On 26 November 2017 at 17:42, Jeremy French via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I would like to programmatically set the Write Pro's page siz

Hunspell dictionaries installed

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 d

Re: Resizable subforms

tta 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 Bensk

Re: Resizable subforms

ro object 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

Re: Resizable subforms

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 &

Lightning examples?

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 -- ***

Resizable subforms

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 subf

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

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 < 4d_tech@lists.4

Re: Export import all after a crash

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 o

Re: QUERY into variable vs. Records in Table

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 <4d_tech@list

Re: FORM SET OUTPUT -> project form

Keith 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> w

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

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

FORM SET OUTPUT -> project form

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 7889

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

gt; 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 > ***************** > -Original Message- &

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

e no right to be here. > 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 (

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

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 s

Re: Canvas alternative

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 > fo

Re: Procedurally adding attributes to ST SET ATTRIBUTES

light;ST End > 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 < >

Re: Command numbers and names and using Execute

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 numb

Procedurally adding attributes to ST SET ATTRIBUTES

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 style;1;

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

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 (agen

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

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 w

Re: Heads Up about Write Pro Style Transformations

have met, have 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 Bens

Re: Heads Up about Write Pro Style Transformations

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 to

Re: FTP_receive with long filenames

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 us

FTP_receive with long filenames

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 "/imagecach

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

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

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> wro

Re: Horizontal Sizing Move

widened 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: Modal dialog dilemma

ur 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,

Re: Horizontal Sizing Move

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 17:08,

Modal dialog dilemma

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 edited

Re: 4D and Sage

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

Re: FootRunner + V13.5 Windows?

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 t

4D and Sage

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 v

Re: Data mining from Oracle Application using 4D

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 us

Re: Write Pro beginner question

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 the

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

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: GOTO OBJECT

Can you show us your code? I don't see why GOTO OBJECT (*;object name) wouldn't work. Pat On 2 May 2017 at 09:31, Vincent de Lachaux via 4D_Tech <4d_tech@lists.4d.com > wrote: > Perhaps you can try to use GOTO OBJECT into the event "On activate" that > will be triggered when the alert will be cl

Re: 4D Write Pro CSS

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 the

Re: QR code

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 anyth

Re: 4D Write Pro CSS

INT > 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 aforementione

Re: 4D Write Pro CSS

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

4D Write Pro CSS

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." http://doc.4d.com/4Dv16R2/4D/16-R2.1620/Using-a-4D-

Moving a window

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 do

Re: Backup files - restoring backup

; inadvertently 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

Re: v16 and Canvas

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

Backup files - restoring backup

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 w

Re: v16 and Canvas

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, M

Re: v16 and Canvas

ists.4d.com> wrote: > Canvas is working for us with v16, but we haven't gone very far with 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 > Interprete

v16 and Canvas

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: Tables created with SQL CREATE TABLE command and triggers

> 3) You 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

Re: Tables created with SQL CREATE TABLE command and triggers

on is 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

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

Re: Tables created with SQL CREATE TABLE command and triggers

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 fundam

Re: Tables created with SQL CREATE TABLE command and triggers

the taking of any action in > reliance upon this transmission is strictly prohibited. Delivery of this > message to any person other than the intended recipient shall not > compromise or waive such confidentiality, privilege or exemption from > disclosure as to this communication. > > >

Re: Tables created with SQL CREATE TABLE command and triggers

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

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 wi

<    1   2   3   4