<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><BR><DIV><DIV>Le 17 juin 2005 à 11:39, Ruslan Zasukhin a écrit :</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Lucida Sans" size="3" style="font: 11.0px Lucida Sans">1) stop server</FONT></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Lucida Sans" size="3" style="font: 11.0px Lucida Sans">2) open your db under viSQL</FONT></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Lucida Sans" size="3" style="font: 11.0px Lucida Sans">3) do query<SPAN class="Apple-converted-space"> </SPAN>-- "SELECT Name, ShortName FROM Clients"</FONT></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Lucida Sans" size="3" style="font: 11.0px Lucida Sans"><SPAN class="Apple-converted-space"> </SPAN>works or no ?</FONT></P></BLOCKQUOTE><DIV>Works fine, at last!</DIV><DIV>But (there is a "but"), this does not work :</DIV><DIV>SELECT QuoteNumber, ParentClientID, Clients.Name</DIV><DIV> FROM Quotes, Clients</DIV><DIV> WHERE Quotes.ParentClientID *= Clients.ID</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>--> the app freezes</DIV><BR><BLOCKQUOTE type="cite"> </BLOCKQUOTE><P style="margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Lucida Sans; min-height: 13.0px"><BR></P><BLOCKQUOTE type="cite"> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Lucida Sans" size="3" style="font: 11.0px Lucida Sans">------------</FONT></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Lucida Sans" size="3" style="font: 11.0px Lucida Sans">Another advice:</FONT></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Lucida Sans" size="3" style="font: 11.0px Lucida Sans">You can easy do that you app will be easy work in LOCAL or client server</FONT></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Lucida Sans" size="3" style="font: 11.0px Lucida Sans">mode.<SPAN class="Apple-converted-space"> </SPAN></FONT></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Lucida Sans" size="3" style="font: 11.0px Lucida Sans">What this give?</FONT></P></BLOCKQUOTE><BR></DIV><DIV>Same as with viSQL: simple SQLs work fine, but the one with the JOIN does not.</DIV><DIV>--> the app freezes</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Eric</DIV><BR></BODY></HTML>