Hi

Why do you use the "^" character?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

> Firebird 1.5 latest build.
> Tested on Windows Me or Windows 2000 pro
> this update :
> update contacts_guest cg set
> cg.frequency = (select count(md.record_no)
> from master_detail md
> where md.contact_code = cg.contact_code and
> md.reservation_type in (9, 16)) ^
> will create this error :
> VP_MINGUS (Client) Wed Mar 03 10:42:49 2004
> C:\PROGRAM FILES\FIREBIRD\FIREBIRD_1_5\bin\fbserver.exe: terminated
> abnormally (3221225477)
>
> This select will create the same problem :
> select md.contact_code, count(md.record_no)
> from master_detail md
> where md.reservation_type in (9, 16)
> group by md.contact_code^