2. ASPRunnerPro General questions
  3. Hidden field blanking database record value
This topic is locked

Hidden field blanking database record value

 		10/18/2006 3:20:27 AM
ASPRunnerPro General questions
C
 ChrisC author

Dear Support
I've a number of hidden date fields on an edit page (using AspRunner4).
On saving the displayed record, all hidden fields are saving 'blank' values to the SQL Server database records. All visible values are updated correctly.
Should I be setting 'dict("field_value') = rs("field_value")' before exiting the form to ensure the hidden values are not lost?
The database date fields type is 'smalldatetime' - would there be a syntax mismatch from the hidden value back to the unchanged database value?
Am I misunderstanding the use of 'hidden' fields and using with existing records when they should only be used with new records?
Any suggestions appreciated.
Chris
J
 		Jane 10/18/2006

Chris,
if you use Hidden View as type for one of your field you need to fill this fields using ASPRunner.

You can use default values on the Edit format dialog on the Formatting tab or Before record added event on the Events tab for this purpose.
C
 		ChrisC author 10/18/2006

Chris,

if you use Hidden View as type for one of your field you need to fill this fields using ASPRunner.

You can use default values on the Edit format dialog on the Formatting tab or Before record added event on the Events tab for this purpose.


Hi Jane
I think I didn't explain clearly.
On my Edit asp page I have fields set when building in AspRunner with 'Edit as' type = 'Hidden field'.
When loaded, for existing records loading into the hidden date fields, when I click save the existing data in the date fields is blanked/empty in the database where there was a value before.
If I set these fields as type 'Read only' or 'Text field', existing data is preserved and all is good.
Issue: hidden date fields are blanking existing values.
Any idea?
Alexey admin 10/18/2006

Chris,
just remove these fields from Edit page on the Choose fields tab in ASPRunner.