ODBC Join tables

ODBC Join tables in ASP Classic - Handling Data topic (part of our ASP Classic Coding group).
Quick Search:
ODBC Join
ODBC Join tables
|
|
Yesid.B
|
I am attempting to join two tables through an 'INDEX' field like so:
SELECT w.LOCATION, w.BOLIN, w.DATEIN, w.LOT, w.QTY, w.UNITMEAS, w.CUSTCODE, w.WEIGHT, w.PRODUCTCODE, w."INDEX", w.QUAR FROM wrhse AS w, items AS s WHERE w.DATEOUT IS NULL AND s.poCode ='"+txtpoCode+"' AND w."INDEX" = s."INDEX"
However I am not getting a result.
Initially I was using the following:
sql = 'SELECT * FROM subitemsTEST.DB WHERE poCode = '"+txtpoCode+"' order by index desc'
to get the indexes and from there I would get the data from 'wrhse' having the indexes. But when I get more than 192 rows for some reason the system does not display the complete result set. Why can this be? How can I join two tables?
Thank you in advance.
|
Posted 34 months ago (Thread Starter)
|
|
About Yesid.B |
|
Approved member.
Member subscribes to this thread with a verified email.
Post ID #17105, 10 replies
Thread Started 5/9/2018 7:01:04 AM
View Counter=1219
Last Reply Posted 4/13/2020 12:01:49 AM)
|
|
|
Location=-- --
|
|
| |
|
PS_1117
jobhubnet
|
It is my pride to visit this site repeatedly as it is very useful and delightful for me. This post truly made me happy. Latest Jobs
|
Posted 30 months ago
|
|
About PS_1117 |
|
Membership pending.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #17249 (Level 2)
and Parent is 17105
Reply Posted 9/15/2018 6:52:18 PM
|
|
|
Location=-- USA
|
|
| |
|
PS_1117
jobhubnet
|
It’s remarkable to visit this web site and reading the views of all mates concerning this paragraph i much like this Bepanah video
|
Posted 30 months ago
|
|
About PS_1117 |
|
Membership pending.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #17250 (Level 3)
and Parent is 17105
Reply Posted 9/15/2018 6:53:58 PM
|
|
|
Location=-- USA
|
|
| |
|
PS_1117
jobhubnet
|
My brother recommended I might like this website. He was entirely right i like it very much. This post truly made my day. Watch Tv Dramas You can also try if you like: https://dastaanmohabbat.com Try out this: http://kulfikumar.com This is also awsome: https://kasautizindagi.net Amazing entertainment: https://kasautizindagiki.net Try this one: http://yehmohabbatein.su This one is amazing http://kumkumbhagyadrama.com/category/dil-hi-to-hai
|
Posted 30 months ago
|
|
About PS_1117 |
|
Membership pending.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #17251 (Level 4)
and Parent is 17105
Reply Posted 9/15/2018 6:54:51 PM
|
|
|
Location=-- USA
|
|
| |
|
Anonymous Post
|
Your post is extremely great and gets a piece of very useful information. keep sharing this post. Keep sharing. I visit again on your website
Old UBB Archived Link: [URL=http://www.mahipalpurgirls.in/]Escorts in Delhi[/URL]
Old UBB Archived Link: [URL=http://www.riyamalhotra.in/]Delhi EscortsService[/URL]
Old UBB Archived Link: [URL=http://www.priyasharma.in/]Call Girl in Delhi[/URL]
Old UBB Archived Link: [URL=http://www.riya-panjaban.in/]Delhi Escort[/URL]
|
Posted 15 months ago
|
|
Post ID #17774 (Level 5)
and Parent is 17105
Reply Posted 12/21/2019 4:02:11 AM
|
|
|
 |
|
PS_2450
Delhi Escort
|
|
Posted 15 months ago
|
|
About PS_2450 |
|
Membership pending.
Member subscribes to this thread with a verified email.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #17776 (Level 1.1)
Reply to 17774
and Parent is 17105
Thread Started 12/21/2019 4:11:19 AM
|
|
|
Location=-- USA
|
|
 |
|
PS_2450
Delhi Escort
|
|
Posted 15 months ago
|
|
About PS_2450 |
|
Membership pending.
Member subscribes to this thread with a verified email.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #17778 (Level 1.2)
Reply to 17774
and Parent is 17105
Reply Posted 12/21/2019 4:11:19 AM
|
|
|
Location=-- USA
|
|
| |
|
PS_2450
Delhi Escort
|
|
Posted 15 months ago
|
|
About PS_2450 |
|
Membership pending.
Member subscribes to this thread with a verified email.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #17775 (Level 6)
and Parent is 17105
Reply Posted 12/21/2019 4:10:31 AM
|
|
|
Location=-- USA
|
|
| |
|
PS_2450
Delhi Escort
|
|
Posted 15 months ago
|
|
About PS_2450 |
|
Membership pending.
Member subscribes to this thread with a verified email.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #17777 (Level 7)
and Parent is 17105
Reply Posted 12/21/2019 4:15:00 AM
|
|
|
Location=-- USA
|
|
| |
|
papercoach
PaperCoach
|
Don’t know how to write an essay or a term paper? Count on professionals to do these assignments for you. Click now at papercoach.net and get rid of an academic burden.
|
Posted 14 months ago
|
|
About papercoach |
|
Membership pending.
Member does not subscribe to this thread.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #17814 (Level 8)
and Parent is 17105
Reply Posted 1/14/2020 3:02:52 PM
|
|
|
Location=-- USA
|
|
| |
Most Recent Post
|
PS_2569
SEO
|
If you need a limousine for an important occasion, such as a wedding or a client visit, you need to ensure that your service provider lives up to the expectations of the occasion. https://alternativestips.com/alternatives-of-putlocker
|
Posted 11 months ago
|
|
About PS_2569 |
|
Membership pending.
Member subscribes to this thread with a verified email.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #17992 (Level 9)
and Parent is 17105
Reply Posted 4/13/2020 12:01:17 AM
|
|
|
Location=-- USA
|
|
Revive Thread!
Add a comment to revive this old thread and make this archived thread more useful.
Thread #17105 Counter |
1219 |
Since 5/9/2018
|
|
|