I have an MS SQL database which contains a table which has a datetime field (using ASP Runner 5.1)
I populate this field using a lookup table in order to for the user to select just a time. This has NUMBER, TIME, TIMECONV (with NUMBER being a smallint, Time being a datatime and TIMECONV being a user friendly char field which displays the time in format HH:MM AMorPM). This works great.
I use a Custom view of TIME which formats the time to HH:MM AMorPM. This also works fine when viewing the record i.e. I get 11:00 AM
The problem is that when a user accesses the EDIT page the values they selected on the ADD page disappear and they must select the time again. I have quite a lot of time values (over 50).
Does anyone have any idea why on EDIT the entered values are not appearing as defaults.
Thanks,
Richard <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=7344&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />
