hidden fields in dataview columns

Hi,

I had the form and dataview columns working. Then i decided to add a couple of hidden fields to the form. I have added the names of these 2 fields to the dataview column list, but the data isn't showing. I can see the data is there when I view the source of the form.

I am assuming this is because the pre-existing db table needs to have these fields added as columns? Is this done automatically or do I have to do that manually?

Thanks in adv,
- V

Hi maddunr,

once a table was created then any new columns must be added manually, or you can create a complete new table!

Cheers
Max

Hi Max,

Thanks for the quick reply! The notification must have gone to my bulk folder because I didn't see it.

Will I lose all existing info if I create a new table? Adding columns to the existing table is difficult for me because I don't have direct access to the db on our servers.

Anyway, appreciate the response, and perhaps you could consider this a feature request to add columns to the existing table from your app since not all users might have the ability to add tables or columns.

Thanks,
V

Hi maddunr,

When you create a new table, you simply ignore your old table with the old data and a new one is created, so the old table is still there butyou are not adding any new data to it any more.

I will add this to feature requests!

Regards
Max

Max,

Thanks for considering my request.

As for creating the new table, this is not an option because although the old table still exists, there is no visibility into historical the data in the old table - esp if the form has been used for a while.

Thanks,
V

Ok, then you may need to edit this table to add the new fields and continue using it! don't forget to reopen and save the form to reinitialize the auto generated code after the table has been edited!

Regards
Max