Web Development

Ask something
Discussion Locked

cannot open sql error in vb6 crystal report

0 helpful
0 replies

by pramodtiwari

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.