2. ASPRunnerPro General questions
  3. Error/Bug in program v6.0 build 766
This topic is locked

Error/Bug in program v6.0 build 766

 		1/26/2009 2:51:35 PM
ASPRunnerPro General questions
M
 Maurits author

Hi there,
I think there is a bug in the program v6.0 build 766.
Re-producing the error:
If you have a ms access database with a field 'Date_Time' set as 'date/time'
In the visulal editor:
On the 'Add page':

[indent]

  1. Date format: DD/MM/YYYY English(British)
  2. In the visual editor double click the field and "edit as" click 'Date' on the left and on the right 'any option' to show the date.
  3. Fill in the default value with 'Now()'
  4. Do NOT tick the box 'Apply on the edit page as well'

[/indent]
On the 'Edit page':

[indent]

  1. Double click the 'Date field' and you will see:
  2. Date format: DD/MM/YYYY English(British)
  3. In 'edit as 'Date' is selected in blue
  4. On the right 'any option' is selected
  5. The default value is appearing: 'Now()'

[/indent]

  • Trying to delete the default value 'Now()' on the 'Edit page' is possible without ticking 'Apply on Edit page as well', it still deletes it from the 'Add page'.
  • Also the tick box stays the same on the 'Edit page' it keeps saying 'Apply on Edit page as well' whilst it should be 'Apply on the Add page as well' and this is on 'Edit as' all the option you can choose on the left.
    I have tested it with all fields, text fields, etc it is all the same
    Is there a temporary solution for this problem?
    Kind regards,
    Maurits
J
 		Jane 1/27/2009

Maurits,
it's not a bug.

"Edit as" settings dialog is common for add/edit/search pages. Apply on the edit page as well option is used for edit page only.
M
 		Maurits author 1/27/2009

Maurits,

it's not a bug.

"Edit as" settings dialog is common for add/edit/search pages. Apply on the edit page as well option is used for edit page only.


If i add a default value on the Add Page in the visual editor, it automatically adds it to the Edit Page without ticking the Apply on the edit page as well

When you try to delete the default value on the Edit Pageit deletes the default value on the Add Page
As an example: on Add page, the default value should be Now() and NOT**__ on the Edit Page
It automatically adds it to the Edit Page, without ticking Apply on the edit page as well, trying to delete it from the Edit Pageit automatically deletes it from the Add Page, without ticking the box Apply on the edit page as well
It supposed to stay on the Add Page but not on the Edit Page
For example: If you have a Tasks db with ID, StartDate, EndDate, etc. Add a task to the database with all the fields filled in with default values. Then go to the page Edit, the whole record is showing. But it is over-writing the StartDate in a read only fieldwith the value which has been set on the Add Page which is Now()

This should not happen as it over-writes the StartDate in the database when you save the record.
please help
J
 		Jane 1/28/2009

Maurits,
default value is used on the edit page if you turn on Apply on the edit page as well option only.
lefty 1/28/2009

Maurits,

default value is used on the edit page if you turn on Apply on the edit page as well option only.



I have the same problem with 5.2 build 423

If you need to keep the date as was added ( read only ) option originally without ticking the apply to the edit page ; it still uses the default from the add page when in edit page . It should not as now the date changes to the default value of the add page . ex. today's date not the original record date from the add page.
J
 		Jane 1/29/2009

John,
we've fixed this bug in the ASPRunnerPro 6.0.
Maurits,

It automatically adds it to the Edit Page, without ticking Apply on the edit page as well, trying to delete it from the Edit Page it automatically deletes it from the Add Page, without ticking the box Apply on the edit page as well



"Edit as" settings dialog is common for add, edit and advanced search pages on the Visual Editor tab.
lefty 2/3/2009

John,

we've fixed this bug in the ASPRunnerPro 6.0.
Maurits,
"Edit as" settings dialog is common for add, edit and advanced search pages on the Visual Editor tab.



I upgraded to 6.0 build 766 . The problem above is still happening ie. above. If you use default value on add page ; without ticking add to edit page it still adds the default to the edit page. Now on the edit page if you take out the default value ; it deletes the default on the add page. Is this by design and if so ? how to keep the date from changing if using Now() or Date() or FormatDateTime(Date(),2) on the add page.
If you use the date format for the field (not-read-only)

default=FormatDateTime(Date(),2) (short date no time) on add page ; in an email event it also attaches the time to the date field. The list page looks correct but when it writes to database shows time. ex. 00/00/00 0:00

( access database ) !
J
 		Jane 2/4/2009

John,
Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.