setting ado recordsource at run time

• • Reply

  19 years ago

  by UltimateWilliam

  UltimateWilliam

  , United States

  Joined 19 years ago

  
  i'm setting a new recordsource on my ado data control at run time but it seems like its not working. . .
  

  
  adodc.RecordSource = "select * from EMPLOYEE where EMPLOYEE.DOB between dtpFromDate.value and dtpToDate.value"
  

  
  dtpFromDate and dtpToDate  date DTPicker controls on a form.
  

  
  this should display the records on a data grid but doesn't.
  

  
  pls help
  thanks!
  

  Report abuse
• • Reply

  19 years ago

  by CodeWarrior76

  CodeWarrior

  Calgary, CA, United States

  Joined 19 years ago

  Quote:

  adodc.RecordSource = "select * from EMPLOYEE where EMPLOYEE.DOB between dtpFromDate.value and dtpToDate.value"

  
  

  
  you need to concantenate the date picker values into the SQL statement.  right now it thinks that is just the name of a field not that it's a control and you want the value if it.
  

  
  this is how it should be:
  adodc.RecordSource = "select * from EMPLOYEE where EMPLOYEE.DOB between '" & dtpFromDate.value & "' and '" & dtpToDate.value & "'"
  

  
  but one other thing.  Are you using Access or SQL?  if you're using access you'll need this one:
  adodc.RecordSource = "select * from EMPLOYEE where EMPLOYEE.DOB between #" & dtpFromDate.value & "# and #" & dtpToDate.value & "#"
  

  
  The # symbols on either side of the date tell Access that between them is a date value.
  

  Report abuse
• • Reply

  19 years ago

  by UltimateWilliam

  UltimateWilliam

  , United States

  Joined 19 years ago

  thsnks a lot!
  

  
  but i'm using a visual foxpro database so i think it should be using "{ }"

  Report abuse