Hello,
does anybody know what would be the solution for the following message in my ND SQL
Vendor error#2 code is 1 ([Microsoft][ODBC Microsoft Access 97 Driver]
Undefined function 'DISTINCT' in expression.)
I'm using MS Access 97 and I'm SURE that the the MS Access has the Distinct keyword
The way I'm using it is: Distinct (businessTitles.BusinessID). Maybe I'm writing
something
wrong?
Thanks,
Rimma
"Grace Frederick" <[EMAIL PROTECTED]> wrote:
>Have you tried structuring your query so that it only looks for distinct>results? I
>don't know about other databases, but with Oracle, using
>DISTINCT in the query makes it so any duplicate rows are suppressed. That
>way, you don't have to worry about custom code.
>
>-- Grace
>
>Rimma <[EMAIL PROTECTED]> wrote in message
>[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>>
>> Hello my Forum Pals!
>>
>> In my application, I have the Repeated Object which has 4 rows displayed
>from the
>> database. However, the first row is often repeated and therefore, when it
>repeats itself,
>> I want to make sure that it's skipped.
>>
>> The way I wrote my code right now, it displays the first row in the first
>record and doesn't
>> display any following first row. I have to mention this first row has its
>own table,
>> "Businesses", however, in that particular query, it's taken from another
>table
>> "textArticles" (just in case it helps).
>>
>> Here's the code that I'm using. Does anybody have any suggestions? What
>should I
>> change?
>>
>> file://[[SPIDER_EVENT<this_onBeforeDisplayEvent>
>> public int this_onBeforeDisplayEvent(CSpDisplayEvent event)
>> {
>>
>> CSpValue date = CSpider.getUserSessionObject("sesDate");
>>
>> CSpSelect doViewResults = (CSpSelect) CSpider.getDataObject
>("doViewResults");
>> doViewResults.clearDynamicCriteria ();
>> doViewResults.addDynamicCriterion ("textArticles_Date",
>CSpCriteriaSQLObject.EQUAL_TO_STR_OPERATOR, date);
>> doViewResults.execute ();
>>
>> return (PROCEED);
>> }
>> file://]]SPIDER_EVENT<this_onBeforeDisplayEvent>
>> file://[[SPIDER_EVENT<Repeated1_onBeforeRowDisplayEvent>
>> public int Repeated1_onBeforeRowDisplayEvent(CSpDataDrivenVisualEvent
>event)
>> {
>> CSpider.putUserSessionObject("sesRowIndex", (CSpValue) new
>CSpInteger(event.getRowIndex()));
>> return (PROCEED);
>> }
>> file://]]SPIDER_EVENT<Repeated1_onBeforeRowDisplayEvent>
>>
>> file://[[SPIDER_EVENT<cbBusinesses_onBeforeDisplayEvent>
>> public int cbBusinesses_onBeforeDisplayEvent(CSpDisplayEvent event)
>> {
>> if (((CSpInteger) CSpider.getUserSessionObject("sesRowIndex")).intValue()
>== 0) {
>> return (PROCEED);
>> }
>> else {
>> return (SKIP);
>> }
>> }
>> file://]]SPIDER_EVENT<cbBusinesses_onBeforeDisplayEvent>
>>
>> Thanks a lot in advance,
>> Rimma
>>
>> _________________________________________________________________________
>>
>> For help in using, subscribing, and unsubscribing to the discussion
>> forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
>>
>> For dire need help, email: [EMAIL PROTECTED]
>>
>
>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
