Post reply

TableAdapter configuration wizard problem: no mapping exist

  • 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

     

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply