>>>Yes the view is in the data enviroment.
>>>
>>>the error is
>>>
>>>error loading file- record number 4. form1
Loading form or the data enviroment:SQL column 'NO_TRANSPORTISTA' is not found.
>>
>>Can you post your SQL here? Is it a simple one-table view? One of the reasons here may be if you have in the view the parallel joins from one table to two others.
>
>The view is actually composed of three tables, so I guess you are right and that is the problem.
>
>can I work around this?
>
>Sergio
You can copy your SQL from View SQL option in View Designer menu and create your view programmatically like:
CREATE SQL VIEW myView AS ;
here goes your copied SQL.
Just don't open it in the View Designer again after that.
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison