• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 461
  • Last Modified:

NoPartialCompare option on tables

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
alekseiu
Asked:
alekseiu
1 Solution
 
javiertbCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now