Wrox Home  
Search P2P Archive for: Go

  Return to Index  

pro_vb thread: Urgent!!!!!!, parameter in datareport....


Message #1 by "DSII-Area_Acad=?ISO-8859-1?Q?=E9mica=2F_C=E9?=sar Salas Arbaiza" <csalasa@e...> on Thu, 18 Jan 2001 08:32:33 -0500
I am working in vb6.0 and VfoxPro6.0 for B.D., When i Try to make a Report 
using DataReport, and my sql has a paremter (Adbstr), on my
command1 of course, my host type as string. In the report u can see the hea
der, but the parameter that call details don't see nothing...... 

I send the code: 
******************************** 
Private Sub cmdimprimir_Click() 
Dim x As String 
Dim sq As String 
Dim adoe As ADODB.Recordset 
Dim y As Integer 
x =3D (txtrelalab.Text) 
' *************************
BD.Command1 (x) 
' I think here is the problem, perhaps i mistake in the sentence oder......
....
'****************************
de.Sections("secci=F3n4").Controls("fecha").Caption =3D Date 
de.Sections("secci=F3n4").Controls("apellpat").Caption =3D Trim$(txtapellpa
t.Text) 
de.Sections("secci=F3n4").Controls("apellmat").Caption =3D Trim$(txtapellma
t.Text) 
de.Sections("secci=F3n4").Controls("nombres").Caption =3D Trim$(txtnombres.
Text) 
de.ReportWidth =3D 9000 
de.Orientation =3D rptOrientPortrait 
de.Show 
de.PrintReport True, rptRangeAllPages 
de.Refresh 
de.LeftMargin =3D 50 
BD.rsCommand1.Close 
End Sub 

--
Cesar Enrique Salas Arbaiza.
      D.S.I.I. - U.P.A.O.

--


  Return to Index