Trouble using SqlServer7 in end_user app.

rbuser

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.

digitalmetaphors

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

digitalmetaphors

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