Re>Grouping queries in Wingz
Posted in 1994
In article <2jl5qv$4b0@panix.com> jasonfb@panix.com (Jason Foster-Bey) writes: > How does one perform a "group by" query using the Datalink feature in Wingz > without resorting to the Direct Entry (SQL) box? RTFM is returning null. :) > Thanks. > You need to call DBSetFlags(1) before you send the query: call DB:DBSetFlags(1) call DB:ExecuteCommand(... DBFlags() is an undocumented (at least in my DataLink manual) function which enables or disables some kind of DataLink SQL-parsing which interferes with group by clauses. I think DBFlags(0) "undos" DBFlags(1). Hope this helps, Brian O'Sullivan | e-mail: bosulliv@mitre.org MITRE Corp., Greenbelt MD | Space Program Engineering | ** my opinions, not MITRE's **