Re: Can't see why error occurs when adding records?

From: Charles C. (binstar_at_aei.ca)
Date: 10/22/04

  • Next message: Al Blake: "ODBC for Dbase?" 
    Date: Fri, 22 Oct 2004 18:49:04 -0400

    The problem was that particular field's width.

    Thanks.

    "Charles C." <binstar@aei.ca> wrote in message
    news:%23UeLHTEuEHA.4040@TK2MSFTNGP09.phx.gbl...
    > Hi,
    >
    > The code below generates an "Unexpected error from external database
    driver
    > (10019)." for the line TSet.m_S12=qsa[11]-qs[11];
    >
    > I am using Clipper database files (dbf) through ODBC.
    >
    > The values are integers just like in the other 3 lines.
    >
    > If I add qsa[11]+qs[11] there is no problem.
    >
    > The error happens only when I subtract and only for a few of the records
    > from which qs[11] is assigned. These records are also no different from
    the
    > other records in that dbf.
    >
    > qsa[11] and qs[11] are both okay integers by themselves.
    >
    > I just cannot see why the error occurs.
    >
    >
    > TSet.AddNew();
    >
    > TSet.m_S10=qsa[9]-qs[9];
    > TSet.m_S11=qsa[10]-qs[10];
    > TSet.m_S12=qsa[11]-qs[11]; //causes error on some recs, rec's fields
    > //are similar to
    others
    > TSet.m_S13=qsa[12]-qs[12];
    >
    > TSet.Update();
    >
    > Thanks.
    >
    >
    >

  • Next message: Al Blake: "ODBC for Dbase?"

    Relevant Pages