Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Codes modification
Message
De
07/12/2006 23:29:13
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Codes modification
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01175957
Message ID:
01175957
Vues:
46
Dear Experts

Following procedure take a long time to show results.
How to make codes shorten and more speedy.
Select CASH_B
Scan
	Scatter Memvar
	Select VOUCHERS
	Locate For Date = m.date And vou_no = m.balance;
		And vou_type = 'JV'
	If m.dr_amount>0
		Select * From VOUCHERS Where Date = m.date And vou_no = m.balance;
			And vou_type ='JV' Into Cursor xxx

		Select Max(cr_amount) As cr_amount From xxx Into Cursor yyy
		Select yyy
		cr1=cr_amount

		Select ACC_CODE From VOUCHERS Where Date = m.date And vou_no = m.balance;
			And vou_type = 'JV' And cr_amount=m.cr1 Into Cursor zzz

		Select zzz
		ac1=ACC_CODE
		Select CASH_B
		Replace ACC_CODE With ac1
endif
endscan
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform