?
Solved

NoPartialCompare option on tables

Posted on 1997-04-07
1
Medium Priority
?
429 Views
Last Modified: 2011-04-14
For some reason NoPartialCompare option on tables does not work for me. Example :
TTable
 Database = DBDEMOS
 TableName = CUSTOMER.DB
 Filter :=   company = 'Kauai'
 foNoPartialCompare = False
 Filtered = True

This should return me one record with company  = 'Kauai Dive Shoppe', but instead I get nothing.
Does anyone know what I'm doing wrong, and if I am, Is there a better way to do this using filters?

Please reply to uspensky@tfn.com

Thanks!

Alex
0
Comment
Question by:alekseiu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 2

Accepted Solution

by:
javiertb earned 300 total points
ID: 1335228
This is not very a elegant solution but it works:
(There must be something wrong with the NoPartialCompare property)

Filter:=([VendorName]>='Kauai') AND ([VendorName]<'Kauaj')
0

Featured Post

What’s Wrong with Your Cloud Strategy ?

Even as many CIOs are embracing a cloud-first strategy, the reality is that moving to the cloud is a lengthy process and the end-state is likely to be a blend of multiple clouds—public and private. Learn why multicloud solutions matter in this webinar by Nimble Storage.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question