Hello,

> I am totally baffled by this one:
>
> ISC ERROR MESSAGE
> Dynamic SQL Error
> SQL error code = -204
> ROWS WITH TIES requires ORDER BY clause
> PHONE

ROWS [WITH TIES] is an InterBase 6.5 feature. Firebird 1.5 doesn't
support it.

Did you backup this database with IB and restore it with Firebird?

Are you connecting via the InterBase or via de Firebird client dll?
(gds32.dll or fbclient.dll)?

> FOR SELECT LEAD_TRACKING_ID,CAST(PHONE AS
> NUMERIC(10,0)),FIRSTNAME,MIDDLENAME,LASTNAME,ADDRESS,CITY,ST_ABBREV,ZIP ||
> '-' || ZIP4,
> CARD_LAST4,CARD_EXP,CARD_ABBREV
> FROM MASTERLEADS,MASTERACTIVITY
> WHERE MASTERLEADS.PHONE = MASTERACTIVITY.PHONE AND MASTERACTIVITY.TRID =
> :TRID
> INTO
>

:LEAD_TRACKING_ID,:PHONE,:FIRSTNAME,:MIDDLENAME,:LASTNAME,:ADDRESS,:CITY,:ST

> ATE,:ZIP,:LAST4,:CARDEXP,:CARDTYPE
> DO BEGIN
> SUSPEND;
> END
>
> I am trying to create this procedure on Firebird 1.5. It used to work

just

> fine on IB 7.1. I just don't get it. I tried putting an ORDER BY PHONE
> after the WHERE clause, but no good. I really sort of need some help

here.

> I cant get information out of db any other way.

With regards,

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