2. ASPRunnerPro General questions
  3. Data access
This topic is locked

Data access

 		4/16/2009 12:24:31 PM
ASPRunnerPro General questions
L
 luic author

I have two questions about the data access with ASPRunner 6.0 :
a) At the SQL query stage in ASPRunner, I join two tables (Customer and Order) where Order is the primary table. How can I access the column (say customer name) from the customer table using the DAL syntax? Can you give me examples?
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=11574&image=1&table=forumtopics' class='bbc_emoticon' alt='B)' /> Can I still use the sql connection method in versions prior to version 6 in version 6 where DAL is added?
Thanks.
Chris.
J
 		Jane 4/17/2009

Hi,
you can use standart SQL connection method to select values from joined tables.
Stu 4/17/2009

Chris,
There might be some ideas in my thread http://www.asprunner.com/forums/index.php?showtopic=11474
Regards,
Stu

I have two questions about the data access with ASPRunner 6.0 :

a) At the SQL query stage in ASPRunner, I join two tables (Customer and Order) where Order is the primary table. How can I access the column (say customer name) from the customer table using the DAL syntax? Can you give me examples?
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=40245&image=1&table=forumreplies' class='bbc_emoticon' alt='B)' /> Can I still use the sql connection method in versions prior to version 6 in version 6 where DAL is added?
Thanks.
Chris.
L
 		luic author 4/17/2009

Chris,

There might be some ideas in my thread http://www.asprunner.com/forums/index.php?showtopic=11474
Regards,
Stu