•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 375,199 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,071 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser:
Views: 261 | Replies: 2
 |
•
•
Join Date: May 2008
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hi list,
After creating a rs with UNION ALL two tables it's possible know record by
record the original table source (using any extra SQL feature or something
else)
SQL = "SELECT * FROM tabA UNION ALL SELECT * FROM tabB ORDER BY field"
Set rs = db.OpenRecordset(SQL)
Thanks
Fernando
After creating a rs with UNION ALL two tables it's possible know record by
record the original table source (using any extra SQL feature or something
else)
SQL = "SELECT * FROM tabA UNION ALL SELECT * FROM tabB ORDER BY field"
Set rs = db.OpenRecordset(SQL)
Thanks
Fernando
•
•
Join Date: Jul 2007
Location: Philippines
Posts: 160
Reputation:
Rep Power: 0
Solved Threads: 16
Junior Poster
I don't know what you really mean but if you mean that to look in a PER record I think you do the loop statement.
ie.
ie.
SQL = "SELECT * FROM tabA UNION ALL SELECT * FROM tabB ORDER BY field"
Set rs = db.OpenRecordset(SQL)
IF NOT rs.EOF THEN
DO WHILE NOT rs.EOF
Text1.Text=rs!Fieldname1
Text2.Text=rs!Fieldname2
LOOP
END IF Last edited by jireh : May 12th, 2008 at 8:13 pm.
Curiosity! Does it mean ignorance?http://www.martin2k.co.uk/forums/index.php?showforum=4
http://www.a1vbcode.com/a1vbcode/vbforums/Forum3-1.aspx
http://www.developerfusion.co.uk/for...orum&ForumID=4
•
•
Join Date: Nov 2006
Posts: 664
Reputation:
Rep Power: 3
Solved Threads: 92
Practically a Master Poster
Hi,
Try this :
SQL = "SELECT 'MyTableA' As TabName, A.* FROM tabA A UNION ALL SELECT 'MyTableB' As TabName, B.* FROM tabB B ORDER BY field"
Set rs = db.OpenRecordset(SQL)
RS("TabName") Gives you the Table Name
Regards
Veena
Try this :
SQL = "SELECT 'MyTableA' As TabName, A.* FROM tabA A UNION ALL SELECT 'MyTableB' As TabName, B.* FROM tabB B ORDER BY field"
Set rs = db.OpenRecordset(SQL)
RS("TabName") Gives you the Table Name
Regards
Veena
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Visual Basic 4 / 5 / 6 Marketplace
Linear Mode
- Previous Thread: Sendtoback problem
- Next Thread: how to install ijl11.dll
