Re: Re(2): Layered transaction - need to push and pop?

you start with a selection (one or more) records in your table you run your transaction - just because you cancel the transaction does not mean that the record you start on is the one i memory (loaded) somewhere in your transaction you could do a search, or sort, or create a new selection, or

Re: Temporarily changing the system date format

They are in an alpha format, like this: 11/14/2018-11/16/2018 and I need to sort on the first date. So I can copy that to a Date field. If I copy it to an alpha field it will look OK but won't sort correctly. PB On 24 February 2018 at 00:19, Jeremy French via 4D_Tech < 4d_tech@lists.4d.com>

Re: Temporarily changing the system date format

What is the field type in which the dates are stored? Date or alpha? > On Feb 23, 2018, at 6:51 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Using v16 ... > > I am in the UK I'm working on a publishing project for a customer in the > US. Part of the project requires certain

Temporarily changing the system date format

Using v16 ... I am in the UK I'm working on a publishing project for a customer in the US. Part of the project requires certain data to be sorted by date. So I need them to be sorted in the US date format (mm/dd/) instead of the UK format (dd/mm/). Is there a way to temporarily override

Re(2): Layered transaction - need to push and pop?

Hi Kirk, The program is currently single-user. I did include load-wait and unload type record handling which I use on server applications. I considered variables. It might run faster, too, though I don't know how 4D manipulates records within transactions. Ssince it's happening in memory, they

Re: Best way to get HTML Tables to MS Word tables

Thanks Dani, I'll check that out. I have never used or needed to use PHP so I hope that I can find another solution. If it's the only game in town then I guess I'll have to dive in. I'm thinking XML, as I am more familiar with that and MS Word seems to support it, but again I would feel better if

Re: Best way to get HTML Tables to MS Word tables

Hi Jim, I suggest you take a look at phpWord (https://phpword.readthedocs.io/en/latest/ ). It works well, quite quick and you can output in a number of word formats. Dani > On Feb 23, 2018, at 3:04 PM, Jim Labos - infobase via 4D_Tech >

Best way to get HTML Tables to MS Word tables

I've been doing some HTML tables that end up in Word for a while now but until now there was no need to get it to render any better so if it ain't broke. However now comes the need to have tables render as exact as possible in Word. Now I say /from/ HTML because I have been doing it that way

What causes a 'user interruption -1000' error on an EOS method?

On Feb 23, 2018, at 10:29 AM, Kirk Brooks wrote: > I don't recall ever having this issue. I have a method set to execute on > server. It takes a series of pointers and looks like this: > > $errMsg:=EOS_method (\ > ->$obj;\ > ->aMY_name;\ > ->aMY_ref;\ > ->aMy_recID;\ > ->aMY_info;\ >

Re: What causes a 'user interruption -1000' error on an EOS method?

I resolved this issue though I'm not entirely sure what the fix is. I ran MSC and did a 'repair' on the structure. Same results. Next I put the specific call to the EOS method into a test method and found the issue seemed to happen when called in the context of the form method it was running. This

Re: Blank Listbox

Hi Spencer, It's a selection-based listbox. Anyway I've found a workaround ... Instead of setting everything invisible and then making the appropriate objects visible, if I do it the opposite way round it works OK. IE instead of: OBJECT SET VISIBLE(*;"@";false) OBJECT SET

Re: Blank Listbox

> Le 23 févr. 2018 à 16:42, Spencer Hinsdale via 4D_Tech <4d_tech@lists.4d.com> > a écrit : > > my blank list boxes are always arrays, out of sync same here: columns empty in a listbox (lb) means on column shorter or longer that others. How is filled the lb in group4: selection to array,

Re: Layered transaction - need to push and pop?

Hi Don, A couple of thoughts. First, and I'm assuming this is running on 4D server, I'm not a fan of opening a record for editing in a transaction when you also manipulate other records. This example illustrates why - each record you touch in becomes locked to the transaction if you change it and

Re: Blank Listbox

my blank list boxes are always arrays, out of sync, which is easy to suss by backing off the fill instructions until it shows something. hint, one column is always in sync. however i don't think this problem makes headers blank. i would suggest you try leaving listbox in group4 and showing

Blank Listbox

Using v16 ... Mac ... I have a form on which there are lots of objects which have been named in groups - e.g. "group1Text1" "group1label1" etc. The groups of objects are hidden or shown depending on which tab has been selected. eg *OBJECT SET VISIBLE*(*;"Group1@";*True*) *OBJECT SET

Re: Print to MS Word Document

Also look at PHPWord: https://phpword.readthedocs.io/en/latest/ On 23 February 2018 at 05:20, rooftop99--- via 4D_Tech <4d_tech@lists.4d.com > wrote: > Thank you Dan and Keisuke! Helpful!! > > > On Feb 22, 2018, at 9:25 AM, Dan Gallagher via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > >

Layered transaction - need to push and pop?

Hi, Suppose your birthday cake is the record, and the ingredients (sugar, flour, butter, chocolate, raspberries, etc.) are the related records. Now you want to run scenarios to determine the lowest cost of the cake while varying the ingredients. Each ingredient will differ in unit cost from