General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Access with OLE-DB Provider with ADO in VB
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only