sql querry not working ?

• Shital P

  SSC Enthusiast

  Points: 109

  More actions

  July 1, 2006 at 2:47 am

  #68326

  hi !!

  following SQL query is not working on SQL Server

  "Select * from myTable Where True"

  this query gives error "Incorrect syntax near 'True'" on SQLServer

  but on MS Access this query works without error !!

  Pl. help me out

  SPD

• Thomas-253584

  SSChasing Mays

  Points: 639

  More actions

  July 1, 2006 at 3:02 am

  #647095

  hi ,

  what is true ??

  Select * from mytable where willi = true

  This true must be an char in the row.

  What stand in the table please

  Thomas

• Shital P

  SSC Enthusiast

  Points: 109

  More actions

  July 1, 2006 at 3:37 am

  #647096

  in my project I am building up a SQL query according to multiple controls on the form

  Dim strSQL As String

  strSQL = "SELECT this, that, theother FROM mytable WHERE TRUE"

  which will (initially) return all records.

  the code then step through the controls on the form; if the

  control contains anything ...

  strSQL = strSQL & " AND [fieldname] = '" & Me!controlname & "'"

  to the growing SQL string. If the control is empty, just leave strSQL

  alone.

  this code works on MS Access , but on SQL Server I am getting error

  "Incorrect syntax near 'True'"

  pl. suggest some sol on this prob.

  thanx

  SPD

• Thomas-253584

  SSChasing Mays

  Points: 639

  More actions

  July 1, 2006 at 6:27 am

  #647099

  Sorry i dont understand your Problem .

  Is true an Row ??

  So i think you do this:

  Dim strSQL As String

  strSQL = "SELECT this, that, theother FROM mytable WHERE "

  strSQL = strSQL & " [fieldname] = '" & Me!controlname & "'"

  But why you dont do it in one way??

  if Me!controlname "" then

  dim strSQL as String =

  Dim strSQL As String

  strSQL = "SELECT this, that, theother FROM mytable WHERE [fieldname] = '" & Me!controlname & "'"

  else

  strSQL = "SELECT this, that, theother FROM mytable"

  end if

  or by your way:

  Dim strSQL As String

  if Me!controlname "" then

  strSQL = "SELECT this, that, theother FROM mytable where [fieldname] = '" & Me!controlname & "'"

  Else

  strSQL = "SELECT this, that, theother FROM mytable"

  end if

  Greetings Thomas

• Shital P

  SSC Enthusiast

  Points: 109

  More actions

  July 1, 2006 at 6:33 am

  #647100

  thanx for suggestions.

  but I got solution for my Prob.

  I rewrite query as "SELECT this, that, theother FROM mytable Where 1=1"

  thanx once again

  SPD