Re: Creating Tables by running a method

2018-06-23 Thread Jody Bevan via 4D_Tech
Randy: So I have got this done using all SQL. At the end it would create the indexes for the first table I created, but then fail for al the next. Eventually I figured out that the index name (behind the scenes) need to be unique within the whole database. Therefore I just added a string of the

RE: Creating Tables by running a method

2018-06-23 Thread Randy Engle via 4D_Tech
Jody, Glad to hear of your progress! Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Jody Bevan via 4D_Tech Sent: Saturday, June 23, 2018 9:53 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Jody Bevan Su

Re: Creating Tables by running a method

2018-06-23 Thread John DeSoi via 4D_Tech
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 trigger properties if you create the tables via XML and use IMPORT STRUCTURE. John DeSoi, Ph.D. > On Jun 23, 2018, at 11:52 AM, Jody Bevan via 4D_Tech <4

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

Re: Creating Tables by running a method

2018-06-23 Thread John DeSoi via 4D_Tech
Pat, Not in the XML, but you could import the table structure (with trigger properties enabled) and then set the trigger code using METHOD SET CODE. My approach would be to enable all the trigger properties even if there is not an immediate need to have a trigger. I don't think there is any oth

4D Write, pictures in page, frozen document, to 4D Write Pro

2018-06-23 Thread JOHN BAUGHMAN via 4D_Tech
Still trying to get my head around converting 4D Write documents that contain images in page to 4D Write Pro. I have moved on from the templates which I think I have working and am now dealing with correspondence that has been printed and most have references frozen. These document have up to 1