Recent content by SunnyFara

Tamar, THANK YOU SO MUCH! GENDBC.PRG was exactly what I was looking for. I really appreciate your help. You have saved me a ton of work. Have a good one.

Thanks, I know about CREATE SQL VIEW. What I am trying to do is, I have about 150 views in a VFP database. I need to recreate the database. How can I generate a script of all the existing views so that I don't have to write out all the code or manaully create them one by one?

Thanks so much for the ideas, but unfortunately, none of these actually work. It still says that the field is corrupted. Looks like I will need to recreate every single view. Unbelievable. Does anyone know how to script Foxpro views? Thank you.

Also, I tried editing the property field on the database dbc table directly, as suggested by jrbbldr, but then when I try to open the view it says "property list corrupted." I really appreciate everyone's help.

For the suggestion to rebuild the views to change the remote connection, I thought of that, but I have about 200 views with all different update properties. Do you know of any way to script the existing views?

The DSn change would work, except that several people need access to both databases, so I need to give them different names.

I have a database with remote views. The remote views use ODBC to connect to my SQL db. (The name of the odbc is stored in the view property, "CONNECTNAME", which is read-only.) I made a copy of the VFPdb (and the SQL db) in another location as another dept in my company wants a clone of this...