Hello, On Freitag, 20. September 2002 15:31, Boers, Jack wrote: > Hi there, > > I am a complete SQL novice, but need to create an application in C++ that > accesses a SAPDB database. I have several references that include SQL > statements, but I find that not all of the syntax is supported. The point is that M$ tweaks SQL to its own purposes. DISTINCTROW is not the same as DISTINCT. DISTINCTROW may just be removed from the statement without any difference in behaviour. Newer access versions don't use it any more. INNER JOIN is valid sql, but for sapdb (and perhaps for clearness) a rewrite of the query with WHERE and without that many braces (as you have done) is better. The brackets can be dealt with by building the sql string with the right values in place or as Daniel Dittmar wrote by using parameters. Depends on how often the query will be used.
Peter Willadt _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
