Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Help about _genxtab
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Help about _genxtab
Divers
Thread ID:
00920539
Message ID:
00920539
Vues:
114
Hi All,
i have a trouble from _genxtab. my codes likes below on the form in a method and i am calling it from option group click event .it works fine when run it sing at design time but when i compile my app and click that optiongroup option itgives 1-file doesnt exist from mymethod.line 0 and then when click ignore it show firs SQL result .I've tried to catch it with debuggger but i couldnt ...

please help TIA
Set Safety Off
Set ENGINEBEHAVIOR 70
lctable=SYS(5)+CURDIR()+'PuanHes.dbf'
lcoutput=SYS(5)+CURDIR()+'CrsResult.dbf'
With Thisform
	lcwhere1 = 'between(puantaj.tarih,.txttertar1.value,.txttertar2.value)'
	lcwhere2 = 'between(puantaj.pid,.txtpid1.value,.txtpid2.value)'
	lcwhere3 = " puantaj.statu='CALISAN-A' "

	Lcwhere = lcwhere1 + ' and ' + lcwhere2 + ' and ' + lcwhere3

	Select Transform(personel.pid)+"-"+Alltrim(personel.padi)+" "+Alltrim(personel.psoyadi) As adsoyad, personel.departman,;
		personel.Statu, puantaj.tarih,puantaj.mevcutmu;
		FROM  data03\personel inner Join data03\puantaj  ;
		ON  personel.pid= puantaj.pid    ;
		WHERE &lcwhere;
		ORDER BY personel.departman;
		group By puantaj.tarih,puantaj.pid;
		into Table (lctable)

ENDWITH
Do (_Genxtab) With lcoutput,.T.,.T.,.T.,1,4,5,.T.,0,.F.
BROWSE
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform