Data offset by 2 positions

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
rschultz_(Guest)
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

Data offset by 2 positions

Post by rschultz_(Guest) » Fri Mar 26, 2004 1:52 pm

I^m using R&R^s Result Set Browser via the Database / View Result Set option (R&R build 10.1.002). I notice that all of the data is offset by 2 positions. ____For example, one column is ^part number^ which should contain the value ^1234567^. Instead, it contains ^AA12345^, where ^AA^ should be the last 2 characters in the previous column. Then, the next column starts with ^67^ (the last 2 characters of the value that should be in ^part number^. ____This continues across the page like this. Has anyone seen this before?

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Data offset by 2 positions

Post by kfleming » Sun Mar 28, 2004 9:10 am

Does this only occur with a particular report?__What happens if you remove fields from the layout and then add them back one at a time and test the result set each time?____Kathleen__R&R Support

rschultz_(Guest)
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Data offset by 2 positions

Post by rschultz_(Guest) » Wed Mar 31, 2004 10:47 am

The problem went away when I removed fields and re-added them. Thanks.

Post Reply