>That's right - I created a view in the project using Create SQL View. I then opened that view from the project manager and saw the SQL statement that I had coded was changed. In addition, two tables that I had referenced in the SQL command did not even appear in the SQL code of the view.
>
>Are you saying that if you create a view in this manner, you cannot view the SQL code without the assistance of a utility?
>
You can -
DBGETPROP("myview", "View", "SQL")
is one way - it's just easier to use a utility to extract it and get the field and view settings.
>Where do I find GENDBCX?
It may be in the Files here on the UT - there's a couple of utilities at this link.
http://www.levelextreme.com/wconnect/wc.dll?UniversalThread~?2,2,800>
>Thanks
Insanity: Doing the same thing over and over and expecting different results.