Information générale
Catégorie:
Codage, syntaxe et commandes
>>>>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
I'll try that. Thanks a lot Nick.
Sergio
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement