Hi,

Here are the details of my environment:

Visual Studio 2008 - .NET CF 3.5 C#

SQL Anywhere 11.0.1.2960 - using an ultralite database

Windows Mobile 6.1 (a Motorola device)

I'm experiencing a crash in the ulnet11.dll when executing the following SQL statement:

SELECT WORK_ORDER_ID FROM REP_WORK_ORDER_HEADER WHERE BLACKOUT_SCHEDULE_CODE NOT IN (SELECT BLACKOUT_SCHEDULE_CODE FROM REP_BLACKOUT_SCHEDULE WHERE TODAY() BETWEEN BEGIN_BLACKOUT_DATE AND END_BLACKOUT_DATE)

I get the following error: ExceptionCode:0x80000002 ExceptionAddress: 0x7841cb70 Offset: 0x0006cb70

at

ULDataReader.ULNET_Cursor_GetRowCount(IntPtr key, Int32 threshold) at ULDataReader.GetRowCount(Int32 threshold) ... I'd attach a picture but I'm new and not allowed :)

If the sub query does not return records, the software does not crash. It only crashes when the sub query returns records.

Please Help!!

Thank you in advance,

Paula