Re: Editing and saving DB entry with new ID (index) number

When you edit a record, you are writing the same record back under the same ID (key) with updated
info.

You have to load the record into an Add-Record form, which then inserts the updated record as a new
record in the same or another table in the same or different database within the site. This is
something that the FP database component is not designed to handle, so it must be a hand coded
solution.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================


"Brutus" <brutus@xxxxxxxxxxxxxx> wrote in message
news:Hv-dnQ0VIuP77LLbnZ2dnUVZ_vWtnZ2d@xxxxxxxxxxxxxx
The Frontpage 2003 Database Wizard (DBW) creates an "edit" option. It allows you to select a
record and edit a field. Then it rewrites the modified record back under the same key. I need to
have a different (new) key - have it added as a new record set.


"Thomas A. Rowe" <tarowe@xxxxxxxx> wrote in message news:uhWFMQzhHHA.1220@xxxxxxxxxxxxxxxxxxxxxxx
Unless you are actually changing and saving an existing record back to the same table, you are
not editing the record.

In order to accomplish what you want, which is to load an existing record into Add Record Form,
which would then allow the current record to be modified and submitted to another table, may
require hand coding.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================


"Dave Lagergren" <DaveLagergren@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8B078A42-E431-4C3C-BB6E-3D6B5175774F@xxxxxxxxxxxxxxxx
I need to edit an entry in an access database and then save it as a new
record. I have designed everything with DBW. The update.asp file gets the
edited info and writes it back in the same record. Submission_Form.asp
writes a new record. I can't figure out how to utilize the code in
Submission_Form.asp to save the output of update.asp. It is a huge hunk of
code but I can post it if needed. I created the website with FP 2003.
--
Dave Lagergren
Manager - Data Applications
Wireless Management, Inc
Specializing in cellular wireless applications






.

Relevant Pages

  • Re: Editing and saving DB entry with new ID (index) number
    ... allows you to select a record and edit a field. ... Then it rewrites the ... modified record back under the same key. ... Specializing in cellular wireless applications ...
    (microsoft.public.frontpage.programming)
  • Re: GUI - reopening previous run
    ... If yes, load this file, and set values to your control ... Do you want to get and assign the string in the edit text to ... %make the handles structures available to the main workspace ... % hObject handle to mass ...
    (comp.soft-sys.matlab)
  • Re: Computer Science Logo Style: An Object Oriented Framework for Logo
    ... easy way to delete or edit properties or methods. ... currently loading from separately from the current READER stream! ... do after the load. ... etc.) within the loaded file would read from the file (unless you did an ...
    (comp.lang.logo)
  • RE: Run DLL error at bootup
    ... two ways to fix this or three if you like to edit the registery. ... find that .dll file it wants to load at start up using the find command ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Flash version of phpMyAdmin
    ... to edit a record in phpMyAdmin: ... load the dataset ... But to edit a record in phpMyAdmin (flash): ... > display the data in the interface and recreate the objects and all, ...
    (alt.php)