November 22, 2008 04:32pm pst

1. BillBach 41,748
2. mirtheil 22,152
3. hgodfrey 2,400
4. ShineOn 2,250
5. blue_zee 2,000
5. TKorhan 2,000
7. paquicuba 1,500
8. mlmcc 1,000
9. Hubasan 800
10. ccosby 750
11. Badotz 500
11. bmdgi 500
11. nplib 500

1. mirtheil 197,896
2. BillBach 90,846
3. bhess1 16,178
4. wayne_f... 6,800
5. jbuttery 4,675
6. ShineOn 3,000
7. ch2 2,500
8. hgodfrey 2,400
9. mlmcc 2,375
10. fanopoe 2,000
10. TKorhan 2,000
10. blue_zee 2,000
13. idt 1,500
13. paquicuba 1,500
15. tonyhowa... 1,300
16. NickUpson 1,200
17. samirise 1,000
18. JWEISBROD 999
19. Megalomac 800
19. Hubasan 800
21. DennisL 750
21. Freya28 750
21. ccosby 750
21. EMCIT 750
21. jamcos 750

08.17.2007 at 11:53AM PDT, ID: 22770549

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

6.8

SELECT query not filtering records properly

Asked by itcaptain in Btrieve 4GL Database

Tags: pervasive, sql, select, query

I have our accounting database in a BTREIVE Pervasive SQL 8.5 and am testing a few queries to it through the Pervasive.SQL Data Manger. Through all my experience with SQL I have never seen anything as strange as this.

For example I have a table named TABLE_A with 2 columns COL_X (text) and COL_Y (text). Let's assume TABLE_A has the following data:

COL_X | COL_Y
aa1, 55
aa1, 234
aa2, 40
bb1, 50
bb2, 70

You would think to filter all the records where COL_X = aa1 you would write this query:

SELECT * FROM TABLE_A WHERE COL_X = 'aa1'

However I do not get any results. I then tried the following query:

SELECT * FROM TABLE_A WHERE COL_X LIKE 'aa1%'

And got NO RESULTS.

I then tried the following query:

SELECT * FROM TABLE_A WHERE COL_X LIKE 'aa%' (ommiting the numerical '1' in this case)

And it behaved perfectly giving me all the records (the 1st three in my sample) where there was an "aa".

It's strange the first 2 queries do not work despite the fact there THERE ARE records that match the criteria in the "WHERE" clause.

Why would this be? On a side note my accounting package that uses the Pervasive SQL database is BusinessVision 7.11.Start Free Trial

Keywords: SELECT query not filtering records pro…

	Title
1	Problem with Refresh button on Crystal…
2	Query used to filter 20,000 recor…
3	Query filter 2
4	How do you apply a WHERE and JOIN …
5	SQL Query to filter an aggregate
6	How can I create a query in access to …

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

SELECT query not filtering records properly

Asked by itcaptain in Btrieve 4GL Database

Tags: pervasive, sql, select, query

About this solution