how to set paramaters to data report for sql statement
hi!
actaully i have a MDI project which makes bills ...so i set up an sql statement for the datareport which is my bill ,where in ,i am passing "billno"(which is char type) as a parameter..i put the following statement in the sql builder
select * from billheader where billno= ?
but in the parameters tab it shows "param1" as a parameter and not "?" ...pls help!
Secondly as i was suggested by u all in order to refresh the bill to the latest data input (datareport)..i added the followng code in the save button code in the mdi form:
(command "bill" is divided in to two parts "billlheader" which is the parent command and "billdetails" which is the child command,both have a relation of one to many via "billno")
Private Sub cmdButtonName_Click()
On Error Resume Next
3)If DataEnvironment1.rsbill.State = adStateOpen Then
DataEnvironment1.rsbill.Close
End If
DataEnvironment1.bill Text6.text
bill.Refresh
bill.Show (vbModal)
Unload bill
End Sub
but this code shows "application error or object error" at line no 3.
pls help!!
