cannot open sql error in vb6 crystal report - TechRepublic
General discussion
October 10, 2009 at 04:57 AM
pramodtiwari

cannot open sql error in vb6 crystal report

by pramodtiwari . Updated 16 years, 9 months ago

crys.DiscardSavedData = True
crys.ReportFileName = App.Path & “\Report\NOCRpt.rpt”
crys.SQLQuery = “”
crys.SQLQuery = “SELECT NOC_Master.`NOCId`, NOC_Master.`NocLNo`,” & _
“NOC_Master.`InsDate`, NOC_Master.`AppName`, NOC_Master.`PlotNo`” & _
” From `NOC_Master` NOC_Master” & _
” where NOC_Master.`NOCId`=” & Val(txtFId) & “”

crys.Action = 1
Exit Sub

This discussion is locked

All Comments