JHaughey Posted October 7, 2013 Share Posted October 7, 2013 This is freaking me out - a little. I have a SQL ESS View with 15 fields in it. When I do a find in that table, it produces bizarre, wrong results. For example if i do a CTRL + F find, and type "5" into a field, it produces multiple records where that value is something other than 5. Has anyone encountered this before? I thought it might be an indexing problem, but I confirmed that the field I am using as an index does contain only unique values. The index field is a row number that gets assigned in the SQL query that produces the view. Is that an issue? Any thoughts are appreciated. Link to comment Share on other sites More sharing options...
Trey Caliva Posted October 9, 2013 Share Posted October 9, 2013 What kind of data type is assigned in the SQL field? Link to comment Share on other sites More sharing options...
JHaughey Posted October 11, 2013 Author Share Posted October 11, 2013 Thanks, Trey. It's a number. (int) After boldly declaring that my key field was unique, of course it turned out not to be. Something about the way the joins were put together in the SQL query created a situation where in some odd cases duplicate values could be returned. I added a row_number to the view to guarantee a unique key. If nothing else, I sure learned some SQL this week! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3998 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now