Alpha Video Training
Results 1 to 2 of 2

Thread: Error 1091 "Field types don't match while converting ResultSet to DBF table"

  1. #1
    Member
    Real Name
    Steve Rubin
    Join Date
    Aug 2006
    Posts
    5

    Default Error 1091 "Field types don't match while converting ResultSet to DBF table"

    Just started looking at V8 passive link tables and successfully connected to a remote MySQL database and linked multiple tables; great!

    Two of the tables failed with Error 1091 "Field types don't match while converting ResultSet to DBF table". I narrowed the problem down to Memo fields and it might have something to do with some of the Memo values being empty (null?).

    I have tried setting the advanced field mapping type to RTF Memo and Character but get the same Error.

    So the help I need is:

    1. Is there a list of Error Numbers with more detailed explanations?
    2. Is there an error log I can look at to solve this kind of problem?
    3. What is the problem!

    Many thanks to anyone who can point me in the right direction...

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Error 1091 "Field types don't match while converting ResultSet to DBF table"

    Quote Originally Posted by steve_rubin View Post
    1. Is there a list of Error Numbers
    yes, in the documentation

    Quote Originally Posted by steve_rubin View Post
    with more detailed explanations?
    no
    Quote Originally Posted by steve_rubin View Post
    2. Is there an error log I can look at to solve this kind of problem?
    view the trace window
    Quote Originally Posted by steve_rubin View Post
    3. What is the problem!
    someone would probably have to see one of the problem files

Similar Threads

  1. Field Types Don't Match
    By debwelch in forum Alpha Five Version 6
    Replies: 5
    Last Post: 12-22-2010, 08:54 AM
  2. Keep getting the error:"Conflicting expression data types"
    By lemow in forum Alpha Five Version 7
    Replies: 9
    Last Post: 12-06-2006, 07:36 PM
  3. Obscure "invalid table handle" error
    By brett s in forum Alpha Five Version 7
    Replies: 5
    Last Post: 11-13-2006, 06:44 PM
  4. Error "not an open index" in form calc field
    By Tony Rutherford in forum Alpha Five Version 7
    Replies: 6
    Last Post: 05-29-2006, 01:53 PM
  5. "table not found" error when restructuri
    By Robert Davis in forum Alpha Five Version 5
    Replies: 5
    Last Post: 11-10-2004, 10:14 AM

Bookmarks

Posting Permissions

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