Adding new fields to current form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a form which users will fill out, and is working great. Now, I would
like to add three new fields to the form...I looked at the database
option...it does have Updating database option, which basically tells it will
create a new column in the database for any new fields added to the current
form.

I just wanna make sure...If I go with that option, my records in database
will still be there, and I will not be losing any data...and also when it
adds new column in the database, for any existing records, will this column
be empty?

Any help will be greatly appreciated!

Thanks,

Shikha
 
Try it on your live/remote site... Export your current live/remote database to your desktop as a
backup.



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

http://www.Ecom-Data.com
==============================================
 
What happens is that the new fields are added to the database in the fpdb
directory in your local web. When you publish, that version is written over
the database on your web. All information gone ... - at least w. FP 2002.
Solution: Copy the current database from the web to your fpdb directory. Do
the update, publish, and check when asked that noone has added info to the
web while you were updating.
 
Not if you make the change on the live/remote site.

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

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