-Dup

[Gula]

I duplicate a record using -Dup, and it works fine,

Now I need to go and edit new record. but CDML stays on the original one. How can I get to newly created one?

[Steve T.]

Hi, Gula! I haven't really used -dup before and it probably depends a lot on how your db is set up. If you have a unique key/match field, maybe you can turn off the auto-increment and use that as an identifier to search for duplicate records. Searching for record 1001, for example, would find 2 records (orig + dup) and you can modify/change the newer one. You would, of course, have to come up with your increment system for new records but that can problaby be done with globals and calc fields. Hmm.. now, I think I remember something about globals being like scripts when used over the web (single-threaded) so maybe that's not such a good idea after all.

I guess it depends on what you're doing. I hope this gives you an idea, though. Maybe you can "tag/mark/flag" the record to be duplicated before it is duplicated. Then, you can find both of those records, de-flag them both, and work on the newer one?

--ST

[Bleppe]

Maybe your "flag"-field could be an automaticly created creation date and time? Perform a find based on some field that is uniqe for the two records (original and dup) and specify a sorting that will show the newest first on the html page containing the CDML?

Depends of course on wether it is possible for you to run a -Find after the duplication...

Bleppe