Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CASE Sensitive SQL-SERVER tables.
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
CASE Sensitive SQL-SERVER tables.
Miscellaneous
Thread ID:
00195568
Message ID:
00195568
Views:
65
I have created remote views of some SQL-SERVER tables and this works fine. The problem I'm running into is that the tables on SQL-SERVER are case sensitive and VFP is taking a table name like GL_MYTABLE and changing it to Gl_mytable in the View Designer. So if I open a view in the view designer I need to change it back to all caps before running the query or it doesn't work. Does anyone know how to prevent VFP from doing this? TIA
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Next
Reply
Map
View

Click here to load this message in the networking platform