Thread: Query Error = Incorrect sentence in ')'
View Single Post
  #1  
Old 12-26-2009, 11:13 AM
VB.NET VB.NET is offline
Senior Member
  
Join Date: Jun 2009
Posts: 5,161
Default Query Error = Incorrect sentence in ')'
Hi , members this code show error in vb.net 2008 If Con.State = 1 Then Con.Close() Con.Open() Dim strSQL As String Dim dt As DataTable strSQL = "select count(EntryNo) from(Select distinct(EntryNo) from Cash where year(Cash.PmtDat)= '" & yyyy & "')"
__________________
VB.NET
domain name forum
Reply With Quote