The "=" comparison opearator/operation is case sensitive for character values.
>Hello,
>
>i have a application which is developed with Visual Basic. I can access to a .DBC Database with the OLE-DB Provider from VFP. I use ADO to access. But i have problem with the SQL syntax.
>
>Problem:
>THE SOURCE CODE:
>
>01 myconnectString "Provider=VFPOLEDB.1;Data Source=c:\Folder of the 02 Database .dbc;Password='';Collating Sequence=GENERAL"
>
>
>03 Dim XZ as new ADDÒDB.Recordsets
>
>04 XZ.open "Select * from customer where typ = 'PARTNER'", myconnectstring
>
>With this Syntax allways is ok. I have a recordount of 3 Datasets results and this is the true results and it is ok.
>
>But now my Problem:
>
>when i write
>
>04 XZ.open "Select * from customer where typ = 'partner'", myconnectstring
>
>'partner' is here not in Ucase. I have not recordcounts (0). Not results. But i have 3 Partner entries in the Table of customers.
>
>In Visual Fox Pro 7.0 i have not this Problem. It come the same results when i write 'partner' or 'PARTNER'. But i have this Problem with ado when i acces to the database from Visual Basic.
>
>Why?
>
>It is possible to change the Provider settings.
>
>Can You help me!
>
>Thanks
>
>Fehmi
--sb--