This topic is locked

Unable to Edit Master Record if Details Information Linked

2/22/2010 5:55:57 PM
ASPRunnerPro General questions
M
McGowan author

I've discovered something that is rather alarming to me which exists in version 6.1 and 6.2 of ASPRunnerPro but not in 6.0. I have a very simple project, created using tables from the Northwind database. I am trying to display the total amount of an order on the Master list page. In order to do this, I use the 'Subtotal' field from the 'Order Subtotals' query and link it in the Query Designer step of the project. Pretty straight forward and simple. Here is a pic of that:


When I build the project, the information displays fine and I am able to Add New Orders and Order Details with no problem at all. Here is what it displays like:


The problem comes about when I try to Edit a record. I receive this message:


I see no reason why this should act like this. I've tested it in 6.0 thru 6.2. I can even take the project that was just saved in 6.1 or 6.2, open it in 6.0, build again, without making a single change, and it works just fine. That's fine, if I want to use 6.0 but I don't, I want to use 6.2 and would even settle on 6.1 for that matter. Can anyone please help me to understand why this problem exists in versions later than 6.0 and why it exists at all. If this is the way its going to be with versions 6.1 or later, I'm not interested.
By the way, just to make sure that it wasn't the database or the project, I've created more than one test database and project, using different types of scenarios and all of them resulted the same if I tried to display information from the Detail record onto the Master record through a query. And, all of them worked fine in 6.0 but not later.
Thank you,
William

Sergey Kornilov admin 2/23/2010

William,
it would be helpful to know what database type is that. If you use MS Access this error message means IIS user does no have WRITE permissions on database folder.
The second thing to check - make sure Subtotal field doesn't have "Edit" page check box checked off on 'Choose fields' screen. Simply removing it from the Edit page in Visual Editor is not enough.
If nothing helps - post your app to demo account and contact support team directly.

M
McGowan author 2/23/2010

Dear Sergey,
I appreciate your reply, however, I thought I had described the issued clearly enough that it would be obvious that the problem is with the application and not within the project, why else would it work with 6.0 and not later versions? Why else would I be able to take a simple project and build it with 6.0 and works then build it with 6.1 and it doesn't?
The database is MS Access, however, the problem is not with the WRITE permissions. I can ADD, as stated before, but not Edit. The Edit problem is only with the Master record and not the Details. If I remove the Subtotal query from the equation, the problem goes away. The Subtotal field is not on the Edit page; only the List page.
I'll go ahead and post to the demo account.

Sergey Kornilov admin 2/23/2010

Thanks. Open a ticket at http://support.xlinesoft.com once it's done sending URL of your app on Demo Account.

M
McGowan author 2/23/2010

Sergey,
Thank you for the answers by email. I am glad to learn that it wasn't something I was doing wrong but rather is being caused by the new methods in ASPRunnerPro. I'm also glad to know there is a way to deal with it through "Events" in version 6.2. I look forward to seeing the new instructions for doing this in the "soon to be published" updated user manual. I was feeling a little unsure about the product there but your quick responses to my questions has helped boost my confidence.
Thanks,
Will