The Select:

SELECT * FROM CadPFJ
WHERE (CodEmp = 1 AND CodPFJ BETWEEN :CodPFJ and :CodPFJ2 )
AND ((TipPFJ = :TipPFJ ) or (:TipPFJ = 'ForCli' and TipPFJ in ('Fornec', 'Client', 'ForCli')))
ORDER BY CodPFJ

// Monitor //

SELECT * FROM CadPFJ
WHERE (CodEmp = 1 AND CodPFJ BETWEEN ? /* CodPFJ */ and ? /* CodPFJ2 */ )
AND ((TipPFJ = ? /* TipPFJ */ ) or (? /* TipPFJ */ = 'ForCli' and TipPFJ in ('Fornec', 'Client', 'ForCli')))
ORDER BY CodPFJ ASC
PLAN (CADPFJ ORDER RDB$PRIMARY3)
FIELDS = [ Version 1 SQLd 21 SQLn 1
CADPFJ.CODEMP = <NIL> ]
----*/

/*---
[ 23/01/2001 09:44:08 ]
EXECUTE STATEMENT
TR_HANDLE = 17178052
STMT_HANDLE = 17195308
PARAMS = [ Version 1 SQLd 4 SQLn 4
[CODPFJ] = 0
[CODPFJ2] = 2147483647
[TIPPFJ] = 'ForCli'
[TIPPFJ] = <n> '' ] // ==> The problem two parameters with the same name
----*/

The IBO is creating two parameters with the same name.
PHA

I´m using:

Interbase 6.01 Super Server
Servidor Linux Conectiva 5.2

Windows 98 SE
Delphi 5.0
IBO 3.6Cd

PHA




[Non-text portions of this message have been removed]