Whole database was created in FB 1.5. I am currently using IB Workbench
(small world :) ) v1.4.1.4

After DB was created, data pump was used to populate all the records. I am
connecting to it as a firebird server type right now trying to create the
stored procedure. I have also tried it in an SQL session and got the same
thing.

-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@...]
Sent: Thursday, February 03, 2005 2:19 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Complete and Total Loss



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




Yahoo! Groups Links