Paradox primary key case sensitive?

Vinh C. Lam

Delphi Developer

Fri, 11 Mar 2005 01:45:18 GMT

Paradox primary key case sensitive?

Does anyone know how to turn off the case sensitive in paradox primary key?
I have this table that has a primary key in A(20) and the data was store
with upper and lower case and I was not able to to use the findkey or goto
key method to locate the record.
I know I can make sure that record is stored with all upper or lower but I
need to know how to deal with records already created.
Thanks,
Vinh,

Bill Tod

Delphi Developer

Fri, 11 Mar 2005 06:35:42 GMT

Re:Paradox primary key case sensitive?

Paradox primary keys are case sensitive and there is nothing you can
do about that. Either convert the data to all upper or all lower case
or add a secondary index that is case insensitive and use that for
searching.

On Sun, 22 Sep 2002 13:45:18 -0400, "Vinh C. Lam"

Quote

<v...@unionmadecomputers.com> wrote:
>Does anyone know how to turn off the case sensitive in paradox primary key?
>I have this table that has a primary key in A(20) and the data was store
>with upper and lower case and I was not able to to use the findkey or goto
>key method to locate the record.
>I know I can make sure that record is stored with all upper or lower but I
>need to know how to deal with records already created.
>Thanks,
>Vinh,

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Other Threads

1. Howto: enforce case sensitive primary key?

2. Paradox cannot create case-sensitive index?

3. Case sensitive problem of Paradox query engine

4. Case-sensitive in Paradox Tables

5. TQuery is Case Sensitive on Paradox

6. Case Sensitive vs Case-InSensitive

7. Primary key or not primary key.........

8. MS SQL and a mixed-case primary key.

9. Making a Paradox Primary Index case insensitive

10. Case Insensitive primary Index in Paradox 7?