Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
{oj
Message
 
À
20/07/2003 15:41:50
Cindy Winegarden
Duke University Medical Center
Durham, Caroline du Nord, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Re: {oj
Divers
Thread ID:
00811826
Message ID:
00811999
Vues:
11
>>Yes, the subject of this thread is correct. I get it whenever I try to create a left join in View Designer using MS SQL tables as datasource. The code generated by view designer looks like this:
>>
>>
>>SELECT * FFROM table1 {oj LEFT JOIN table2 ON table1.id = table2.fkId}
>>
>>
>>As long as i am in View Designer, the view behaves ok, it can be saved, I can USE it, but I can't modify it again, because I get "Syntax error". I tried to delete that {oj from SQL window, but view designer keeps putting it back.
>
>Hi Grigore,
>
>The SQL window doesn't reverse engineer the code so changes there won't be saved. However, what I'd do is copy the code from there, fix it and save it in a PRG, and run the PRG to create the view.

I've had this same problem and have been working around it the same way you are. Is this a foxpro bug or is there something else to this I'm missing?
ICQ 10556 (ya), 254117
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform