Start by reviewing this tech doc:
Handling an Assertion Failure
http://www.ianywhere.com/developer/technotes/sa_how_to_handle_assertion_error.html
--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional
Sybase's iAnywhere Solutions
Please respond ONLY to newsgroup
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
<Frank Lamers> wrote in message news:4648190e.5bb5.1681692777@sybase.com...
> Hello,
>
> i'm getting a assertion error.
> The first SQL statement works fine:
> select distinct(RE102.RE102_ID), RE102.NAAM, * from RE102
> left outer join RE103 on (RE102.RE102_ID = RE103.RE102_ID)
>
> The second statement works fine also:
> select RE103_ID from RE07 where RLE_ID = '006329'
>
> The combination throws an error:
> select distinct(RE102.RE102_ID), RE102.NAAM, * from RE102
> left outer join RE103 on (RE102.RE102_ID = RE103.RE102_ID)
> where RE103_ID not in (select RE103_ID from RE07 where
> RLE_ID = '006329')
>
> The above statement works fine on a version 8 database.
>
> Can anyone please help me?
>
|