Justin
I would suggest creating a temporary table
DROP TABLE TmpTableName
PROJECT TEMPORARY TmpTableName FROM OriginalTable USI ALL WHERE ......
Your where clause should give you the row you want to edit.
Copy your originalform to NewFormName and make sure to change the
table it is based on.
--You will only do this once
Add 2 buttons to the form one for appending the information to
Save Button - appends the row from TmpTableName to OriginalTable
Abort Button - Does nothing with the data
--
EDIT USI NewFormName
When using DEL DUP every column must match that includes and columns
with the datatype of time.
If you have any columns that are NULL make sure you have EQNULL ON
Buddy
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Geoffrey
Wheeler
Sent: Monday, July 20, 2009 8:24 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Delete Duplicates and Tracking Edit History
Using a form, I am trying to edit rows in a table containing products
and related
information. Instead of editing the row itself, I would like to keep a
record of the
changes by appending a changed row to the table. Each row has a date of
last
update value.
To start, I have an eep project the table with only the record I want to
edit. Next I
immediately append the single record from the projected table to the
original
table, thus having an exact duplicate of the row I want to edit. I then
use an edit
using command with a select function to select just one of the
duplicates.
Now, if I decide not to edit the row, I cancel out of the form, however
I still have a
duplicate entry. My solution for this is to delete duplicate rows upon
closing the
form, yet this command does not work.
My qeustions are:
1)Is there a more ellegant way of achieving this edit history, whereby
keeping the
original row of data?
2)Any ideas why the delete duplicates command does not work?
Thanks,
Justin
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
