IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
amna.s
PS_2569
Parent Co: amna.s
Search amna.s:

Advanced
-Collapse +Expand More Board Options
MOREINFO...
-Collapse +Expand My Moderator Settings
MODERATOROPTONS

BOARDSTATS
Posts: 16064
Threads: 4729
Topics: 95
Boards: 34
Groups: 34
 
   ► MB Lobby ► This Topic!  Print This     

PS_2569 Message Board Activity

  


3 Message Board Posts:


Thread 3 of 3
Thread Starter or a Reply (but not last)  Group

Yesid.B
ODBC Join tables
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.
37 months ago

amna.s
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
14 months ago
Nothing New Since Your Last Visit
1263
Hits

ASP Classic Coding

Thread 2 of 3
Thread Starter or a Reply (but not last)  Group

PS_2569
RE: ODBC Join tables
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
14 months ago
Nothing New Since Your Last Visit
ASP Classic Coding

Thread 1 of 3
Thread Starter or a Reply (but not last)  Group

PS_2569

This is what commonly happe

Posted to MB Topic: Just Conversation « PrestwoodBoards Board
16 months ago
Nothing New Since Your Last Visit
89
Hits

PrestwoodBoards
Sales Website: www.prestwood.com Or visit our legacy sales site: 
legacy.prestwood.com


©1995-2021 Prestwood IT Solutions.   [Security & Privacy]