>We are in the process of converting VFP 6 application to run with an Oracle back-end.
>
>We have solved a number of issues but have run into a brick wall with checking for duplicate record. It looks like Oracle is case sensitve.
>
>We have put a Primary Key on our table.
>
>For Example:
> Table: ChargeCodes
> Primary Key: ChargeCategory Char(4)
> ChargeCode Char(8)
>
>In the VFP world we would build the following index
> INDEX ON Upper(ChargeCategory + ChrageCode) ...
>
>Any thoughts on how to setup a Primary Key in Oracle that is case insensitive?
>
>Help is greatly appreciated.
>
>Vince
It's probably a setting of Oracle... I know SQL Server has to be setup up front with these settings - the default in SQL is case insensitive.


Wayne