Garrett Fitzgerald wrote: > <snipped> > Also, there's a trick I've started to use lately to save myself some typing: > > TEXT TO lcQuery PRETEXT 15 > SELECT * ; > FROM table1 t1 ; > JOIN table2 t2 ON t1.id = t2.id ; > WHERE t1.value = n1 ; > AND t2.othervalue = n2 ; > ORDER BY t1.date DESC > ENDTEXT > > lcQuery = STRTRAN(lcQuery, ";", "") > > That way, I get autocompletion on the SQL statement, but don't have to > pass the semicolons to the back end. > >
Hey, that's a great tip....thanks, Garrett! _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
