Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Trouble using SqlServer7 in end_user app.

edited October 2002 in End User
I have the following problem using RB 7 with D6 e SQL Server 7:
When run query design in the my end-user app ocurr a error message:
'Data - convert error resulted in overflow'.
Work fine in the Oracle 8i. Is it a Bug?
Debugging, the error ocurr when loading the Table names and EOF achieved
with pipeline.next of procedure GetTableNames of DataDictionary.
Somebody know this problem?
sorry my english.

Weverton Martins.

Comments

  • edited October 2002
    I found this from a post on a sqlmag.com newsgroup by searching in google.
    Try searching for other items on the www.

    "Thanks for your answer, I can now fix the problem.
    It is due to the data truncate when the variable is not big enough to store
    the data from DB. Now it is solved by enlarging the size of variable to hold
    the value returning from db."

    What is the datatype of the field that is causing the problem? Can you
    isolate this field that is causing the problem? Can you reproduce the
    problem with a TADOQuery on a form?

    You can also try disconnecting the data dictionary to help simplify the
    problem.

    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited October 2002
    If you are using the data dictionary tables, then make sure that you are
    using the SQL script that we provide in order to create the tables for the
    end user solution. We have tested RB 7 with MS SQL Server 2000, but we have
    also tested it with SQL Server 7 with RB 7 and it worked fien in our tests.
    I ran it again today in D6, RB 7, and SQL Server 2000 and it all worked
    perfectly. Check the field types that you are usign and make sure they are
    the sam eas the ones that are defined in our SQL script to generate the
    tables. The script is located in the RBuilder\Demos\EndUserDatabases\SQL
    Server directory.

    Cheers,

    Jim Bennett
    Digital Metaphors

This discussion has been closed.