Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help about _genxtab
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Help about _genxtab
Miscellaneous
Thread ID:
00920539
Message ID:
00920539
Views:
115
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
Next
Reply
Map
View

Click here to load this message in the networking platform