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.comNever mistake having a career with having a life.