Keep data from previous record in a DAP

  • Thread starter Thread starter Oriol
  • Start date Start date
O

Oriol

I have a DAP to enter new records in a table.

PROBLEM: Some of the records to be entered have most of
the fields
similar but one which is different. It take too much time
to type the
same fields again and again.

I WOULD LIKE: to use the data from the last record
entered, modifying
it and save it as a new record. However when pushing
submit button i
just modify the last record but not add a new one.

If I push new record button all fields became empty and i
have to type
all the data fields all over again.

I hope somebody can help me on that,

Regards,
Oriol
 
uh dont worry about trapping this in the frontend-- use a trigger to archive
the old records and then u just need to compare the most recent log record
with the current data.

i had written a UDF that would return the differences between 2 records--
but its not very pretty.

HTH-- i dont think that i have my UDF aroudn-- it was pretty ugly TSQL
anyways (wrote it 3 years ago)

Aaron
OLAP Developer
 
Back
Top