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
