Issue Details (XML | Word | Printable)

Key: CORE-423
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Nickolay Samofatov
Reporter: skopalik
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Parameters missmatch

Created: 26/Dec/01 12:00 AM   Updated: 14/Jun/06 09:39 AM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 1.5.0

Time Tracking:
Not Specified

SF_ID: 496787


 Description  « Hide
SFID: 496787#
Submitted By: skopalik

When you try parametries inner SQL expresion,
server or client library mix parameters.
I tested in delphi with IBX4.62 and BDE5.11.

SQL error code=-303

select
  (select 1 from rdb$database where 1=:ID)
from rdb$database
where
  'now' = :FROM

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alice F. Bird added a comment - 14/Jun/06 09:39 AM
Date: 2002-01-28 00:05
Sender: seanleyne
Logged In: YES
user_id=71163

Is it me, or does this example not make sense? (You can't
assign a value to 'now').