Regularly when developing and testing with V9 from within Interactive SQL in
Sybase I would do a DELETE FROM tablename
to clear all the entries in a table.

In Sybase Central V11

DELETE FROM tablename

generates the following error

could not execute statement
Run Time SQL Error *** Error *** Assertion Failed 106104
(11.0.1.2044)
Field Unexpected during compilation
SQLCODE=300 ODBC 3 State="HY000"
Line 1 Column 1

However - The following does work

DELETE FROM tabalename WHERE keyvalue = 'somevalue'

Anybody know what is wrong??

IAdditional nformation is that there is a cascade delete RI from the table
in question to subordinates.

"Field unexpected during compilation" is an internal error that should
not occur.

I note you're using the GA build of version 11 - to solve the problem
download and apply the latest EBF to your 11.0.1 installation and retry.

Glenn

Glenn Barber wrote:
--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

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

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/datab...chnicalsupport

Thanks

The Oct 6 Build does seem to solve this problem....so far

Glenn

"Glenn Paulley [Sybase iAnywhere]" <paulley (AT) ianywhere (DOT) com> wrote