Re: Triggers and modified by fields in roll-your-own user

2017-07-03 Thread Joaquin Mendes Castro via 4D_Tech
As far as i have been able to learn by trial and error, the first time a client connects to the server, it is asigned a User connection ID. This ID is not related to the 4D user, and will not be the same if you quit and connect again. As you said, it is more a node connecting to the server. The

Mouse Over Events in a standard 4D Output form... ToolTips?

2017-07-03 Thread rooftop99--- via 4D_Tech
Hi All, Version: 4D v15.2, Windows, Client/Server I would like to create a record specific “ToolTips” display on a standard 4D output form. This is without a click on any records. The desired end user behavior is: User mouses over a particular object in one of the rows of an output form.

Re: Triggers and modified by fields in roll-your-own user schemes

2017-07-03 Thread Kirk Brooks via 4D_Tech
Joaquin, Great suggestion. I'm not going to use it in this case because we don't currently have a session tracking system. But the tip about On server open connection is great. I missed that it fires each time a new process begins. I thought it only ran when initially connecting to the server. I

Triggers and modified by fields in roll-your-own user schemes

2017-07-03 Thread Joaquin Mendes Castro via 4D_Tech
We did this by using the On server open connection and On server close connection database methods. Any process launched by a user session shares an ID ($1) which can be used to track who is doing what. When a user logs into the application, we launch an special process which records this

Re: 4D v16 Table/Field numbers

2017-07-03 Thread Keisuke Miyako via 4D_Tech
That is right, you can prevent recycling field numbers by with the "ADD TRAILING" feature http://doc.4d.com/4Dv16/4D/16/ALTER-TABLE.300-3201314.en.html In any case, a field created with a recycled number will not contain values from its former life if you compact the data file. > 2017/07/03

Re: 4D v16 Table/Field numbers

2017-07-03 Thread npdennis via 4D_Tech
> Since noticing the 4D function "Is field number valid”, making it easy to > detect deleted fields, I thought field numbers would not be reused. It turns > out this is not the case. A bit of testing reveals that 4D does not even > clear the data when deleting a field, and still references data

4D v16 Table/Field numbers

2017-07-03 Thread James Crate via 4D_Tech
Since noticing the 4D function "Is field number valid”, making it easy to detect deleted fields, I thought field numbers would not be reused. It turns out this is not the case. A bit of testing reveals that 4D does not even clear the data when deleting a field, and still references data by

Re: An efficient printing approach...

2017-07-03 Thread Nigel Greenlee via 4D_Tech
Robert I have not looked at your report at all. Two things spring to my mind. 1) if the report could be produced in excel could you not use ODBC to extract the data from 4D(Not my prerered option but it it should be feasible) 2) More practically(and something i did recently). Could you not