MikeL
|
| Posted: 07/18/2002, 12:27 PM |
|
Is there a way to write a date/timestamp to a MSSQL database when a record is opened (not updated or added) using CCS/ASP w/templates?
Thanks
|
|
|
 |
Nicole
|
| Posted: 07/22/2002, 4:52 AM |
|
Mike,
what do you mean by "record is open"? DO you mean when it is viewed in non updatable mode, e.g. on Grid form?
In this case you can create custom form Before Show Row event, where execute the query like:
DB<connection_name>.Execute("update table_name set time_field = " & now() & " where primary_key_name=" & form_name.primary_key_field.Value)
Note, that primary key field should be added to the form.
|
|
|
|
MikeL
|
| Posted: 07/22/2002, 5:56 AM |
|
Thanks Niclole, that's exactly what I was looking for - I did mean when the record was viewed in non-updateable mode.
|
|
|
|
|
