Forums
This topic is locked
Queries in Access --> UltraDev
Posted 20 Sep 2001 12:02:48
1
has voted
20 Sep 2001 12:02:48 Ahmad Fariz Hanapiah posted:
I had done a query in access. How do I transfer those to my asp pages?Replies
Replied 20 Sep 2001 12:39:55
20 Sep 2001 12:39:55 Owen Eastwick replied:
If you wish to make a recordset from a Query stored within Access.
Open the Recorset(Query) dialogeue box from the Data Bindings window.
Click the Advanced button in the Recordset palette.
At the bottom of the Advanced Recordset palette you will see the Database Items window.
Click the plus symbol next to the Views, you should now see the Queries stored within the Database.
Click the plus symbol next to the Query you want to work with. You can now see the fields available in the Query. Highlight the Field you want to add to the web page and click the SELECT button, this will build a SELECT statement for you in the SQL window. Repeat this process to add additional fields from your Query or use the WHERE and ORDER BY buttons in a similar manner.
You can take a look at the link at the bottom of the page if you want. I've created several recordsets from Views within the tutorial.
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
Edited by - oeastwick on 09/20/2001 12:40:31
Open the Recorset(Query) dialogeue box from the Data Bindings window.
Click the Advanced button in the Recordset palette.
At the bottom of the Advanced Recordset palette you will see the Database Items window.
Click the plus symbol next to the Views, you should now see the Queries stored within the Database.
Click the plus symbol next to the Query you want to work with. You can now see the fields available in the Query. Highlight the Field you want to add to the web page and click the SELECT button, this will build a SELECT statement for you in the SQL window. Repeat this process to add additional fields from your Query or use the WHERE and ORDER BY buttons in a similar manner.
You can take a look at the link at the bottom of the page if you want. I've created several recordsets from Views within the tutorial.
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
Edited by - oeastwick on 09/20/2001 12:40:31