maybe you have the DBMS name wrong or the data source pointed to the wrong
file? did you create any copies of this DB when doing any testing?
----- Original Message -----
From: "Mark Weiss" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 05, 2003 11:13 AM
Subject: Re: Witango-Talk: Custom DBMS Actions Witango/Primebase 3.5running
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
