This topic is locked

Finding Examples that work

10/9/2011 6:25:31 PM
ASPRunnerPro General questions
V
vincekg author

I am new to the AspRunnner and having a hard time doing the simplest things. I have read the manual and viewed all of the tutorials. But the problem is that I can not find examples of some key things or working models, with code, to replicate.
Is there a source of working projects that I can play with to learn techniques? Members? PayPal?
I thought I would use the templates as a reference point but they don't even show things that are in the documentation. For instance, I need to create a master to two detail tables on a search of the master. I see Cars as a master/detail example in the documentation but only the mechanics. My simple master / detial did not work and the cars template does not have any relationship between make and model so I can compare to a working example.
I need some practical examples or source of help for the dumb questions. I can not tell a real bug from just me choosing the wrong option check boxes or technique. For instance, if I use views for everything, do I need to / should I define the relationship between tables on the datasource screen? What does it do to the code? Why can I not create relationships between views? When I pick two tables in a view, choose all defaults and Runner blows up on a read where do I start debugging?
Any suggestions would be a great help.

Sergey Kornilov admin 10/9/2011

The best source to start learning is ASPRunnerPro manual (http://xlinesoft.com/asprunnerpro/docs/) and video tutorials (http://xlinesoft.com/asprunnerpro/tutorial.htm). For example I recommend to check 'How to setup master-details relationships' video tutorial.
It would also help to provide some specifics. You can post your tables structure here, show us how they linked and what error message you get. Hard to provide a meaningful advise without seeing what exactly causes the troubles.

V
vincekg author 10/9/2011



The best source to start learning is ASPRunnerPro manual (http://xlinesoft.com/asprunnerpro/docs/) and video tutorials (http://xlinesoft.com/asprunnerpro/tutorial.htm). For example I recommend to check 'How to setup master-details relationships' video tutorial.
It would also help to provide some specifics. You can post your tables structure here, show us how they linked and what error message you get. Hard to provide a meaningful advise without seeing what exactly causes the troubles.


Been there done those. There is not enough detail there to debug problems. More important I am trying to learn not just get the answer to this problem. The documetation tends to say what you can do but not why or what affect it has. For instance, I created a view of a master table and was able to work with the view in a/c/d and list ok. Can I duplicate that view and add functionality for the detail to it?? And on the mechanic, if I go to the datasource screen and create the relationship between the master and the detail table, does it have any effect on my original view. I have had views stop working all of a sudden, is that a reason? Documentation says nothing about what creating a relationship does to project, if any. Is there a reason to create a relationship at the datasource screen? Is it different than adding the same table and relationship at the view?
My table structure could not be simpler. I brought it down to one master and one detail table and still having problems getting it to simply do anything. Could just be a corrupt database or something I selected.
Glad to have you look at the tables but I need examples that work so that I can define best practices and how things SHOULD be done and maybe why.
Thanks

Sergey Kornilov admin 10/9/2011

Still not sure I understand what the exact question and exact problem. Need more specifics.
Just in case - each view and table are independent. If you create a master-details relationship that involve custom views that doesn't affect the original table in any way. Opposite is true as well.

V
vincekg author 10/10/2011



Still not sure I understand what the exact question and exact problem. Need more specifics.
Just in case - each view and table are independent. If you create a master-details relationship that involve custom views that doesn't affect the original table in any way. Opposite is true as well.


I opened a ticket and uploaded one problem where the simplest add does not work.
But again the real question is where do I find working project examples where I can see best practices and see what works and how it works? Is there anyway that I can get access to a working project that includes the most commonly used approaches where I can explore and learn, hands on?
Thanks

Sergey Kornilov admin 10/10/2011

All templates are working projects. Create a brand new project using any of templates that come with ASPRunnerPro and see how things are implemented.

V
vincekg author 10/10/2011



All templates are working projects. Create a brand new project using any of templates that come with ASPRunnerPro and see how things are implemented.


I don't see it. For example, Cars does not even have a join between Make and Model when I create it. All I see are the tables, no validation etc. What am I missing?

Sergey Kornilov admin 10/10/2011

This only means that Cars template did not need master details relationship between Make and Model tables. However there are Master-Details relationship between carscar and carsmore_photo tables. You can assign multiple photos to each car and master-details relationship serves this purpose well.
In any project you can fine all existing relationships between tables right on 'Datasource tables' screen.