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
