Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select statement
Message
 
À
20/06/2002 16:17:24
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00670488
Message ID:
00671001
Vues:
16
In the button that calls the second fomr put this;
mfindrefnumber = 0
DO FORM Whatever && Call the second form
* Now do your stuff based on what the user selected
if mfindrefnumber <> 0

	SELECT * from refdocswithaddress INTO CURSOR SpecificDoc nofilter;
		WHERE refdocswithaddress.number = mfindrefnumber
	
	mDocNum = SpecificDoc.Number
	mLastname = SpecificDoc.Last_name
	mFirstname = SpecificDoc.First_name
	mStatus = SpecificDoc.status
	mSpeciality = SpecificDoc.Speciality
	mAddress1 = SpecificDoc.ClinicAdd1
	mAddress2 = SpecificDoc.ClinicAdd2
	mLocation = SpecificDoc.Location
	mPostalCode = SpecificDoc.PostalCode
	mPhone = SpecificDoc.Phone
	mCell = SpecificDoc.CellNumber
	thisform.refresh()
endif
You don't need to change anything in the called form.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform