The ODBC driver may not support that function. That would explain you being able to do it in the client but not in the SQL query window.
-----Original Message----- From: Mark Weiss [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 2:14 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Custom DBMS Actions Witango/Primebase 3.5 running on Mac OS 9 Thanks for the try, But no go. Still no results. Mark On 3/5/03 10:14 AM, "Atrix Wolfe" <[EMAIL PROTECTED]> wrote: > mark, try this maybe: > > Select PageTo, count(distinct PageTo) from visits Group By pageTo > > the common.visits could be the problem since you dont need to (and > cant!) specify the name of the datasource within a DBMS since you > already do that in the settings. > > ----- Original Message ----- > From: "Mark Weiss" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; "PrimeBase-Talk" > <[EMAIL PROTECTED]> > Sent: Wednesday, March 05, 2003 10:01 AM > Subject: Witango-Talk: Custom DBMS Actions Witango/Primebase 3.5 > running on Mac OS 9 > > >> Hi, >> >> I am confused as to why this might be the case. >> >> If I run this query in PrimeBase Client 3.0 >> >> Select v1.PageTo, count(distinct v1.PageTo) from common.visits V1 >> Group By v1.pageTo >> >> I get just the results I would expect, >> >> But if I run this in WiTango 4.0 using a custom DBMS action, I get no >> results. >> >> And If I debug and look at the query it shows me: >> >> Select v1.PageTo, count(distinct v1.PageTo) from common.visits V1 >> Group By v1.pageTo >> >> So it is passing exactly the right stuff but no results. >> >> If I do a >> >> select * from common.visits >> >> It returns the right results just fine. So is it the Count function? >> >> So that may be a problem with Tango. Have you every heard of Custom >> DBMS actions not working in Witango/Primebase? >> >> Thanks for any help you can offer. >> >> Mark Weiss >> >> _____________________________________________________________________ >> ___ >> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] >> with unsubscribe witango-talk in the message body > > ______________________________________________________________________ > __ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
