Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2010
    Posts
    4

    Unanswered: SQL Type Mismatch

    I have the following SQL statement on a Paradox 7 database:

    SELECT ScrapbookSchedule.KitName,ScrapbookSchedule.Notes,
    ScrapbookSchedule.PostDate, ScrapbookSchedule.DueDate,
    ScrapbookSchedule.Template
    FROM ScrapbookSchedule
    UNION ALL
    SELECT ScrapbookTeam.Team
    FROM ScrapbookTeam
    ORDER BY ScrapbookSchedule.DueDate

    I get the following error message when the SQL executes:

    "Type mismatch in expression"

    DueDate and PostDate are Date fields and the rest of the fields are alpha fields. The ScrapbookTeam table and ScrapbookSchedule table have a Relational Integrity based on an autoincrement field (TeamSN) in ScrapbookTeam and an integer field in ScrapbookSchedule (TeamSN).

    Why am I getting the error message and what can I do to correct the problem?

  2. #2
    Join Date
    Dec 2007
    Posts
    366
    I can't test it on the machine I'm at, but my guess is the auto-inc and the integer, even tho you're assuming it's not that.. auto-inc fields are a potential disaster, if the table gets damaged.. it is much safer to have a simple "next number" process of your own..
    --
    Steven Green - Myrtle Beach, South Carolina USA

    http://www.OasisTradingPost.com

    Oasis Trading Post
    - Collectibles and Memorabilia
    - Vintage Lego Sets and Supplies
    - and Paradox Support, too

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •