TableAdapter configuration wizard problem: no mapping exist

• clai_shock008

  Old Hand

  Points: 306

  More actions

  April 19, 2020 at 8:20 am

  #3743975

  I'm getting this problem message when executing my SQL query:

  "Generated SELECT statement. 'No mapping exists from DbType Object to a known OdbcType."

  My SQL query:

  SELECT hencdiag.diagcode, hadmlog.hpercode, CONCAT(hperson.patlast, ', ', hperson.patfirst, ' ', hperson.patmiddle) AS name, hcity.ctyname AS district, haddr.ctycode, 
  hadmlog.disdate
  FROM hadmlog INNER JOIN hperson ON hadmlog.hpercode=hperson.hpercode INNER JOIN haddr ON hadmlog.hpercode=haddr.hpercode INNER JOIN hencdiag ON hadmlog.enccode=hencdiag.enccode INNER JOIN hcity ON haddr.ctycode=hcity.ctycode
  WHERE (hcity.ctyname = ?) AND (hencdiag.diagcode IN (?, ?)) AND (hadmlog.disdate >= ?) AND (hadmlog.disdate <= ?) AND 
  (hencdiag.primediag = 'Y') AND (hencdiag.tdcode = 'FINDX') AND (haddr.haddrdte =
  (SELECT MAX(haddrdte)
  FROM haddr
  WHERE (haddr.hpercode = hperson.hpercode)))
  ORDER BY name

   

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  April 20, 2020 at 9:10 am

  #3744208

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.