Re: Sheets on Windows

2019-11-19 Thread Kirk Brooks via 4D_Tech
Hey John, This might help. You pass an object with the various params and it will open a new window within the bounds of whatever window you call it in. You can futz with the padding at the top to get it lined up the way you want. And looking at it it could be freshened up to dot notation... //%at

Re: V17.6 How to getting a newly-related record to load in ORDA

2019-11-19 Thread Chris Belanger via 4D_Tech
I read my diagram incorrectly… it is going to a NON-PRIMARY key field. What a stupid mis-read. I will re-work the structure to use the primary key. Thanks for the tip. — dazed and confused, Chris :) > On Nov 19, 2019, at 3:17 PM, Chris Belanger wrote: > > Man, I must be going crazy… yes, it

Re: Log integration failed

2019-11-19 Thread Tom Benedict via 4D_Tech
Hi Mitchell, >My question pertains to this case: Is it worth trying to open the timestamped >damaged database and repair it? Theoretically I would only lose data since the >last cache flush. It’s certainly worth a try. Since you’re in a period of instability which may go on for some time, it

Log integration failed

2019-11-19 Thread Mitchell Shiller via 4D_Tech
Hi, I have sporadic crashes on my 4D Server that I am trying to solve. But that is not my issue today. The server is set to 1) Integrate the log file if database incomplete and 2) Restore from backup if the database is damaged. Also the cache flush is set to 20 sec. 95% of the time this works

Sheets on Windows

2019-11-19 Thread John J Foster via 4D_Tech
Hi All, 4D v17R5 Mac and Windows (running as engined app) I love how Mac OS handles windows as sheets. But on windows the same window opens centered (I think) in the screen. I’d like to get as close to similar behavior as possible. Before I spend time doing this I am wondering … Has anyone de

RE: V17.6 How to getting a newly-related record to load in ORDA

2019-11-19 Thread Dennis, Neil via 4D_Tech
> There is a horrible bug in ORDA where regardless of which field the relation > is > drawn to in the one table, it will always locate the one record by querying on > the primary key field of the one record using the value you have entered into > the many field. Justin, I just ran a couple of te

Re: V17.6 How to getting a newly-related record to load in ORDA

2019-11-19 Thread Jeremy French via 4D_Tech
What is a “CBOX” technique”? > On Nov 19, 2019, at 3:16 AM, Chris Belanger via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I have a CBOX technique that lets me ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/

Re: V17.6 How to getting a newly-related record to load in ORDA

2019-11-19 Thread Justin Carr via 4D_Tech
Hi Chris Is the relationship (UnitType) definitely drawn to the primary key field in the one table (the one with the underline in the structure editor)? If not, then you cannot do what you want. As I said, 4D will always query the one table's primary key for the value you enter into the relatio

Re: V17.6 How to getting a newly-related record to load in ORDA

2019-11-19 Thread Justin Carr via 4D_Tech
Hi Chris Short answer is that if the many table is related to a field in the one table which is NOT the primary key of the one table, the you should ***ABSOLUTELY NOT USE ORDA*** to set the value of the many table field. There is a horrible bug in ORDA where regardless of which field the relati

Re: 3D Button collection? (Or manufacturing)

2019-11-19 Thread Chris Belanger via 4D_Tech
Thanks for the tip. I have seen some other similar icon collections. Of course, this does not create 4-state 4D-type buttons… — Chris > On Nov 8, 2019, at 1:09 PM, Narinder Chandi via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > You could take a look at Google Material Design icons - seems lik

V17.6 How to getting a newly-related record to load in ORDA

2019-11-19 Thread Chris Belanger via 4D_Tech
I have a challenge, I have a CBOX technique that lets me set the correct related KEY into a record’s field. It sets the correct value. But that related record is not ‘loaded’ after this correct value is loaded into that field. For example: Two tables (in classic 4D nomenclature) [Units][Uni