Dennis, I did as you suggested but the time entered is not the actual time of entry but of the time the form started. I tried staying on the form and doing multiple entries but the times in the table were as much as one minute off.
James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Wednesday, February 26, 2014 10:30 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: date time I'm assuming you are using a form based on the table, not a variable form. Make the default value of the TimeComp dbedit control = .#NOW you will find this setting under the effects tab of the control. The only time this setting has any effect is when you are inserting a new row, which is what I believe you want. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Wednesday, February 26, 2014 9:41 AM To: RBASE-L Mailing List Subject: [RBASE-L] - date time I have never used the DATETIME data type before. I set up a table with the field Timecomp having a DATETIME datatype On a form I want the DATETIME to show (constantly refreshing). This will be attached to a field above. When they hit a button The row will be saved (along with other info) with this timestamp in the field. So each row will have a different time attached to the row. I tried making a variable on the form equal to the field. Then I added the system variable (date and time) to the form related to the above variable. I put into the FORM timer to REFRESH this variable using the comp ID. I did not see any change. Any suggestions? James Belisle Making Information Systems People Friendly Since 1990
