This topic is locked

Time from database not appearing in Edit

1/24/2008 5:29:17 AM
ASPRunnerPro General questions
R
RICHARD96 author

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=':(' />

Sergey Kornilov admin 1/25/2008

Richard,
please post your application to Demo Account (last tab in ASPRunnerPro) and send the URL where I can see this issue to support@xlinesoft.com.