Re: Inconsistencies while inserting data into a Database -

[Alan Ljungberg <Alan.Ljungberg@CNPL.ENBRIDGE.COM>]

Hello Ray;
The data you are inserting, where is it coming from?






                    "Sandquist, Ray"
                    <raymond.sandquist@TRI        To:     SQR-USERS@list.iex.net
                    NCOLL.EDU>                    cc:
                    Sent by: "Discussion          Subject:     Inconsistencies 
while inserting data into a  Database -
                    of SQR, Brio
                    Software's database
                    reporting language"
                    <SQR-USERS@list.iex.ne
                    t>


                    02/21/2002 07:11 AM
                    Please respond to
                    sqr-users






Hi All,

I have recently come across some data inconsistencies while performing
inserts into a SQL database using SQR and was hoping someone might have
some
insight.

The Facts: We are currently using SQR Version 4.3.4 against SQL server 2000
running in 7.0 compatibility mode. (we've just upgraded from version 7.0
SQL
server) (The database is PeopleSoft HR Student Admin ver 7.6)

While inserting data into a table some of the data values are getting
truncated. A show statement in the SQR shows the correct value that should
be inserted.  For example:

If I insert 5 rows of data:                             The end results
might be:

row 1  value ABC                                ABC
row 2  value AB                                 A
row 3  value ABC                                A
row 4  value AB                                 AB
row 5  value AB                                 A

This problem is not unique to a specific program, and is inconsistent when
it does occur (if I truncate the data and reload, it is not the same set of
records that are getting truncated.) Has anyone ever experienced a similar
problem? Are there any compatibility issues with SQR 4.3.4 and SQL 2000? Or
with SQL 2000 running in a compatibility mode, that anyone is aware of?

I appreciate any and all responses.


Thanks

Ray Sandquist
Application/Programmer Analyst
Trinity College
Hartford,  CT 06106-3100