Information générale
Titre:
Merge four tables into 1 cursor
Versions des environnements
I have four tables which are as follows:
1. Simain ( Master File )
i. Sino C(8)
ii. Invdate D(8)
iii. pcode C(10)
iv. Salesman C(19) etc etc.
2. Sisub ( Transacation File )
i. Sino C(8)
ii. icode C(10)
iii. qntymaj N(13,2)
iv. qntymin N(13,2)
v. ratemaj N(13,2)
vi. ratemin N(13,2)
3. Pcode ( Customer File ) ( Relation with simain.dbf )
i. pcode C(10)
ii. pname C(52)
4. Icode ( Item Master File ) ( Relation with sisub.dbf )
i. icode C(10)
ii. full_desc C(52)
I want a cursor like in which it includes all the above fields. Before that a user has to input the following:
1. "from date" (variable mdt1) and "Upto" (Variable mdt2)
2. Salesman Name (Variable msalesman)
3. PartyCode (variable mpcode)
Please guide me to solve this query.
Thanks - Saif
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement